One Query for all 4 conditions

Question

A dataset with order_no, device_type and discount as columns in “Commercial” table: No. Of orders with—

Device type Desktop and discount<2
Device type Desktop and discount 2-3.5
Device type Android and discount>3.5
Column names others with number of orders that dont satisfy any of the three conditions

Niraj Gautam · Answer

Select *
from  commercial
where (device_type== 'desktop' and discount 《2) or (device_type =='desktop' and (discount 》=2 or discount 《=2));

Similarly you can make multiple condition.