sql请教 - MS-SQL Server / 疑难问题

有两张表产品表product,销售表proout
--------
产品表product

prono proname price  
00001 电视 3000.00 
00002 空调 2000.00 
00003 床 1000.00 
00004 餐桌 1500.00 
00005 音响 5000.00 
00006 沙发 6000.00 

销售表proout
saledate cusno prono quantity
2002-01-01 00:00:00.000 001 00001 10
2002-01-01 00:00:00.000 001 00002 5
2002-01-01 00:00:00.000 002 00001 5
2002-01-01 00:00:00.000 002 00003 10
2002-01-02 00:00:00.000 001 00001 10
2002-01-02 00:00:00.000 001 00003 20
2002-01-02 00:00:00.000 001 00001 10
2002-01-02 00:00:00.000 003 00004 30
2002-01-03 00:00:00.000 003 00004 10


 prono为外键
写一段sql要求显示销售金额在10万元以下的产品清单？？？？？？？？？

这返回所有的查询
select m.proname 产品名, sum(n.quantity) 销售量 ,
sum(m.price) 销售金额 from product m , proout n
where m.prono = n.prono
group by m.proname

---

SQL code:
select * from
(
select m.proname 产品名, sum(n.quantity) 销售量 ,
sum(m.price) 销售金额 from product m , proout n
where m.prono = n.prono
group by m.proname
)t
where
销售金额<100000

---

SQL code:
----