-- Запрос с использованием 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;