target-benchmark/spider-queries huggingface dataset:
Database: soccer_2 (tables: tryout)
Question: What are the unique types of player positions in the tryout?
SQL: SELECT count(DISTINCT pPos) FROM tryout
Database: soccer_2 (tables: tryout)
Question: What are the different types of player positions?
SQL: SELECT count(DISTINCT pPos) FROM tryout
Database: soccer_2 (tables: tryout)
Question: How many students got accepted after the tryout?
SQL: SELECT count(*) FROM tryout WHERE decision  =  'yes'
Database: soccer_2 (tables: tryout)
Question: How many students received a yes from tryouts?
SQL: SELECT count(*) FROM tryout WHERE decision  =  'yes'
Database: soccer_2 (tables: tryout)
Question: How many students whose are playing the role of goalie?
SQL: SELECT count(*) FROM tryout WHERE pPos  =  'goalie'
Database: soccer_2 (tables: tryout)
Question: What is the number of students playing as a goalie?
SQL: SELECT count(*) FROM tryout WHERE pPos  =  'goalie'
Database: soccer_2 (tables: player)
Question: Find the max, average and min training hours of all players.
SQL: SELECT avg(HS) ,  max(HS) ,  min(HS) FROM Player
Database: soccer_2 (tables: player)
Question: What is the average, maximum, and minimum for the number of hours spent training?
SQL: SELECT avg(HS) ,  max(HS) ,  min(HS) FROM Player
Database: soccer_2 (tables: college)
Question: What is average enrollment of colleges in the state FL?
SQL: SELECT avg(enr) FROM College WHERE state  =  'FL'
Database: soccer_2 (tables: college)
Question: What is average number of students enrolled in Florida colleges?
SQL: SELECT avg(enr) FROM College WHERE state  =  'FL'
Database: soccer_2 (tables: player)
Question: What are the names of players whose training hours is between 500 and 1500?
SQL: SELECT pName FROM Player WHERE HS BETWEEN 500 AND 1500
Database: soccer_2 (tables: player)
Question: What are the names of players who train between 500 and 1500 hours?
SQL: SELECT pName FROM Player WHERE HS BETWEEN 500 AND 1500
Database: soccer_2 (tables: player)
Question: Find the players whose names contain letter 'a'.
SQL: SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
Database: soccer_2 (tables: player)
Question: Who are the players that have names containing the letter a?
SQL: SELECT DISTINCT pName FROM Player WHERE pName LIKE '%a%'
Database: soccer_2 (tables: college)
Question: Find the name, enrollment of the colleges whose size is bigger than 10000 and location is in state LA.
SQL: SELECT cName ,  enr FROM College WHERE enr  >  10000 AND state = "LA"
Database: soccer_2 (tables: college)
Question: What are the names and enrollment numbers for colleges that have more than 10000 enrolled and are located in Louisiana?
SQL: SELECT cName ,  enr FROM College WHERE enr  >  10000 AND state = "LA"
Database: soccer_2 (tables: college)
Question: List all information about college sorted by enrollment number in the ascending order.
SQL: SELECT * FROM College ORDER BY enr
Database: soccer_2 (tables: college)
Question: What information do you have on colleges sorted by increasing enrollment numbers?
SQL: SELECT * FROM College ORDER BY enr
Database: soccer_2 (tables: college)
Question: List the name of the colleges whose enrollment is greater 18000 sorted by the college's name.
SQL: SELECT cName FROM College WHERE enr  >  18000 ORDER BY cName
Database: soccer_2 (tables: college)
Question: What is the name of every college in alphabetical order that has more than 18000 students enrolled?
SQL: SELECT cName FROM College WHERE enr  >  18000 ORDER BY cName
Database: soccer_2 (tables: player)
Question: Find the name of players whose card is yes in the descending order of training hours.
SQL: SELECT pName FROM Player WHERE yCard  =  'yes' ORDER BY HS DESC
Database: soccer_2 (tables: player)
Question: What are the name of the players who received a card in descending order of the hours of training?
SQL: SELECT pName FROM Player WHERE yCard  =  'yes' ORDER BY HS DESC
Database: soccer_2 (tables: tryout)
Question: Find the name of different colleges involved in the tryout in alphabetical order.
SQL: SELECT DISTINCT cName FROM tryout ORDER BY cName
Database: soccer_2 (tables: tryout)
Question: What are the different names of the colleges involved in the tryout in alphabetical order?
SQL: SELECT DISTINCT cName FROM tryout ORDER BY cName
Database: soccer_2 (tables: tryout)
Question: Which position is most popular among players in the tryout?
SQL: SELECT pPos FROM tryout GROUP BY pPos ORDER BY count(*) DESC LIMIT 1
Database: soccer_2 (tables: tryout)
Question: What was the most popular position at tryouts?
SQL: SELECT pPos FROM tryout GROUP BY pPos ORDER BY count(*) DESC LIMIT 1
Database: soccer_2 (tables: tryout)
Question: Find the number of students who participate in the tryout for each college ordered by descending count.
SQL: SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC
Database: soccer_2 (tables: tryout)
Question: How many students participated in tryouts for each college by descennding count?
SQL: SELECT count(*) ,  cName FROM tryout GROUP BY cName ORDER BY count(*) DESC
Database: soccer_2 (tables: tryout, player)
Question: What is minimum hours of the students playing in different position?
SQL: SELECT min(T2.HS) ,   T1.pPos FROM tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID GROUP BY T1.pPos
Database: soccer_2 (tables: tryout, player)
Question: For each position, what is the minimum time students spent practicing?
SQL: SELECT min(T2.HS) ,   T1.pPos FROM tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID GROUP BY T1.pPos
Database: soccer_2 (tables: college)
Question: What are the names of schools with the top 3 largest size?
SQL: SELECT cName FROM college ORDER BY enr DESC LIMIT 3
Database: soccer_2 (tables: college)
Question: What are the names of the schools with the top 3 largest class sizes?
SQL: SELECT cName FROM college ORDER BY enr DESC LIMIT 3
Database: soccer_2 (tables: college)
Question: What is the name of school that has the smallest enrollment in each state?
SQL: SELECT cName ,  state ,  min(enr) FROM college GROUP BY state
Database: soccer_2 (tables: college)
Question: What is the name of the school with smallest enrollment size per state?
SQL: SELECT cName ,  state ,  min(enr) FROM college GROUP BY state
Database: soccer_2 (tables: tryout, college)
Question: Find the states where have some college students in tryout.
SQL: SELECT DISTINCT state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName
Database: soccer_2 (tables: tryout, college)
Question: What are the different states that have students trying out?
SQL: SELECT DISTINCT state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName
Database: soccer_2 (tables: tryout, college)
Question: Find the states where have some college students in tryout and their decisions are yes.
SQL: SELECT DISTINCT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, college)
Question: What are the different states that had students successfully try out?
SQL: SELECT DISTINCT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: Find the name and college of students whose decisions are yes in the tryout.
SQL: SELECT T1.pName ,  T2.cName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: What are the names of all the players who received a yes during tryouts, and also what are the names of their colleges?
SQL: SELECT T1.pName ,  T2.cName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: Find the name of all students who were in the tryout sorted in alphabetic order.
SQL: SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID ORDER BY T1.pName
Database: soccer_2 (tables: tryout, player)
Question: What are the names of all students who tried out in alphabetical order?
SQL: SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID ORDER BY T1.pName
Database: soccer_2 (tables: tryout, player)
Question: Find the name and hours of the students whose tryout decision is yes.
SQL: SELECT T1.pName ,  T1.HS FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: What are the names and hours spent practicing of every student who received a yes at tryouts?
SQL: SELECT T1.pName ,  T1.HS FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, college)
Question: Find the states of the colleges that have students in the tryout who played in striker position.
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'striker'
Database: soccer_2 (tables: tryout, college)
Question: What are the states of the colleges where students who tried out for the striker position attend?
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'striker'
Database: soccer_2 (tables: tryout, player)
Question: Find the names of the students who are in the position of striker and got a yes tryout decision.
SQL: SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes' AND T2.pPos  =  'striker'
Database: soccer_2 (tables: tryout, player)
Question: What are the names of all students who successfully tried out for the position of striker?
SQL: SELECT T1.pName FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes' AND T2.pPos  =  'striker'
Database: soccer_2 (tables: tryout, college, player)
Question: Find the state of the college which player Charles is attending.
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName JOIN player AS T3 ON T2.pID  =  T3.pID WHERE T3.pName  =  'Charles'
Database: soccer_2 (tables: tryout, college, player)
Question: In which state is the college that Charles attends?
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName JOIN player AS T3 ON T2.pID  =  T3.pID WHERE T3.pName  =  'Charles'
Database: soccer_2 (tables: tryout, player)
Question: Find the average and maximum hours for the students whose tryout decision is yes.
SQL: SELECT avg(T1.HS) ,  max(T1.HS) FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: What is the average and maximum number of hours students who made the team practiced?
SQL: SELECT avg(T1.HS) ,  max(T1.HS) FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, player)
Question: Find the average hours for the students whose tryout decision is no.
SQL: SELECT avg(T1.HS) FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'no'
Database: soccer_2 (tables: tryout, player)
Question: What is the average number of hours spent practicing for students who got rejected?
SQL: SELECT avg(T1.HS) FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T2.decision  =  'no'
Database: soccer_2 (tables: tryout, player)
Question: What is the maximum training hours for the students whose training hours is greater than 1000 in different positions?
SQL: SELECT max(T1.HS) ,  pPos FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T1.HS  >  1000 GROUP BY T2.pPos
Database: soccer_2 (tables: tryout, player)
Question: For each position, what is the maximum number of  hours for students who spent more than 1000 hours training?
SQL: SELECT max(T1.HS) ,  pPos FROM player AS T1 JOIN tryout AS T2 ON T1.pID  =  T2.pID WHERE T1.HS  >  1000 GROUP BY T2.pPos
Database: soccer_2 (tables: tryout, player)
Question: Which colleges do the tryout players whose name starts with letter D go to?
SQL: SELECT T1.cName FROM  tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID WHERE T2.pName LIKE 'D%'
Database: soccer_2 (tables: tryout, player)
Question: Which colleges does each player with a name that starts with the letter D  who tried out go to?
SQL: SELECT T1.cName FROM  tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID WHERE T2.pName LIKE 'D%'
Database: soccer_2 (tables: tryout)
Question: Which college has any student who is a goalie and succeeded in the tryout.
SQL: SELECT cName FROM  tryout WHERE decision  =  'yes' AND pPos  =  'goalie'
Database: soccer_2 (tables: tryout)
Question: What college has a student who successfully made the team in the role of a goalie?
SQL: SELECT cName FROM  tryout WHERE decision  =  'yes' AND pPos  =  'goalie'
Database: soccer_2 (tables: tryout, college, player)
Question: Find the name of the tryout players who are from the college with largest size.
SQL: SELECT T2.pName FROM  tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID WHERE T1.cName  =  (SELECT cName FROM college ORDER BY enr DESC LIMIT 1)
Database: soccer_2 (tables: tryout, college, player)
Question: What are the names of all tryout participants who are from the largest college?
SQL: SELECT T2.pName FROM  tryout AS T1 JOIN player AS T2 ON T1.pID  =  T2.pID WHERE T1.cName  =  (SELECT cName FROM college ORDER BY enr DESC LIMIT 1)
Database: soccer_2 (tables: tryout, college)
Question: What is the state and enrollment of the colleges where have any students who got accepted in the tryout decision.
SQL: SELECT DISTINCT T1.state ,  T1.enr FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: tryout, college)
Question: How many students are enrolled in colleges that have student accepted during tryouts, and in which states are those colleges?
SQL: SELECT DISTINCT T1.state ,  T1.enr FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.decision  =  'yes'
Database: soccer_2 (tables: college)
Question: Find the names of either colleges in LA with greater than 15000 size or in state AZ with less than 13000 enrollment.
SQL: SELECT cName FROM College WHERE enr  <  13000 AND state = "AZ" UNION SELECT cName FROM College WHERE enr  >  15000 AND state = "LA"
Database: soccer_2 (tables: college)
Question: What are the names of colleges in LA that have more than 15,000 students and of colleges in AZ with less than 13,000 students?
SQL: SELECT cName FROM College WHERE enr  <  13000 AND state = "AZ" UNION SELECT cName FROM College WHERE enr  >  15000 AND state = "LA"
Database: soccer_2 (tables: tryout)
Question: Find the names of schools that have some students playing in goalie and mid positions.
SQL: SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid'
Database: soccer_2 (tables: tryout)
Question: What are the names of all schools that have students trying out for the position of goal and 'mid'-field.
SQL: SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid'
Database: soccer_2 (tables: tryout, college)
Question: Find the names of states that have some college students playing in goalie and mid positions.
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie' INTERSECT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid'
Database: soccer_2 (tables: tryout, college)
Question: What are the names of the states that have some college students playing in the positions of goalie and mid-field?
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie' INTERSECT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid'
Database: soccer_2 (tables: tryout)
Question: How many schools have some students playing in goalie and mid positions.
SQL: SELECT COUNT(*) FROM (SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid')
Database: soccer_2 (tables: tryout)
Question: How many schools have students playing in goalie and mid-field positions?
SQL: SELECT COUNT(*) FROM (SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid')
Database: soccer_2 (tables: tryout)
Question: Find the names of schools that have some players in the mid position but not in the goalie position.
SQL: SELECT cName FROM  tryout WHERE pPos  =  'mid' EXCEPT SELECT cName FROM  tryout WHERE pPos  =  'goalie'
Database: soccer_2 (tables: tryout)
Question: What are the names of the schools with some players in the mid position but no goalies?
SQL: SELECT cName FROM  tryout WHERE pPos  =  'mid' EXCEPT SELECT cName FROM  tryout WHERE pPos  =  'goalie'
Database: soccer_2 (tables: tryout, college)
Question: Find the names of states that have some college students playing in the mid position but not in the goalie position.
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid' EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie'
Database: soccer_2 (tables: tryout, college)
Question: What are the names of all the states with college students playing in the mid position but no goalies?
SQL: SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid' EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie'
Database: soccer_2 (tables: tryout, college)
Question: How many states that have some college students playing in the mid position but not in the goalie position.
SQL: SELECT COUNT(*) FROM (SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid' EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie')
Database: soccer_2 (tables: tryout, college)
Question: What is the count of states with college students playing in the mid position but not as goalies?
SQL: SELECT COUNT(*) FROM (SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'mid' EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName  =  T2.cName WHERE T2.pPos  =  'goalie')
Database: soccer_2 (tables: college)
Question: Find the states where have the colleges whose enrollments are less than the largest size.
SQL: SELECT DISTINCT state FROM college WHERE enr  <  (SELECT max(enr) FROM college)
Database: soccer_2 (tables: college)
Question: What are the states with colleges that have enrollments less than the some other college?
SQL: SELECT DISTINCT state FROM college WHERE enr  <  (SELECT max(enr) FROM college)
Database: soccer_2 (tables: college)
Question: Find names of colleges with enrollment greater than that of some (at least one) college in the FL state.
SQL: SELECT DISTINCT cName FROM college WHERE enr  >  (SELECT min(enr) FROM college WHERE state  =  'FL')
Database: soccer_2 (tables: college)
Question: What are the names of the colleges that are larger than at least one college in Florida?
SQL: SELECT DISTINCT cName FROM college WHERE enr  >  (SELECT min(enr) FROM college WHERE state  =  'FL')
Database: soccer_2 (tables: college)
Question: Find names of all colleges whose enrollment is greater than that of all colleges in the FL state.
SQL: SELECT cName FROM college WHERE enr  >  (SELECT max(enr) FROM college WHERE state  =  'FL')
Database: soccer_2 (tables: college)
Question: What are the names of all colleges with a larger enrollment than the largest college in Florida?
SQL: SELECT cName FROM college WHERE enr  >  (SELECT max(enr) FROM college WHERE state  =  'FL')
Database: soccer_2 (tables: tryout, college)
Question: What is the total number of enrollment of schools that do not have any goalie player?
SQL: SELECT sum(enr) FROM college WHERE cName NOT IN (SELECT cName FROM tryout WHERE pPos  =  "goalie")
Database: soccer_2 (tables: tryout, college)
Question: What is the total number of students enrolled in schools without any goalies?
SQL: SELECT sum(enr) FROM college WHERE cName NOT IN (SELECT cName FROM tryout WHERE pPos  =  "goalie")
Database: soccer_2 (tables: college)
Question: What is the number of states that has some college whose enrollment is larger than the average enrollment?
SQL: SELECT count(DISTINCT state) FROM college WHERE enr  >  (SELECT avg(enr) FROM college)
Database: soccer_2 (tables: college)
Question: How many states have a college with more students than average?
SQL: SELECT count(DISTINCT state) FROM college WHERE enr  >  (SELECT avg(enr) FROM college)
Database: soccer_2 (tables: college)
Question: What is the number of states that has some colleges whose enrollment is smaller than the average enrollment?
SQL: SELECT count(DISTINCT state) FROM college WHERE enr  <  (SELECT avg(enr) FROM college)
Database: soccer_2 (tables: college)
Question: How many states have smaller colleges than average?
SQL: SELECT count(DISTINCT state) FROM college WHERE enr  <  (SELECT avg(enr) FROM college)
Database: device (tables: device)
Question: How many devices are there?
SQL: SELECT count(*) FROM device
Database: device (tables: device)
Question: Count the number of devices.
SQL: SELECT count(*) FROM device
Database: device (tables: device)
Question: List the carriers of devices in ascending alphabetical order.
SQL: SELECT Carrier FROM device ORDER BY Carrier ASC
Database: device (tables: device)
Question: What are the different carriers for devices, listed in alphabetical order?
SQL: SELECT Carrier FROM device ORDER BY Carrier ASC
Database: device (tables: device)
Question: What are the carriers of devices whose software platforms are not "Android"?
SQL: SELECT Carrier FROM device WHERE Software_Platform != 'Android'
Database: device (tables: device)
Question: Return the device carriers that do not have Android as their software platform.
SQL: SELECT Carrier FROM device WHERE Software_Platform != 'Android'
Database: device (tables: shop)
Question: What are the names of shops in ascending order of open year?
SQL: SELECT Shop_Name FROM shop ORDER BY Open_Year ASC
Database: device (tables: shop)
Question: Return the names of shops, ordered by year of opening ascending.
SQL: SELECT Shop_Name FROM shop ORDER BY Open_Year ASC
Database: device (tables: stock)
Question: What is the average quantity of stocks?
SQL: SELECT avg(Quantity) FROM stock
Database: device (tables: stock)
Question: Give the average quantity of stocks.
SQL: SELECT avg(Quantity) FROM stock
Database: device (tables: shop)
Question: What are the names and location of the shops in ascending alphabetical order of name.
SQL: SELECT Shop_Name ,  LOCATION FROM shop ORDER BY Shop_Name ASC
Database: device (tables: shop)
Question: Return the names and locations of shops, ordered by name in alphabetical order.
SQL: SELECT Shop_Name ,  LOCATION FROM shop ORDER BY Shop_Name ASC
Database: device (tables: device)
Question: How many different software platforms are there for devices?
SQL: SELECT count(DISTINCT Software_Platform) FROM device
Database: device (tables: device)
Question: Count the number of different software platforms.
SQL: SELECT count(DISTINCT Software_Platform) FROM device
Database: device (tables: shop)
Question: List the open date of open year of the shop named "Apple".
SQL: SELECT Open_Date ,  Open_Year FROM shop WHERE Shop_Name  =  "Apple"
Database: device (tables: shop)
Question: What are the open dates and years for the shop named Apple?
SQL: SELECT Open_Date ,  Open_Year FROM shop WHERE Shop_Name  =  "Apple"
Database: device (tables: shop)
Question: List the name of the shop with the latest open year.
SQL: SELECT Shop_Name FROM shop ORDER BY Open_Year DESC LIMIT 1
Database: device (tables: shop)
Question: What is the shop name corresponding to the shop that opened in the most recent year?
SQL: SELECT Shop_Name FROM shop ORDER BY Open_Year DESC LIMIT 1
Database: device (tables: stock, shop, device)
Question: Show names of shops and the carriers of devices they have in stock.
SQL: SELECT T3.Shop_Name ,  T2.Carrier FROM stock AS T1 JOIN device AS T2 ON T1.Device_ID  =  T2.Device_ID JOIN shop AS T3 ON T1.Shop_ID  =  T3.Shop_ID