Database: soccer_1
Schema: Player_Attributes: id (number), player_fifa_api_id (number), player_api_id (number), date (text), overall_rating (number), potential (number), preferred_foot (text), attacking_work_rate (text), defensive_work_rate (text), crossing (number), finishing (number), heading_accuracy (number), short_passing (number), volleys (number), dribbling (number), curve (number), free_kick_accuracy (number), long_passing (number), ball_control (number), acceleration (number), sprint_speed (number), agility (number), reactions (number), balance (number), shot_power (number), jumping (number), stamina (number), strength (number), long_shots (number), aggression (number), interceptions (number), positioning (number), vision (number), penalties (number), marking (number), standing_tackle (number), sliding_tackle (number), gk_diving (number), gk_handling (number), gk_kicking (number), gk_positioning (number), gk_reflexes (number) | sqlite_sequence: name (text), seq (text) | Player: id (number), player_api_id (number), player_name (text), player_fifa_api_id (number), birthday (text), height (number), weight (number) | League: id (number), country_id (number), name (text) | Country: id (number), name (text) | Team: id (number), team_api_id (number), team_fifa_api_id (number), team_long_name (text), team_short_name (text) | Team_Attributes: id (number), team_fifa_api_id (number), team_api_id (number), date (text), buildUpPlaySpeed (number), buildUpPlaySpeedClass (text), buildUpPlayDribbling (number), buildUpPlayDribblingClass (text), buildUpPlayPassing (number), buildUpPlayPassingClass (text), buildUpPlayPositioningClass (text), chanceCreationPassing (number), chanceCreationPassingClass (text), chanceCreationCrossing (number), chanceCreationCrossingClass (text), chanceCreationShooting (number), chanceCreationShootingClass (text), chanceCreationPositioningClass (text), defencePressure (number), defencePressureClass (text), defenceAggression (number), defenceAggressionClass (text), defenceTeamWidth (number), defenceTeamWidthClass (text), defenceDefenderLineClass (text)

Question: List all country and league names.
SQL: SELECT T1.name ,  T2.name FROM Country AS T1 JOIN League AS T2 ON T1.id  =  T2.country_id

Question: How many leagues are there in England?
SQL: SELECT count(*) FROM Country AS T1 JOIN League AS T2 ON T1.id  =  T2.country_id WHERE T1.name  =  "England"

Question: What is the average weight of all players?
SQL: SELECT avg(weight) FROM Player

Question: What is the maximum and minimum height of all players?
SQL: SELECT max(weight) ,  min(weight) FROM Player

Question: List all player names who have an overall rating higher than the average.
SQL: SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.overall_rating  >  ( SELECT avg(overall_rating) FROM Player_Attributes )

Question: What are the names of players who have the best dribbling?
SQL: SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.dribbling  =  ( SELECT max(overall_rating) FROM Player_Attributes)

Question: List the names of all players who have a crossing score higher than 90 and prefer their right foot.
SQL: SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.crossing  >  90 AND T2.preferred_foot  =  "right"

Question: List the names of all left-footed players who have overall rating between 85 and 90.
SQL: SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.preferred_foot  =  "left" AND T2.overall_rating  >=  85 AND T2.overall_rating  <=  90

Question: What is the average rating for right-footed players and left-footed players?
SQL: SELECT preferred_foot ,  avg(overall_rating) FROM Player_Attributes GROUP BY preferred_foot

Question: Of all players with an overall rating greater than 80, how many are right-footed and left-footed?
SQL: SELECT preferred_foot ,  count(*) FROM Player_Attributes WHERE overall_rating  >  80 GROUP BY preferred_foot

Question: List all of the player ids with a height of at least 180cm and an overall rating higher than 85.
SQL: SELECT player_api_id FROM Player WHERE height  >=  180 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE overall_rating  >  85

Question: List all of the ids for left-footed players with a height between 180cm and 190cm.
SQL: SELECT player_api_id FROM Player WHERE height  >=  180 AND height  <=  190 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE preferred_foot  =  "left"

Question: Who are the top 3 players in terms of overall rating?
SQL: SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id  =  T2.player_api_id ORDER BY overall_rating DESC LIMIT 3

Question: List the names and birthdays of the top five players in terms of potential.
SQL: SELECT DISTINCT T1.player_name ,  T1.birthday FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id  =  T2.player_api_id ORDER BY potential DESC LIMIT 5