16 lines
355 B
SQL
16 lines
355 B
SQL
-- Запрос с использованием view
|
||
|
||
select
|
||
srsc.id_sportsman,
|
||
s.name,
|
||
srsc.pr_count,
|
||
srsc.ss_count
|
||
from
|
||
sportsman_requests_series_count as srsc
|
||
join sportsman as s on srsc.id_sportsman = s.id_sportsman
|
||
where
|
||
s.gender = 'Мужчина'
|
||
and s.club = 'ЛК Парадокс Лучника'
|
||
order by
|
||
srsc.pr_count desc
|
||
limit 10; |