target-benchmark/spider-queries huggingface dataset:
Database: singer (tables: singer, song)
Question: Show titles of songs and names of singers.
SQL: SELECT T2.Title ,  T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID
Database: singer (tables: singer, song)
Question: What are the song titles and singer names?
SQL: SELECT T2.Title ,  T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID
Database: singer (tables: singer, song)
Question: Show distinct names of singers that have songs with sales more than 300000.
SQL: SELECT DISTINCT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID WHERE T2.Sales  >  300000
Database: singer (tables: singer, song)
Question: what are the different names of the singers that have sales more than 300000?
SQL: SELECT DISTINCT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID WHERE T2.Sales  >  300000
Database: singer (tables: singer, song)
Question: Show the names of singers that have more than one song.
SQL: SELECT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID GROUP BY T1.Name HAVING COUNT(*)  >  1
Database: singer (tables: singer, song)
Question: What are the names of the singers that have more than one songs?
SQL: SELECT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID GROUP BY T1.Name HAVING COUNT(*)  >  1
Database: singer (tables: singer, song)
Question: Show the names of singers and the total sales of their songs.
SQL: SELECT T1.Name ,  sum(T2.Sales) FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID GROUP BY T1.Name
Database: singer (tables: singer, song)
Question: For each singer name, what is the total sales for their songs?
SQL: SELECT T1.Name ,  sum(T2.Sales) FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID  =  T2.Singer_ID GROUP BY T1.Name
Database: singer (tables: singer, song)
Question: List the name of singers that do not have any song.
SQL: SELECT Name FROM singer WHERE Singer_ID NOT IN (SELECT Singer_ID FROM song)
Database: singer (tables: singer, song)
Question: What is the sname of every sing that does not have any song?
SQL: SELECT Name FROM singer WHERE Singer_ID NOT IN (SELECT Singer_ID FROM song)
Database: singer (tables: singer)
Question: Show the citizenship shared by singers with birth year before 1945 and after 1955.
SQL: SELECT Citizenship FROM singer WHERE Birth_Year  <  1945 INTERSECT SELECT Citizenship FROM singer WHERE Birth_Year  >  1955
Database: singer (tables: singer)
Question: What are the citizenships that are shared by singers with a birth year before 1945 and after 1955?
SQL: SELECT Citizenship FROM singer WHERE Birth_Year  <  1945 INTERSECT SELECT Citizenship FROM singer WHERE Birth_Year  >  1955
Database: real_estate_properties (tables: other_available_features)
Question: How many available features are there in total?
SQL: SELECT count(*) FROM Other_Available_Features
Database: real_estate_properties (tables: other_available_features, ref_feature_types)
Question: What is the feature type name of feature AirCon?
SQL: SELECT T2.feature_type_name FROM Other_Available_Features AS T1 JOIN Ref_Feature_Types AS T2 ON T1.feature_type_code  =  T2.feature_type_code WHERE T1.feature_name  =  "AirCon"
Database: real_estate_properties (tables: ref_property_types, properties)
Question: Show the property type descriptions of properties belonging to that code.
SQL: SELECT T2.property_type_description FROM Properties AS T1 JOIN Ref_Property_Types AS T2 ON T1.property_type_code  =  T2.property_type_code GROUP BY T1.property_type_code
Database: real_estate_properties (tables: properties)
Question: What are the names of properties that are either houses or apartments with more than 1 room?
SQL: SELECT property_name FROM Properties WHERE property_type_code  =  "House" UNION SELECT property_name FROM Properties WHERE property_type_code  =  "Apartment" AND room_count  >  1