target-benchmark/spider-queries huggingface dataset:
Database: bike_1 (tables: weather)
Question: What are the days that had the smallest temperature range, and what was that range?
SQL: SELECT date ,  max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f LIMIT 1
Database: bike_1 (tables: status, station)
Question: What are the id and name of the stations that have ever had more than 12 bikes available?
SQL: SELECT DISTINCT T1.id ,  T1.name FROM station AS T1 JOIN status AS T2 ON T1.id  =  T2.station_id WHERE T2.bikes_available  >  12
Database: bike_1 (tables: status, station)
Question: What are the different ids and names of the stations that have had more than 12 bikes available?
SQL: SELECT DISTINCT T1.id ,  T1.name FROM station AS T1 JOIN status AS T2 ON T1.id  =  T2.station_id WHERE T2.bikes_available  >  12
Database: bike_1 (tables: trip, weather)
Question: Give me the zip code where the average mean humidity is below 70 and at least 100 trips took place.
SQL: SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_humidity)  <  70 INTERSECT SELECT zip_code FROM trip GROUP BY zip_code HAVING count(*)  >=  100
Database: bike_1 (tables: trip, weather)
Question: What are the zip codes that have an average mean humidity below 70 and had at least 100 trips come through there?
SQL: SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_humidity)  <  70 INTERSECT SELECT zip_code FROM trip GROUP BY zip_code HAVING count(*)  >=  100
Database: bike_1 (tables: trip, station)
Question: What are the names of stations that are located in Palo Alto city but have never been the ending point of trips more than 100 times?
SQL: SELECT name FROM station WHERE city  =  "Palo Alto" EXCEPT SELECT end_station_name FROM trip GROUP BY end_station_name HAVING count(*)  >  100
Database: bike_1 (tables: trip, station)
Question: What are the names of the stations that are located in Palo Alto but have never been the ending point of the trips
SQL: SELECT name FROM station WHERE city  =  "Palo Alto" EXCEPT SELECT end_station_name FROM trip GROUP BY end_station_name HAVING count(*)  >  100
Database: bike_1 (tables: trip, station)
Question: How many trips started from Mountain View city and ended at Palo Alto city?
SQL: SELECT count(*) FROM station AS T1 JOIN trip AS T2 JOIN station AS T3 JOIN trip AS T4 ON T1.id  =  T2.start_station_id AND T2.id  =  T4.id AND T3.id  =  T4.end_station_id WHERE T1.city  =  "Mountain View" AND T3.city  =  "Palo Alto"
Database: bike_1 (tables: trip, station)
Question: How many trips stated from  a station in Mountain View and ended at one in Palo Alto?
SQL: SELECT count(*) FROM station AS T1 JOIN trip AS T2 JOIN station AS T3 JOIN trip AS T4 ON T1.id  =  T2.start_station_id AND T2.id  =  T4.id AND T3.id  =  T4.end_station_id WHERE T1.city  =  "Mountain View" AND T3.city  =  "Palo Alto"
Database: bike_1 (tables: trip, station)
Question: What is the average latitude and longitude of the starting points of all trips?
SQL: SELECT avg(T1.lat) ,  avg(T1.long) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.start_station_id
Database: bike_1 (tables: trip, station)
Question: What is the average latitude and longitude of all starting stations for the trips?
SQL: SELECT avg(T1.lat) ,  avg(T1.long) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.start_station_id
Database: book_2 (tables: book)
Question: How many books are there?
SQL: SELECT count(*) FROM book
Database: book_2 (tables: book)
Question: List the writers of the books in ascending alphabetical order.
SQL: SELECT Writer FROM book ORDER BY Writer ASC
Database: book_2 (tables: book)
Question: List the titles of the books in ascending order of issues.
SQL: SELECT Title FROM book ORDER BY Issues ASC
Database: book_2 (tables: book)
Question: What are the titles of the books whose writer is not "Elaine Lee"?
SQL: SELECT Title FROM book WHERE Writer != "Elaine Lee"
Database: book_2 (tables: book)
Question: What are the title and issues of the books?
SQL: SELECT Title ,  Issues FROM book
Database: book_2 (tables: publication)
Question: What are the dates of publications in descending order of price?
SQL: SELECT Publication_Date FROM publication ORDER BY Price DESC
Database: book_2 (tables: publication)
Question: What are the distinct publishers of publications with price higher than 5000000?
SQL: SELECT DISTINCT Publisher FROM publication WHERE Price  >  5000000
Database: book_2 (tables: publication)
Question: List the publisher of the publication with the highest price.
SQL: SELECT Publisher FROM publication ORDER BY Price DESC LIMIT 1
Database: book_2 (tables: publication)
Question: List the publication dates of publications with 3 lowest prices.
SQL: SELECT Publication_Date FROM publication ORDER BY Price ASC LIMIT 3
Database: book_2 (tables: publication, book)
Question: Show the title and publication dates of books.
SQL: SELECT T1.Title ,  T2.Publication_Date FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID
Database: book_2 (tables: publication, book)
Question: Show writers who have published a book with price more than 4000000.
SQL: SELECT T1.Writer FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID WHERE T2.Price  >  4000000
Database: book_2 (tables: publication, book)
Question: Show the titles of books in descending order of publication price.
SQL: SELECT T1.Title FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID ORDER BY T2.Price DESC
Database: book_2 (tables: publication)
Question: Show publishers that have more than one publication.
SQL: SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT(*)  >  1
Database: book_2 (tables: publication)
Question: Show different publishers together with the number of publications they have.
SQL: SELECT Publisher ,  COUNT(*) FROM publication GROUP BY Publisher
Database: book_2 (tables: publication)
Question: Please show the most common publication date.
SQL: SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT(*) DESC LIMIT 1
Database: book_2 (tables: book)
Question: List the writers who have written more than one book.
SQL: SELECT Writer FROM book GROUP BY Writer HAVING COUNT(*)  >  1
Database: book_2 (tables: publication, book)
Question: List the titles of books that are not published.
SQL: SELECT Title FROM book WHERE Book_ID NOT IN (SELECT Book_ID FROM publication)
Database: book_2 (tables: publication)
Question: Show the publishers that have publications with price higher than 10000000 and publications with price lower than 5000000.
SQL: SELECT Publisher FROM publication WHERE Price  >  10000000 INTERSECT SELECT Publisher FROM publication WHERE Price  <  5000000
Database: book_2 (tables: publication)
Question: What is the number of distinct publication dates?
SQL: SELECT COUNT (DISTINCT Publication_Date) FROM publication
Database: book_2 (tables: publication)
Question: How many distinct publication dates are there in our record?
SQL: SELECT COUNT (DISTINCT Publication_Date) FROM publication
Database: book_2 (tables: publication)
Question: Show the prices of publications whose publisher is either "Person" or "Wiley"
SQL: SELECT Price FROM publication WHERE Publisher  =  "Person" OR Publisher  =  "Wiley"
Database: musical (tables: actor)
Question: How many actors are there?
SQL: SELECT count(*) FROM actor
Database: musical (tables: actor)
Question: Count the number of actors.
SQL: SELECT count(*) FROM actor
Database: musical (tables: actor)
Question: List the name of actors in ascending alphabetical order.
SQL: SELECT Name FROM actor ORDER BY Name ASC
Database: musical (tables: actor)
Question: What are the names of actors, ordered alphabetically?
SQL: SELECT Name FROM actor ORDER BY Name ASC
Database: musical (tables: actor)
Question: What are the characters and duration of actors?
SQL: SELECT Character ,  Duration FROM actor
Database: musical (tables: actor)
Question: Return the characters and durations for each actor.
SQL: SELECT Character ,  Duration FROM actor
Database: musical (tables: actor)
Question: List the name of actors whose age is not 20.
SQL: SELECT Name FROM actor WHERE Age != 20
Database: musical (tables: actor)
Question: What are the names of actors who are not 20 years old?
SQL: SELECT Name FROM actor WHERE Age != 20
Database: musical (tables: actor)
Question: What are the characters of actors in descending order of age?
SQL: SELECT Character FROM actor ORDER BY age DESC
Database: musical (tables: actor)
Question: Return the characters for actors, ordered by age descending.
SQL: SELECT Character FROM actor ORDER BY age DESC
Database: musical (tables: actor)
Question: What is the duration of the oldest actor?
SQL: SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1
Database: musical (tables: actor)
Question: Return the duration of the actor with the greatest age.
SQL: SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1
Database: musical (tables: musical)
Question: What are the names of musicals with nominee "Bob Fosse"?
SQL: SELECT Name FROM musical WHERE Nominee  =  "Bob Fosse"
Database: musical (tables: musical)
Question: Return the names of musicals who have the nominee Bob Fosse.
SQL: SELECT Name FROM musical WHERE Nominee  =  "Bob Fosse"
Database: musical (tables: musical)
Question: What are the distinct nominees of the musicals with the award that is not "Tony Award"?
SQL: SELECT DISTINCT Nominee FROM musical WHERE Award != "Tony Award"
Database: musical (tables: musical)
Question: Return the different nominees of musicals that have an award that is not the Tony Award.
SQL: SELECT DISTINCT Nominee FROM musical WHERE Award != "Tony Award"
Database: musical (tables: actor, musical)
Question: Show names of actors and names of musicals they are in.
SQL: SELECT T1.Name ,  T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID
Database: musical (tables: actor, musical)
Question: What are the names of actors and the musicals that they are in?
SQL: SELECT T1.Name ,  T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID
Database: musical (tables: actor, musical)
Question: Show names of actors that have appeared in musical with name "The Phantom of the Opera".
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID WHERE T2.Name  =  "The Phantom of the Opera"
Database: musical (tables: actor, musical)
Question: What are the names of actors who have been in the musical titled The Phantom of the Opera?
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID WHERE T2.Name  =  "The Phantom of the Opera"
Database: musical (tables: actor, musical)
Question: Show names of actors in descending order of the year their musical is awarded.
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID ORDER BY T2.Year DESC
Database: musical (tables: actor, musical)
Question: What are the names of actors ordered descending by the year in which their musical was awarded?
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID ORDER BY T2.Year DESC
Database: musical (tables: actor, musical)
Question: Show names of musicals and the number of actors who have appeared in the musicals.
SQL: SELECT T2.Name ,  COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID
Database: musical (tables: actor, musical)
Question: How many actors have appeared in each musical?
SQL: SELECT T2.Name ,  COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID
Database: musical (tables: actor, musical)
Question: Show names of musicals which have at least three actors.
SQL: SELECT T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID HAVING COUNT(*)  >=  3
Database: musical (tables: actor, musical)
Question: What are the names of musicals who have at 3 or more actors?
SQL: SELECT T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID HAVING COUNT(*)  >=  3
Database: musical (tables: musical)
Question: Show different nominees and the number of musicals they have been nominated.
SQL: SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee
Database: musical (tables: musical)
Question: How many musicals has each nominee been nominated for?
SQL: SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee
Database: musical (tables: musical)
Question: Please show the nominee who has been nominated the greatest number of times.
SQL: SELECT Nominee FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC LIMIT 1
Database: musical (tables: musical)
Question: Who is the nominee who has been nominated for the most musicals?
SQL: SELECT Nominee FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC LIMIT 1
Database: musical (tables: musical)
Question: List the most common result of the musicals.
SQL: SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
Database: musical (tables: musical)
Question: Return the most frequent result across all musicals.
SQL: SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
Database: musical (tables: musical)
Question: List the nominees that have been nominated more than two musicals.
SQL: SELECT Nominee FROM musical GROUP BY Nominee HAVING COUNT(*)  >  2
Database: musical (tables: musical)
Question: Who are the nominees who have been nominated more than two times?
SQL: SELECT Nominee FROM musical GROUP BY Nominee HAVING COUNT(*)  >  2
Database: musical (tables: actor, musical)
Question: List the name of musicals that do not have actors.
SQL: SELECT Name FROM musical WHERE Musical_ID NOT IN (SELECT Musical_ID FROM actor)
Database: musical (tables: actor, musical)
Question: What are the names of musicals who have no actors?
SQL: SELECT Name FROM musical WHERE Musical_ID NOT IN (SELECT Musical_ID FROM actor)
Database: musical (tables: musical)
Question: Show the nominees that have nominated musicals for both "Tony Award" and "Drama Desk Award".
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award  =  "Drama Desk Award"
Database: musical (tables: musical)
Question: Who are the nominees who have been nominated for both a Tony Award and a Drama Desk Award?
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award  =  "Drama Desk Award"
Database: musical (tables: musical)
Question: Show the musical nominee with award "Bob Fosse" or "Cleavant Derricks".
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" OR Award  =  "Cleavant Derricks"
Database: musical (tables: musical)
Question: Who are the nominees who were nominated for either of the Bob Fosse or Cleavant Derricks awards?
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" OR Award  =  "Cleavant Derricks"
Database: twitter_1 (tables: user_profiles)
Question: Find the emails of the user named "Mary".
SQL: SELECT email FROM user_profiles WHERE name  =  'Mary'
Database: twitter_1 (tables: user_profiles)
Question: What is the partition id of the user named "Iron Man".
SQL: SELECT partitionid FROM user_profiles WHERE name  =  'Iron Man'
Database: twitter_1 (tables: user_profiles)
Question: How many users are there?
SQL: SELECT count(*) FROM user_profiles
Database: twitter_1 (tables: follows)
Question: How many followers does each user have?
SQL: SELECT count(*) FROM follows
Database: twitter_1 (tables: follows)
Question: Find the number of followers for each user.
SQL: SELECT count(*) FROM follows GROUP BY f1
Database: twitter_1 (tables: tweets)
Question: Find the number of tweets in record.
SQL: SELECT count(*) FROM tweets
Database: twitter_1 (tables: tweets)
Question: Find the number of users who posted some tweets.
SQL: SELECT count(DISTINCT UID) FROM tweets
Database: twitter_1 (tables: user_profiles)
Question: Find the name and email of the user whose name contains the word ‘Swift’.
SQL: SELECT name ,  email FROM user_profiles WHERE name LIKE '%Swift%'
Database: twitter_1 (tables: user_profiles)
Question: Find the names of users whose emails contain ‘superstar’ or ‘edu’.
SQL: SELECT name FROM user_profiles WHERE email LIKE '%superstar%' OR email LIKE '%edu%'
Database: twitter_1 (tables: tweets)
Question: Return the text of tweets about the topic 'intern'.
SQL: SELECT text FROM tweets WHERE text LIKE '%intern%'
Database: twitter_1 (tables: user_profiles)
Question: Find the name and email of the users who have more than 1000 followers.
SQL: SELECT name ,  email FROM user_profiles WHERE followers  >  1000
Database: twitter_1 (tables: follows, user_profiles)
Question: Find the names of the users whose number of followers is greater than that of the user named "Tyler Swift".
SQL: SELECT T1.name FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f1 GROUP BY T2.f1 HAVING count(*)  >  (SELECT count(*) FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f1 WHERE T1.name  =  'Tyler Swift')
Database: twitter_1 (tables: follows, user_profiles)
Question: Find the name and email for the users who have more than one follower.
SQL: SELECT T1.name ,  T1.email FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f1 GROUP BY T2.f1 HAVING count(*)  >  1
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the names of users who have more than one tweet.
SQL: SELECT T1.name FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid  =  T2.uid GROUP BY T2.uid HAVING count(*)  >  1
Database: twitter_1 (tables: follows, user_profiles)
Question: Find the id of users who are followed by Mary and Susan.
SQL: SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f2 WHERE T1.name  =  "Mary" INTERSECT SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f2 WHERE T1.name  =  "Susan"
Database: twitter_1 (tables: follows, user_profiles)
Question: Find the id of users who are followed by Mary or Susan.
SQL: SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid  =  T2.f2 WHERE T1.name  =  "Mary" OR T1.name  =  "Susan"
Database: twitter_1 (tables: user_profiles)
Question: Find the name of the user who has the largest number of followers.
SQL: SELECT name FROM user_profiles ORDER BY followers DESC LIMIT 1
Database: twitter_1 (tables: user_profiles)
Question: Find the name and email of the user followed by the least number of people.
SQL: SELECT name ,  email FROM user_profiles ORDER BY followers LIMIT 1
Database: twitter_1 (tables: user_profiles)
Question: List the name and number of followers for each user, and sort the results by the number of followers in descending order.
SQL: SELECT name ,  followers FROM user_profiles ORDER BY followers DESC
Database: twitter_1 (tables: user_profiles)
Question: List the names of 5 users followed by the largest number of other users.
SQL: SELECT name FROM user_profiles ORDER BY followers DESC LIMIT 5
Database: twitter_1 (tables: tweets)
Question: List the text of all tweets in the order of date.
SQL: SELECT text FROM tweets ORDER BY createdate
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the name of each user and number of tweets tweeted by each of them.
SQL: SELECT T1.name ,  count(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid  =  T2.uid GROUP BY T2.uid
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the name and partition id for users who tweeted less than twice.
SQL: SELECT T1.name ,  T1.partitionid FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid  =  T2.uid GROUP BY T2.uid HAVING count(*)  <  2
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the name of the user who tweeted more than once, and number of tweets tweeted by them.
SQL: SELECT T1.name ,  count(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid  =  T2.uid GROUP BY T2.uid HAVING count(*)  >  1
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the average number of followers for the users who do not have any tweet.
SQL: SELECT avg(followers) FROM user_profiles WHERE UID NOT IN (SELECT UID FROM tweets)
Database: twitter_1 (tables: user_profiles, tweets)
Question: Find the average number of followers for the users who had some tweets.
SQL: SELECT avg(followers) FROM user_profiles WHERE UID IN (SELECT UID FROM tweets)
Database: twitter_1 (tables: user_profiles)
Question: Find the maximum and total number of followers of all users.
SQL: SELECT max(followers) ,  sum(followers) FROM user_profiles
Database: product_catalog (tables: catalog_contents)
Question: Find the names of all the catalog entries.
SQL: SELECT distinct(catalog_entry_name) FROM catalog_contents
Database: product_catalog (tables: catalog_contents)
Question: What are all the catalog entry names?
SQL: SELECT distinct(catalog_entry_name) FROM catalog_contents
Database: product_catalog (tables: attribute_definitions)
Question: Find the list of attribute data types possessed by more than 3 attribute definitions.
SQL: SELECT attribute_data_type FROM Attribute_Definitions GROUP BY attribute_data_type HAVING count(*)  >  3
Database: product_catalog (tables: attribute_definitions)
Question: What are the attribute data types with more than 3 attribute definitions?
SQL: SELECT attribute_data_type FROM Attribute_Definitions GROUP BY attribute_data_type HAVING count(*)  >  3
Database: product_catalog (tables: attribute_definitions)
Question: What is the attribute data type of the attribute with name "Green"?
SQL: SELECT attribute_data_type FROM Attribute_Definitions WHERE attribute_name  =  "Green"
Database: product_catalog (tables: attribute_definitions)
Question: Find the attribute data type for the attribute named "Green".
SQL: SELECT attribute_data_type FROM Attribute_Definitions WHERE attribute_name  =  "Green"
Database: product_catalog (tables: catalog_structure)
Question: Find the name and level of catalog structure with level between 5 and 10.
SQL: SELECT catalog_level_name ,  catalog_level_number FROM Catalog_Structure WHERE catalog_level_number BETWEEN 5 AND 10
Database: product_catalog (tables: catalog_structure)
Question: What are the name and level of catalog structure with level number between 5 and 10
SQL: SELECT catalog_level_name ,  catalog_level_number FROM Catalog_Structure WHERE catalog_level_number BETWEEN 5 AND 10
Database: product_catalog (tables: catalogs)
Question: Find all the catalog publishers whose name contains "Murray"
SQL: SELECT distinct(catalog_publisher) FROM catalogs WHERE catalog_publisher LIKE "%Murray%"
Database: product_catalog (tables: catalogs)
Question: Which catalog publishers have substring "Murray" in their names?
SQL: SELECT distinct(catalog_publisher) FROM catalogs WHERE catalog_publisher LIKE "%Murray%"
Database: product_catalog (tables: catalogs)
Question: Which catalog publisher has published the most catalogs?
SQL: SELECT catalog_publisher FROM catalogs GROUP BY catalog_publisher ORDER BY count(*) DESC LIMIT 1
Database: product_catalog (tables: catalogs)
Question: Find the catalog publisher that has the most catalogs.
SQL: SELECT catalog_publisher FROM catalogs GROUP BY catalog_publisher ORDER BY count(*) DESC LIMIT 1
Database: product_catalog (tables: catalogs, catalog_structure)
Question: Find the names and publication dates of all catalogs that have catalog level number greater than 5.
SQL: SELECT t1.catalog_name ,  t1.date_of_publication FROM catalogs AS t1 JOIN catalog_structure AS t2 ON t1.catalog_id  =  t2.catalog_id WHERE catalog_level_number  >  5
Database: product_catalog (tables: catalogs, catalog_structure)
Question: What are the name and publication date of the catalogs with catalog level number above 5?
SQL: SELECT t1.catalog_name ,  t1.date_of_publication FROM catalogs AS t1 JOIN catalog_structure AS t2 ON t1.catalog_id  =  t2.catalog_id WHERE catalog_level_number  >  5
Database: product_catalog (tables: catalog_contents, catalog_contents_additional_attributes)
Question: What are the entry names of catalog with the attribute possessed by most entries.
SQL: SELECT t1.catalog_entry_name FROM Catalog_Contents AS t1 JOIN Catalog_Contents_Additional_Attributes AS t2 ON t1.catalog_entry_id  =  t2.catalog_entry_id WHERE t2.attribute_value  =  (SELECT attribute_value FROM Catalog_Contents_Additional_Attributes GROUP BY attribute_value ORDER BY count(*) DESC LIMIT 1)