统计每种商品购买总数的SQL语句是()。
(A)select item_id,count(*) from user_behavior
(B)select behavior ,count(*) from user_behavior where behavior='buy' group by it em_id
(C)select item_id,count(*) from user_behavior group by item_id
(D)select item_id,count(*) from user_behavior where behavior='buy' group by item_id
参考答案
继续答题:下一题