Please help in SQL code and Thank you

來源: 2011-01-08 16:28:50 [舊帖] [給我悄悄話] 本文已被閱讀:

Please help to point out the error(s) in the SQL code:

select
c.cust_nam,
count s.qty_sold
from
customers c and
sales s
where
c.cust_id = s.cust_id,
s.sale_dat >= ‘20100101’,
s.sale_dat <= ‘20101231’
group by
c.cust_nam