Загрузка данных

SELECT CONCAT('"', LNAME, '"'), CONCAT('"', COUNT(*), '"'), CONCAT('"', SUM(VES), '"') FROM stud GROUP BY LNAME ORDER BY SUM(VES) DESC;

SELECT CONCAT('"', YEAR(BIRTHDAY), '"'), CONCAT('"', COUNT(*), '"'), CONCAT('"', AVG(ROST), '"'), CONCAT('"', MAX(VES), '"') FROM stud WHERE ROST < 170 GROUP BY YEAR(BIRTHDAY) ORDER BY COUNT(*) ASC;



SELECT CONCAT('"', gruppa.GRUPPA, '"'), CONCAT('"', stud.ROST, '"'), CONCAT('"', COUNT(*), '"') FROM stud, gruppa WHERE stud.FK_GRUPPA_ID = gruppa.GRUPPA_ID GROUP BY gruppa.GRUPPA, stud.ROST;