Answer of 3-C

--1)
SELECT C_HOME, COUNT(Size) FROM Citizen
GROUP BY C_Home
ORDER BY COUNT(Size) DESC;
--2)
SELECT  C_ID, C_NAME FROM Citizen
WHERE C_HOME LIKE 'D%';
--3)
SELECT C_ID, C_NAME FROM Citizen
WHERE Size = (SELECT MAX(Size) FROM Citizen);
--4)
SELECT C_HOME, COUNT(C_HOME) AS Total_Inhabitants FROM Citizen
GROUP BY C_Home
ORDER BY COUNT(C_HOME) DESC;
--5)
SELECT C_HOME, COUNT(C_HOME) AS Total_Inhabitants FROM Citizen
HAVING COUNT(C_HOME) >= 10000
GROUP BY C_Home;