Question

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	12	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

1. SELECT ITEM, SUM (QTY) FROM ORDERS GROUP BY ITEM;
2. SELECT ITEM, QTY FROM ORDERS WHERE ORDATE BETWEEN '2023-11-01 ' AND '2023-12-31';
3. SELECT ORDNO, ORDATE FROM ORDERS WHERE ITEM = 'WHEAT' AND RATE>=60;.

Answer 1

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