GROUPBY1ORDERBY2DESC)SELECTCASEWHEN"sales volume"<10THEN'a $10 Sale Volume'WHEN"sales volume"<50THEN'b Between $10 and $50 Sales Volume'WHEN"sales volume"<100THEN'c Between $50 and $100 Sales Volume'
WHEN"sales volume"<1000THEN'd Between $100 and $1,000 Sales Volume'WHEN"sales volume"<10000THEN'd Between $1,000 and $10,000 Sales Volume'ELSE'e Over $10,000 Sales Volume'endasgroup1, COUNT(*)FROMramishoowGROUPBY1--90