Jelölje be a lefutó aggregáló lekérdezéseket, amelyek nem adnak ' not a GROUP BY expression ' hibát!

Question

Jelölje be a lefutó aggregáló lekérdezéseket, amelyek  nem adnak  ' not a GROUP BY expression ' hibát!

Answer

SELECT pet_friendly, AVG(price) 
 FROM S1_Apartment 
 GROUP BY city, pet_friendly;

Answer

SELECT city, COUNT(*) 
 FROM S1_Apartment 
 GROUP BY city;

Answer

SELECT pet_friendly, AVG(price) 
 FROM S1_Apartment 
 GROUP BY pet_friendly;

Answer

SELECT city, pet_friendly, COUNT(*) 
 FROM S1_Apartment 
 GROUP BY city;

Answer

SELECT city, COUNT(*) 
 FROM S1_Apartment 
 GROUP BY pet_friendly;

Crowdly