SELECT, JOIN va GROUP BY

Dars rejasi

Bu darsda «SELECT, JOIN va GROUP BY» mavzusini amaliy misollar bilan ko'rib chiqamiz.

Kod

SELECT u.first_name, COUNT(e.id) AS kurslar
FROM accounts_user u
JOIN education_enrollment e ON e.user_id = u.id
GROUP BY u.id
ORDER BY kurslar DESC;

Maslahat: kodni o'zingiz yozib ko'ring — nusxalamang.