sports

SELECT * FROM students ORDER BY name;

DELETE FROM students
WHERE egn = "9207186371";

SELECT students.name, sport.name
FROM students
JOIN student_sport ON students.id = student_sport.student_id
JOIN sportgroups ON student_sport.sportGroup_id = sportgroups.id
JOIN sports ON sportgroups.sport_id = sports.id;

SELECT students.name, students.class, sportgroups.id
FROM students
JOIN student_sport ON students.id = student_sport.student_id
JOIN sportgroups ON student_sport = sportgroups.id
WHERE sportgroups.dayOfWeek = "Monday";

SELECT coaches.name
FROM coaches
JOIN sportgroups ON coaches.id = sportgroups.coach_id
JOIN sports ON sportgroups.sport_id = sports.id
Where sports.name = "Football";

SELECT sportgroups.location, sportgroups.hourOfTraining, sportgroups.dayOfWeek
FROM sportgroups
JOIN sports ON sportsgroup.sport_id = sports.id
WHERE sports.name = "Voleyball";

SELECT sports.name
FROM students
JOIN student_sport ON students.id = students_sport.student_id
JOIN sportgroups ON student_sport.sportGroup_id = sportgroups.id
JOIN sports ON sportgroups.sport_id = sports.id
WHERE students.name = "Iliyan Ivanov";

SELECT students.name
FROM students
JOIN student_sport ON students.id = student_sport.student_id
JOIN sportgroups ON student_sport.sportGroup.id = sportgroups.id
JOIN sports ON sportgroups.sport_id = sports.id
JOIN coaches ON sportgroups.coach_id = coaches.id
WHERE sports.name = "Football" AND coaches.name = "Ivan Todorov Petkov";