Question

Write the output of the queries (i) to (iv) based on the table, WORKER given below:

TABLE: WORKER

W_ID	F_NAME	L_NAME	CITY	STATE
102	SAHIL	KHAN	KANPUR	UTTAR PRADESH
104	SAMEER	PARIKH	ROOP NAGAR	PUNJAB
105	MARY	JONES	DELHI	DELHI
106	MAHIR	SHARMA	SONIPAT	HARYANA
107	ATHARVA	BHARDWAJ	DELHI	DELHI
108	VEDA	SHARMA	KANPUR	UTTAR PRADESH

1. SELECT F_NAME, CITY FROM WORKER ORDER BY STATE DESC;
2. SELECT DISTINCT (CITY) FROM WORKER;
3. SELECT F_NAME, STATE FROM WORKER WHERE L_NAME LIKE '_HA%';
4. SELECT CITY, COUNT(*) FROM WORKER GROUP BY CITY;

Answer 1

1. 
   

   F_Name	City
   MARY	DELHI
   ATHARVA	DELHI
   MAHIR	SONIPAT
   SAMEER	ROOP NAGAR
   SAHIL	KANPUR
   VEDA	KANPUR

2. DISTINCT(CITY)
   KANPUR
   ROOP NAGAR
   DELHI
   SONIPAT
3. 
   

   F_Name	STATE
   SAHIL	UTTAR PRADESH
   MAHIR	HARYANA
   ATHARVA	DELHI
   VEDA	UTTAR PRADESH

4. 
   

   CITY	COUNT(*)
   KANPUR	2
   DELHI	1
   ROOP NAGAR	2
   SONIPAT	1