Queries in SQL
tables are
party(party_code primary key,Partyname)
Poitician(p_no primary key ,p_name ,tel_no,party_code foreign key)
so my question is, I have to find which party has maximum no of politician.

my query is:

select p_name from politician where party_code in( select count(party_code) tot from politician group by party_code having max(tot));

but it does not work