СУБД-Задачи за 17.03

1.
select * from sportGroups
where location = 'Sofia-Lyulin 1';

2.
select * from students
where id = 2;

3.
select * from sportGroups
where location = 'Sofia-Lyulin 1' or location = 'Sofia-Mladost 7';

4.
select * from sports
order by name;

5.
select * from coaches
where egn = '0250054873';

8.
select * from students
where id >= 1 and id <= 3;

9.
select students.name, sports.name
from students join sports
on students.id in(
select student_id
from student_sport
where student_sport.student_id = sports.id
);

10.
select students.name, students.class, sportgroups.id
from students join sportgroups
on students.id in(
select student_id
from student_sport
where student_sport.student_id = sportgroups.id
)
where sportgroups.dayOfWeek = 'Sunday';

11.
select coaches.name, sports.name
from coaches join sports
on coaches.id in(
select coach_id
from sportgroups
where sportgroups.sport_id = sports.id
)
where sports.name = 'football';