CBSE · 083Class XII · 2024Section C3 marks
Question 27
2 April 2024 · Computer Science (083)
Consider the table ORDERS given below and write the output of the SQL queries that follow :
| ORDNO | ITEM | QTY | RATE | ORDATE |
|---|---|---|---|---|
| 1001 | RICE | 23 | 120 | 2023-09-10 |
| 1002 | PULSES | 13 | 120 | 2023-10-18 |
| 1003 | RICE | 25 | 110 | 2023-11-17 |
| 1004 | WHEAT | 28 | 65 | 2023-12-25 |
| 1005 | PULSES | 16 | 110 | 2024-01-15 |
| 1006 | WHEAT | 27 | 55 | 2024-04-15 |
| 1007 | WHEAT | 25 | 60 | 2024-04-30 |
(i) SELECT ITEM, SUM(QTY) FROM ORDERS GROUP BY ITEM; (ii) SELECT ITEM, QTY FROM ORDERS WHERE ORDATE BETWEEN '2023-11-01' AND '2023-12-31'; (iii) SELECT ORDNO, ORDATE FROM ORDERS WHERE ITEM = 'WHEAT' AND RATE>=60;
Answer
(i)
| ITEM | SUM(QTY) |
|---|---|
| RICE | 48 |
| PULSES | 29 |
| WHEAT | 80 |
(ii)
| ITEM | QTY |
|---|---|
| RICE | 25 |
| WHEAT | 28 |
(iii)
| ORDNO | ORDATE |
|---|---|
| 1004 | 2023-12-25 |
| 1007 | 2024-04-30 |
Explanation
(i) Sums QTY grouped by ITEM. (ii) Filters by ORDATE within Nov–Dec 2023. (iii) Filters WHEAT rows with RATE>=60.