Write the output (i-iii) for the following SQL commands. TABLE: FASHION ID F01 F02 F03 F04 F05 F06 Product Kajal Foundation Night Cream Day Cream Shampoo Lipstick Price 970 2100 1700 1400 1200 850
Advertisements
Advertisements
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 |
SELECT COUNT (Product) FROM FASHION;SELECT SUM (Price*Qty) FROM FASHION WHERE Product = "Night Cream";SELECT LEFT (Product, 4) FROM FASHION WHERE Price>1500;
Short Answer
Advertisements
Solution
- 6
- 34000
- Foun
Nigh
shaalaa.com
Is there an error in this question or solution?
