Question

Write the output (i-iii) for the following SQL commands.

         TABLE: FASHION

ID	Product	Price	Qty
F01	Kajal	970	10
F02	Foundation	2100	15
F03	Night Cream	1700	20
F04	Day Cream	1400	10
F05	Shampoo	1200	25
F06	Lipstick	850	32

1. SELECT COUNT (Product) FROM FASHION;
2. SELECT SUM (Price*Qty) FROM FASHION WHERE Product = "Night Cream";
3. SELECT LEFT (Product, 4) FROM FASHION WHERE Price>1500;

Answer 1

1. 6
2. 34000
3. Foun
   Nigh