target-benchmark/spider-queries huggingface dataset:
Database: local_govt_mdm (tables: parking_fines)
Question: List the council tax ids and their related cmi cross references of all the parking fines.
SQL: SELECT council_tax_id ,  cmi_cross_ref_id FROM parking_fines
Database: local_govt_mdm (tables: rent_arrears)
Question: How many council taxes are collected for renting arrears ?
SQL: SELECT count(*) FROM rent_arrears
Database: local_govt_mdm (tables: cmi_cross_references, customer_master_index)
Question: What are the distinct cross reference source system codes which are related to the master customer details 'Gottlieb, Becker and Wyman'?
SQL: SELECT DISTINCT T2.source_system_code FROM customer_master_index AS T1 JOIN cmi_cross_references AS T2 ON T1.master_customer_id  =  T2.master_customer_id WHERE T1.cmi_details  =  'Gottlieb ,  Becker and Wyman'
Database: local_govt_mdm (tables: cmi_cross_references, parking_fines)
Question: Which cmi cross reference id is not related to any parking taxes?
SQL: SELECT cmi_cross_ref_id FROM cmi_cross_references EXCEPT SELECT cmi_cross_ref_id FROM parking_fines
Database: local_govt_mdm (tables: cmi_cross_references)
Question: Which distinct source system code includes the substring 'en'?
SQL: SELECT DISTINCT source_system_code FROM cmi_cross_references WHERE source_system_code LIKE '%en%'
Database: party_host (tables: party)
Question: How many parties are there?
SQL: SELECT count(*) FROM party
Database: party_host (tables: party)
Question: Count the number of parties.
SQL: SELECT count(*) FROM party
Database: party_host (tables: party)
Question: List the themes of parties in ascending order of number of hosts.
SQL: SELECT Party_Theme FROM party ORDER BY Number_of_hosts ASC
Database: party_host (tables: party)
Question: What are the themes of parties ordered by the number of hosts in ascending manner?
SQL: SELECT Party_Theme FROM party ORDER BY Number_of_hosts ASC
Database: party_host (tables: party)
Question: What are the themes and locations of parties?
SQL: SELECT Party_Theme ,  LOCATION FROM party
Database: party_host (tables: party)
Question: Give me the theme and location of each party.
SQL: SELECT Party_Theme ,  LOCATION FROM party
Database: party_host (tables: party)
Question: Show the first year and last year of parties with theme "Spring" or "Teqnology".
SQL: SELECT First_year ,  Last_year FROM party WHERE Party_Theme  =  "Spring" OR Party_Theme  =  "Teqnology"
Database: party_host (tables: party)
Question: What are the first year and last year of the parties whose theme is "Spring" or "Teqnology"?
SQL: SELECT First_year ,  Last_year FROM party WHERE Party_Theme  =  "Spring" OR Party_Theme  =  "Teqnology"
Database: party_host (tables: party)
Question: What is the average number of hosts for parties?
SQL: SELECT avg(Number_of_hosts) FROM party
Database: party_host (tables: party)
Question: Compute the average number of hosts for parties.
SQL: SELECT avg(Number_of_hosts) FROM party
Database: party_host (tables: party)
Question: What is the location of the party with the most hosts?
SQL: SELECT LOCATION FROM party ORDER BY Number_of_hosts DESC LIMIT 1
Database: party_host (tables: party)
Question: Which party had the most hosts? Give me the party location.
SQL: SELECT LOCATION FROM party ORDER BY Number_of_hosts DESC LIMIT 1
Database: party_host (tables: host)
Question: Show different nationalities along with the number of hosts of each nationality.
SQL: SELECT Nationality ,  COUNT(*) FROM HOST GROUP BY Nationality
Database: party_host (tables: host)
Question: How many hosts does each nationality have? List the nationality and the count.
SQL: SELECT Nationality ,  COUNT(*) FROM HOST GROUP BY Nationality
Database: party_host (tables: host)
Question: Show the most common nationality of hosts.
SQL: SELECT Nationality FROM HOST GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1
Database: party_host (tables: host)
Question: Which nationality has the most hosts?
SQL: SELECT Nationality FROM HOST GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1
Database: party_host (tables: host)
Question: Show the nations that have both hosts older than 45 and hosts younger than 35.
SQL: SELECT Nationality FROM HOST WHERE Age  >  45 INTERSECT SELECT Nationality FROM HOST WHERE Age  <  35
Database: party_host (tables: host)
Question: Which nations have both hosts of age above 45 and hosts of age below 35?
SQL: SELECT Nationality FROM HOST WHERE Age  >  45 INTERSECT SELECT Nationality FROM HOST WHERE Age  <  35
Database: party_host (tables: party, party_host, host)
Question: Show the themes of parties and the names of the party hosts.
SQL: SELECT T3.Party_Theme ,  T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID
Database: party_host (tables: party, party_host, host)
Question: For each party, return its theme and the name of its host.
SQL: SELECT T3.Party_Theme ,  T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID
Database: party_host (tables: party, party_host, host)
Question: Show the locations of parties and the names of the party hosts in ascending order of the age of the host.
SQL: SELECT T3.Location ,  T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID ORDER BY T2.Age
Database: party_host (tables: party, party_host, host)
Question: For each party, find its location and the name of its host. Sort the result in ascending order of the age of the host.
SQL: SELECT T3.Location ,  T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID ORDER BY T2.Age
Database: party_host (tables: party, party_host, host)
Question: Show the locations of parties with hosts older than 50.
SQL: SELECT T3.Location FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID WHERE T2.Age  >  50
Database: party_host (tables: party, party_host, host)
Question: Which parties have hosts of age above 50? Give me the party locations.
SQL: SELECT T3.Location FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID WHERE T2.Age  >  50
Database: party_host (tables: party, party_host, host)
Question: Show the host names for parties with number of hosts greater than 20.
SQL: SELECT T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID WHERE T3.Number_of_hosts  >  20
Database: party_host (tables: party, party_host, host)
Question: Which parties have more than 20 hosts? Give me the host names for these parties.
SQL: SELECT T2.Name FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID  =  T2.Host_ID JOIN party AS T3 ON T1.Party_ID  =  T3.Party_ID WHERE T3.Number_of_hosts  >  20
Database: party_host (tables: host)
Question: Show the name and the nationality of the oldest host.
SQL: SELECT Name ,  Nationality FROM HOST ORDER BY Age DESC LIMIT 1
Database: party_host (tables: host)
Question: What are the name and the nationality of the host of the highest age?
SQL: SELECT Name ,  Nationality FROM HOST ORDER BY Age DESC LIMIT 1
Database: party_host (tables: party_host, host)
Question: List the names of hosts who did not serve as a host of any party in our record.
SQL: SELECT Name FROM HOST WHERE Host_ID NOT IN (SELECT Host_ID FROM party_host)
Database: party_host (tables: party_host, host)
Question: What are the names of hosts who did not host any party in our record?
SQL: SELECT Name FROM HOST WHERE Host_ID NOT IN (SELECT Host_ID FROM party_host)
Database: storm_record (tables: region)
Question: How many regions do we have?
SQL: SELECT count(*) FROM region
Database: storm_record (tables: region)
Question: Count the number of regions.
SQL: SELECT count(*) FROM region
Database: storm_record (tables: region)
Question: Show all region code and region name sorted by the codes.
SQL: SELECT region_code ,  region_name FROM region ORDER BY region_code
Database: storm_record (tables: region)
Question: What are the codes and names for all regions, sorted by codes?
SQL: SELECT region_code ,  region_name FROM region ORDER BY region_code
Database: storm_record (tables: region)
Question: List all region names in alphabetical order.
SQL: SELECT region_name FROM region ORDER BY region_name
Database: storm_record (tables: region)
Question: What are the names of the regions in alphabetical order?
SQL: SELECT region_name FROM region ORDER BY region_name
Database: storm_record (tables: region)
Question: Show names for all regions except for Denmark.
SQL: SELECT region_name FROM region WHERE region_name != 'Denmark'
Database: storm_record (tables: region)
Question: Return the names of all regions other than Denmark.
SQL: SELECT region_name FROM region WHERE region_name != 'Denmark'
Database: storm_record (tables: storm)
Question: How many storms had death records?
SQL: SELECT count(*) FROM storm WHERE Number_Deaths  >  0
Database: storm_record (tables: storm)
Question: Count the number of storms in which at least 1 person died.
SQL: SELECT count(*) FROM storm WHERE Number_Deaths  >  0
Database: storm_record (tables: storm)
Question: List name, dates active, and number of deaths for all storms with at least 1 death.
SQL: SELECT name ,  dates_active ,  number_deaths FROM storm WHERE number_deaths  >=  1
Database: storm_record (tables: storm)
Question: What are the names, dates active, and number of deaths for storms that had 1 or more death?
SQL: SELECT name ,  dates_active ,  number_deaths FROM storm WHERE number_deaths  >=  1
Database: storm_record (tables: storm)
Question: Show the average and maximum damage for all storms with max speed higher than 1000.
SQL: SELECT avg(damage_millions_USD) ,  max(damage_millions_USD) FROM storm WHERE max_speed  >  1000
Database: storm_record (tables: storm)
Question: What is the average and maximum damage in millions for storms that had a max speed over 1000?
SQL: SELECT avg(damage_millions_USD) ,  max(damage_millions_USD) FROM storm WHERE max_speed  >  1000
Database: storm_record (tables: storm)
Question: What is the total number of deaths and damage for all storms with a max speed greater than the average?
SQL: SELECT sum(number_deaths) ,  sum(damage_millions_USD) FROM storm WHERE max_speed  >  (SELECT avg(max_speed) FROM storm)
Database: storm_record (tables: storm)
Question: Return the total number of deaths and total damange in millions for storms that had a max speed greater than the average.
SQL: SELECT sum(number_deaths) ,  sum(damage_millions_USD) FROM storm WHERE max_speed  >  (SELECT avg(max_speed) FROM storm)
Database: storm_record (tables: storm)
Question: List name and damage for all storms in a descending order of max speed.
SQL: SELECT name ,  damage_millions_USD FROM storm ORDER BY max_speed DESC
Database: storm_record (tables: storm)
Question: What are the names and damage in millions for storms, ordered by their max speeds descending?
SQL: SELECT name ,  damage_millions_USD FROM storm ORDER BY max_speed DESC
Database: storm_record (tables: affected_region)
Question: How many regions are affected?
SQL: SELECT count(DISTINCT region_id) FROM affected_region
Database: storm_record (tables: affected_region)
Question: Count the number of different affected regions.
SQL: SELECT count(DISTINCT region_id) FROM affected_region
Database: storm_record (tables: region, affected_region)
Question: Show the name for regions not affected.
SQL: SELECT region_name FROM region WHERE region_id NOT IN (SELECT region_id FROM affected_region)
Database: storm_record (tables: region, affected_region)
Question: What are the names of regions that were not affected?
SQL: SELECT region_name FROM region WHERE region_id NOT IN (SELECT region_id FROM affected_region)
Database: storm_record (tables: region, affected_region)
Question: Show the name for regions and the number of storms for each region.
SQL: SELECT T1.region_name ,  count(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id
Database: storm_record (tables: region, affected_region)
Question: How many storms occured in each region?
SQL: SELECT T1.region_name ,  count(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id
Database: storm_record (tables: storm, affected_region)
Question: List the name for storms and the number of affected regions for each storm.
SQL: SELECT T1.name ,  count(*) FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id
Database: storm_record (tables: storm, affected_region)
Question: How many regions were affected by each storm?
SQL: SELECT T1.name ,  count(*) FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id
Database: storm_record (tables: storm, affected_region)
Question: What is the storm name and max speed which affected the greatest number of regions?
SQL: SELECT T1.name ,  T1.max_speed FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id ORDER BY count(*) DESC LIMIT 1
Database: storm_record (tables: storm, affected_region)
Question: Return the name and max speed of the storm that affected the most regions.
SQL: SELECT T1.name ,  T1.max_speed FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id ORDER BY count(*) DESC LIMIT 1
Database: storm_record (tables: storm, affected_region)
Question: Show the name of storms which don't have affected region in record.
SQL: SELECT name FROM storm WHERE storm_id NOT IN (SELECT storm_id FROM affected_region)
Database: storm_record (tables: storm, affected_region)
Question: What are the names of storms that did not affect any regions?
SQL: SELECT name FROM storm WHERE storm_id NOT IN (SELECT storm_id FROM affected_region)
Database: storm_record (tables: storm, affected_region)
Question: Show storm name with at least two regions and 10 cities affected.
SQL: SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING count(*)  >=  2 INTERSECT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING sum(T2.number_city_affected)  >=  10
Database: storm_record (tables: storm, affected_region)
Question: What are the names of storms that both affected two or more regions and affected a total of 10 or more cities?
SQL: SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING count(*)  >=  2 INTERSECT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING sum(T2.number_city_affected)  >=  10
Database: storm_record (tables: storm, affected_region)
Question: Show all storm names except for those with at least two affected regions.
SQL: SELECT name FROM storm EXCEPT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING count(*)  >=  2
Database: storm_record (tables: storm, affected_region)
Question: What are the names of storms that did not affect two or more regions?
SQL: SELECT name FROM storm EXCEPT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING count(*)  >=  2
Database: storm_record (tables: region, affected_region, storm)
Question: What are the region names affected by the storm with a number of deaths of least 10?
SQL: SELECT T2.region_name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T3.number_deaths  >=  10
Database: storm_record (tables: region, affected_region, storm)
Question: Return the names of the regions affected by storms that had a death count of at least 10.
SQL: SELECT T2.region_name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T3.number_deaths  >=  10
Database: storm_record (tables: region, affected_region, storm)
Question: Show all storm names affecting region "Denmark".
SQL: SELECT T3.name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.region_name  =  'Denmark'
Database: storm_record (tables: region, affected_region, storm)
Question: What are the names of the storms that affected Denmark?
SQL: SELECT T3.name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.region_name  =  'Denmark'
Database: storm_record (tables: region, affected_region)
Question: Show the region name with at least two storms.
SQL: SELECT T1.region_name FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id HAVING count(*)  >=  2
Database: storm_record (tables: region, affected_region)
Question: What are the names of regions with two or more storms?
SQL: SELECT T1.region_name FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id HAVING count(*)  >=  2
Database: storm_record (tables: region, affected_region, storm)
Question: Find the names of the regions which were affected by the storm that killed the greatest number of people.
SQL: SELECT T2.region_name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id ORDER BY T3.Number_Deaths DESC LIMIT 1
Database: storm_record (tables: region, affected_region, storm)
Question: What are the names of regions that were affected by the storm in which the most people died?
SQL: SELECT T2.region_name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id ORDER BY T3.Number_Deaths DESC LIMIT 1
Database: storm_record (tables: region, affected_region, storm)
Question: Find the name of the storm that affected both Afghanistan and Albania regions.
SQL: SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Afghanistan' INTERSECT SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Albania'
Database: storm_record (tables: region, affected_region, storm)
Question: What are the names of the storms that affected both the regions of Afghanistan and Albania?
SQL: SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Afghanistan' INTERSECT SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Albania'
Database: election (tables: county)
Question: How many counties are there in total?
SQL: SELECT count(*) FROM county
Database: election (tables: county)
Question: Count the total number of counties.
SQL: SELECT count(*) FROM county
Database: election (tables: county)
Question: Show the county name and population of all counties.
SQL: SELECT County_name ,  Population FROM county
Database: election (tables: county)
Question: What are the name and population of each county?
SQL: SELECT County_name ,  Population FROM county
Database: election (tables: county)
Question: Show the average population of all counties.
SQL: SELECT avg(Population) FROM county
Database: election (tables: county)
Question: On average how large is the population of the counties?
SQL: SELECT avg(Population) FROM county
Database: election (tables: county)
Question: Return the maximum and minimum population among all counties.
SQL: SELECT max(Population) ,  min(Population) FROM county
Database: election (tables: county)
Question: What are the maximum and minimum population of the counties?
SQL: SELECT max(Population) ,  min(Population) FROM county
Database: election (tables: election)
Question: Show all the distinct districts for elections.
SQL: SELECT DISTINCT District FROM election
Database: election (tables: election)
Question: What are the distinct districts for elections?
SQL: SELECT DISTINCT District FROM election
Database: election (tables: county)
Question: Show the zip code of the county with name "Howard".
SQL: SELECT Zip_code FROM county WHERE County_name  =  "Howard"
Database: election (tables: county)
Question: What is the zip code the county named "Howard" is located in?
SQL: SELECT Zip_code FROM county WHERE County_name  =  "Howard"
Database: election (tables: election)
Question: Show the delegate from district 1 in election.
SQL: SELECT Delegate FROM election WHERE District  =  1
Database: election (tables: election)
Question: Who is the delegate of district 1 in the elections?
SQL: SELECT Delegate FROM election WHERE District  =  1
Database: election (tables: election)
Question: Show the delegate and committee information of elections.
SQL: SELECT Delegate ,  Committee FROM election
Database: election (tables: election)
Question: What are the delegate and committee information for each election record?
SQL: SELECT Delegate ,  Committee FROM election
Database: election (tables: party)
Question: How many distinct governors are there?
SQL: SELECT count(DISTINCT Governor) FROM party
Database: election (tables: party)
Question: Count the number of distinct governors.
SQL: SELECT count(DISTINCT Governor) FROM party
Database: election (tables: party)
Question: Show the lieutenant governor and comptroller from the democratic party.
SQL: SELECT Lieutenant_Governor ,  Comptroller FROM party WHERE Party  =  "Democratic"
Database: election (tables: party)
Question: Who are the lieutenant governor and comptroller from the democratic party?
SQL: SELECT Lieutenant_Governor ,  Comptroller FROM party WHERE Party  =  "Democratic"
Database: election (tables: party)
Question: In which distinct years was the governor "Eliot Spitzer"?
SQL: SELECT DISTINCT YEAR FROM party WHERE Governor  =  "Eliot Spitzer"
Database: election (tables: party)
Question: Find the distinct years when the governor was named "Eliot Spitzer".
SQL: SELECT DISTINCT YEAR FROM party WHERE Governor  =  "Eliot Spitzer"
Database: election (tables: election)
Question: Show all the information about election.
SQL: SELECT * FROM election
Database: election (tables: election)
Question: Return all the information for each election record.
SQL: SELECT * FROM election
Database: election (tables: election, county)
Question: Show the delegates and the names of county they belong to.
SQL: SELECT T2.Delegate ,  T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District
Database: election (tables: election, county)
Question: What are the delegate and name of the county they belong to, for each county?
SQL: SELECT T2.Delegate ,  T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District
Database: election (tables: election, county)
Question: Which delegates are from counties with population smaller than 100000?
SQL: SELECT T2.Delegate FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T1.Population  <  100000
Database: election (tables: election, county)
Question: Find the delegates who are from counties with population below 100000.
SQL: SELECT T2.Delegate FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T1.Population  <  100000
Database: election (tables: election, county)
Question: How many distinct delegates are from counties with population larger than 50000?
SQL: SELECT count(DISTINCT T2.Delegate) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T1.Population  >  50000
Database: election (tables: election, county)
Question: Count the number of distinct delegates who are from counties with population above 50000.
SQL: SELECT count(DISTINCT T2.Delegate) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T1.Population  >  50000