Матеріали курсу Adatbázis-kezelés (P-MB_B6) та відповіді на тести | moodle.ppke.hu

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

SELECT pet_friendly, AVG(price)

FROM S1_Apartment

GROUP BY city, pet_friendly;

50%

SELECT city, COUNT(*)

FROM S1_Apartment

GROUP BY city;

100%

SELECT city, pet_friendly, COUNT(*)

FROM S1_Apartment

GROUP BY city;

SELECT pet_friendly, AVG(price)

FROM S1_Apartment

GROUP BY pet_friendly;

50%

SELECT city, COUNT(*)

FROM S1_Apartment

GROUP BY pet_friendly;

Переглянути це питання

Crowdly