利用IF函数进行测试,并根据测试结果返回不同值
use sql_store;
select p.product_id,p.name,count(*) as orders,
if(count(*) > 1,'many time','once') as frequency
from products p
join order_items oi
on p.product_id = oi.product_id
group by product_id,name
利用IF函数进行测试,并根据测试结果返回不同值
use sql_store;
select p.product_id,p.name,count(*) as orders,
if(count(*) > 1,'many time','once') as frequency
from products p
join order_items oi
on p.product_id = oi.product_id
group by product_id,name