Get a list of athletes who play multiple sports?

Question

SQL

Hello, sorry for such a simple task, but I'm stuck.
I have a table Sports, and there is a table Athlete, I created an intermediate table Athlete Sports. In the query you need:
Get a list of athletes who play several sports, specifying them
I did this:
WHERE [Sport] IN ('Hockey ','Basketball')
but I got a list of athletes involved in at least one of these sports. And I need only athletes who are involved in both sports

Answer 1

make a query against your intermediate table, something like this:

SELECT 
  id_sportsmen 
FROM 
  your_table 
GROUP BY
  id_sportsmen 
HAVING 
  count(*) > 1

Get your desired list

Answer 2

Sports store http://sportuno.com.ua

Answer 3

First you need to choose the people you want to see on your site. It definitely has to be someone famous. I would choose athletes according to the rating of the bookmaker Leon here is a list of the best.

Answer 4

it is better to implement it the way it is done on the Leon page with a promo - more