(SELECT coaches.name,sportGroups.location
FROM coaches left JOIN sportGroups
ON coaches.id = sportGroups. coach_id)

UNION

(SELECT coaches.name,sportGroups.location
FROM coaches right JOIN sportGroups
ON coaches.id = sportGroups.coach_id);



SELECT coaches.name, sports.name
FROM coaches JOIN sports
ON coaches.id IN (
SELECT coach_id
FROM sportGroups
WHERE
sportGroups.sport_id = sport_id);


SELECT coaches.name as CoachName,
FROM coaches JOIN sports
ON coaches.id IN (
SELECT coach_id
FROM sportGroups
WHERE
sportGroups.sport_id = sport_id);

SELECT firstStud.name as firstStudent,secondStud.Name as SecondStudent,
sports.new as Sport
FROM students as firstStud JOIN students as secondStud
ON firstStud.id > secondStud.id
JOIN sports ON (firstStud.id IN)(
SELECT student_id
FROM student_sport
WHERE sportGroup_id IN (
SELECT id
FROM sportGroups
WHERE
sportGroups.sport_id = sport.id)
)

AND (secondStud.id IN (SELECT student.id
FROM student.sport
WHERE sportGroup.id IN)(SELECT id FROM sportGroups
WHERE sportGroups.sport.id = sports.id
))

WHERE firstStud.id IN (
SELECT student.id
FROM student.sport
WHERE sportGroups.id IN (
SELECT sportGroups.id
FROM student.sport
WHERE
student.id = secondStud.id
))

ORDER BY sport;