-
Notifications
You must be signed in to change notification settings - Fork 0
/
select-2.sql
22 lines (21 loc) · 1.26 KB
/
select-2.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- Задача:
-- Вывести топ-5 номера пар в категории Молодежь С класс Латина,
-- в соревновании 'Весенний бал Терпсихоры', по танцy Самба (S).
--
-- ORDER BY
------------------------------------------------------------------------------------------------------------------------
SELECT "s*".couple_id, "s*".place
FROM (SELECT *
FROM ballroom_database.scores as s
WHERE s.competition_category_id = (SELECT cat.competition_category_id
FROM ballroom_database.competition_category as cat
WHERE cat.competition_id =
(SELECT competition_id
FROM ballroom_database.competition as c
WHERE c.competition_name = 'Весенний бал Терпсихоры')
AND cat.dancers_class = 'C'
AND cat.age_category = 'Молодежь'
AND cat.dances_category = 'Latin')
ORDER BY place) as "s*"
WHERE "s*".dance = 'S'
LIMIT 5;