Answers for "mysql multiple count"

mysql multiple count

select count(*) as total_count,
count(if(product='A',1,null)) as A_count,
count(if(product='B',1,null)) as B_count
from product_sales;

Posted by: Guest on September-16-2021

Code answers related to "mysql multiple count"