Ok, I'm not sure this is in the right forum, because I'm new here, so please if this is in the wrong one, please don't hate me.
Secondly, I feel a very silly (and scared) asking this, but I'm having a complete mental mind blank. What would this query do?
Select state_represented
From prime_minister
Group by state_represented
Having count(*) >= all
(Select count(*)
From prime_minister
Group by state_represented)
(I have the basic gist of it, but I'm not convinced that I have it correct. By the way, this isn't for any assignment or anything like that. It's a revision question which I just can't seem to wrap my head around.)
Also, to help, is there any other information you would need? (Sorry, if I sound like a complete newb... I am.)