Write the SQL query that can show which parties have candidates in all districts

Question

There are 3 tables-parties, districts, candidates.

table name: Parties
Column name: party

Conservative
Green
Liberal
Libertarian
Socialist

table:Districts
column names: district

Essex
Malton
Riverdale
Guelph
Halton

table: Candidates
coloumn names : id, name, district, party

1 | Anne Jones | Essex | Liberal
| 2 | Mary Smith | Malton | Liberal
| 3 | Sara Black | Riverdale | Liberal
| 4 | Paul Jones | Essex | Socialist
| 5 | Ed White | Essex | Conservative
| 6 | Jim Kelly | Malton | Liberal
| 7 | Fred Price | Riverdale | Socialist
| 8 | Bill Green | Guelph | Green
| 9 | Garth Adams | Halton | Libertarian
| 10 | Sam Adams | Guelph | Liberal
| 11 | Jill Mackay | Halton | Liberal

Answer 1

Blesson T Sunny

Try this once

Select party from Parties p INNER JOIN Candidates c ON p. party = c. party
INNER JOIN District d ON d. district = c. district

Answer 2

select party from candidates group by party having count(distinct district)>=(select count(distinct district) from districts);

Answer 3

Blesson T Sunny Show your attempt

Answer 4

SELECT party FROM candidates WHERE district='Essex'AND district='Malton'AND district='Riverdale' AND district='Guelph' AND district='Halton';

Answer 5

Hey Blesson, Did you solve it? What's the right working query?

Answer 6

Meet Singh
I tried.but didn't get the right code.

Answer 7

Thanks a lot.It worked.