Leemonhell

select store, bill_number, sum(case product when  'Accessory' then quantity else 0 end) quantity
from table_name
where product in ('Flower', 'Accessory')
group by store, bill_number 
having count( distinct product) = 2