Hello Everyone! I've been working on this specific statement for a while now and all my attempts are failing. What I'm basically trying to do is create a statement that shows the names of athletes who are NOT playing in any team belonging to a specific school. There are two schools with four sports each. So I have created tables for Athletes, the sports they play, the number of sports they are involved in and the school they are enrolled in. Below is the statement I came up with but I'm having difficulty with it excluding an athlete that is a part of a team in both schools. In this case I want to show the names of athletes who are NOT playing in any sport that belongs to the North Springs school, so basically joining 4 tables. Any assistance I'll be grateful for so I can create the rest of my database. Thanks!

SELECT A.Name FROM Sport JOIN Playing P ON (P.Sport = S.Id) JOIN Athlete A ON (P.Athlete=A.Id) JOIN School Sc ON (S.School=Sc.Id) WHERE Sc.Name != ‘North Springs’;

try this --