/* 1 */
SELECT b.name as ballname, s.name as sportname, bs.value as sportval
From Balls as b
JOIN BallSports as bs ON b.id = bs.ball_id
JOIN Sports as s ON bs.ball_id = s.id
Where bs.value > 0 AND bs.sport_id = 1
order by bs.value desc

/* 2 */
SELECT b.name as ballname, s.name as sportname, bs.value, s.name as colorname, bc.value as colorval
From Balls as b
JOIN BallSports as bs ON b.id = bs.ball_id
JOIN Sports as s ON bs.ball_id = s.id
JOIN BallColors as bc ON b.id = bc.ball_id
JOIN Colors as c ON bc.color_id = s.id
Where bs.value > 0 AND bs.sport_id = 2
order by bs.value desc, bc.value desc

/* 3 */
SELECT TOP 3 b.name as ballname, c.name as colorname
FROM Balls as b
JOIN BallColors as bc ON bc.ball_id = b.id
JOIN Colors as c ON bc.color_id = c.id
where b.id = 1
order by bc.value desc

SELECT TOP 3 b.name as ballname, c.name as sportname
FROM Balls as b
JOIN BallSports as bc ON bc.ball_id = b.id
JOIN Sports as c ON bc.sport_id = c.id
where b.id = 435
order by bc.value desc