请教SQL语句？

[zpingfang]

各位老师，这个语句能把数量求和显示出来，但是数量为零的就不显示了，请问如何能把相加为零的内容也显示出来呢？
select pinming,sum(shuliang) as shuliang,riqi from assj group by pinming

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('assj') IS NOT NULL DROP TABLE assj
GO
CREATE TABLE assj(
	pinming NVARCHAR(10),
	shuliang INT,
	riqi DATETIME	
)
GO
INSERT INTO assj VALUES(N'小白菜',2,'2018-10-10')
INSERT INTO assj VALUES(N'小白菜',3,'2018-10-15')
INSERT INTO assj VALUES(N'大白菜',0,'2018-10-10')

SELECT pinming,
       SUM(shuliang) AS shuliang,
       max(riqi) AS riqi
FROM   assj
GROUP BY
       pinming
/*
pinming    shuliang    riqi
---------- ----------- -----------------------
大白菜        0           2018-10-10 00:00:00.000
小白菜        5           2018-10-15 00:00:00.000
 */

这里为 0 也能显示啊， 你贴下详细的测试数据吧