target-benchmark/spider-queries huggingface dataset:
Database: store_1 (tables: invoices, customers)
Question: Find out the top 10 customers by total number of orders. List customers' first and last name and the number of total orders.
SQL: SELECT T1.first_name ,  T1.last_name ,  COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 10;
Database: store_1 (tables: invoices, customers)
Question: What are the top 10 customers' first and last names by total number of orders and how many orders did they make?
SQL: SELECT T1.first_name ,  T1.last_name ,  COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 10;
Database: store_1 (tables: invoices, customers)
Question: List the top 10 customers by total gross sales. List customers' first and last name and total gross sales.
SQL: SELECT T1.first_name ,  T1.last_name ,  SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY SUM(T2.total) DESC LIMIT 10;
Database: store_1 (tables: invoices, customers)
Question: What are the top 10 customers' first and last names with the highest gross sales, and also what are the sales?
SQL: SELECT T1.first_name ,  T1.last_name ,  SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY SUM(T2.total) DESC LIMIT 10;
Database: store_1 (tables: genres, tracks)
Question: List the top 5 genres by number of tracks. List genres name and total tracks.
SQL: SELECT T1.name ,  COUNT(*) FROM genres AS T1 JOIN tracks AS T2 ON T2.genre_id  =  T1.id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 5;
Database: store_1 (tables: genres, tracks)
Question: How many tracks does each genre have and what are the names of the top 5?
SQL: SELECT T1.name ,  COUNT(*) FROM genres AS T1 JOIN tracks AS T2 ON T2.genre_id  =  T1.id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 5;
Database: store_1 (tables: albums)
Question: List every album's title.
SQL: SELECT title FROM albums;
Database: store_1 (tables: albums)
Question: What are the titles of all the albums?
SQL: SELECT title FROM albums;
Database: store_1 (tables: albums)
Question: List every album ordered by album title in ascending order.
SQL: SELECT title FROM albums ORDER BY title;
Database: store_1 (tables: albums)
Question: What are the titles of all the albums alphabetically ascending?
SQL: SELECT title FROM albums ORDER BY title;
Database: store_1 (tables: albums)
Question: List every album whose title starts with A in alphabetical order.
SQL: SELECT title FROM albums WHERE title LIKE 'A%' ORDER BY title;
Database: store_1 (tables: albums)
Question: What are the titles of all albums that start with A in alphabetical order?
SQL: SELECT title FROM albums WHERE title LIKE 'A%' ORDER BY title;
Database: store_1 (tables: invoices, customers)
Question: List the customers first and last name of 10 least expensive invoices.
SQL: SELECT T1.first_name ,  T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id ORDER BY total LIMIT 10;
Database: store_1 (tables: invoices, customers)
Question: What are the first and last names of the customers with the 10 cheapest invoices?
SQL: SELECT T1.first_name ,  T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id ORDER BY total LIMIT 10;
Database: store_1 (tables: invoices)
Question: List total amount of  invoice from Chicago, IL.
SQL: SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";
Database: store_1 (tables: invoices)
Question: What are the total amount of money in the invoices billed from Chicago, Illinois?
SQL: SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";
Database: store_1 (tables: invoices)
Question: List the number of invoices from Chicago, IL.
SQL: SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";
Database: store_1 (tables: invoices)
Question: How many invoices were billed from Chicago, IL?
SQL: SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";
Database: store_1 (tables: invoices)
Question: List the number of invoices from the US, grouped by state.
SQL: SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state;
Database: store_1 (tables: invoices)
Question: How many invoices were billed from each state?
SQL: SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state;
Database: store_1 (tables: invoices)
Question: List the state in the US with the most invoices.
SQL: SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1;
Database: store_1 (tables: invoices)
Question: What are the states with the most invoices?
SQL: SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1;
Database: store_1 (tables: invoices)
Question: List the number of invoices and the invoice total from California.
SQL: SELECT billing_state ,  COUNT(*) ,  SUM(total) FROM invoices WHERE billing_state  =  "CA";
Database: store_1 (tables: invoices)
Question: What is the number of invoices and total money billed in them from CA?
SQL: SELECT billing_state ,  COUNT(*) ,  SUM(total) FROM invoices WHERE billing_state  =  "CA";
Database: store_1 (tables: albums, artists)
Question: List Aerosmith's albums.
SQL: SELECT T1.title FROM albums AS T1 JOIN artists AS T2 ON  T1.artist_id = T2.id WHERE T2.name = "Aerosmith";
Database: store_1 (tables: albums, artists)
Question: What are the titles of all the Aerosmith albums?
SQL: SELECT T1.title FROM albums AS T1 JOIN artists AS T2 ON  T1.artist_id = T2.id WHERE T2.name = "Aerosmith";
Database: store_1 (tables: albums, artists)
Question: How many albums does Billy Cobham has?
SQL: SELECT count(*) FROM albums AS T1 JOIN artists AS T2 ON  T1.artist_id = T2.id WHERE T2.name = "Billy Cobham";
Database: store_1 (tables: albums, artists)
Question: How many albums has Billy Cobam released?
SQL: SELECT count(*) FROM albums AS T1 JOIN artists AS T2 ON  T1.artist_id = T2.id WHERE T2.name = "Billy Cobham";
Database: store_1 (tables: customers)
Question: Eduardo Martins is a customer at which company?
SQL: SELECT company FROM customers WHERE first_name = "Eduardo" AND last_name = "Martins";
Database: store_1 (tables: customers)
Question: What is the company where Eduardo Martins is a customer?
SQL: SELECT company FROM customers WHERE first_name = "Eduardo" AND last_name = "Martins";
Database: store_1 (tables: customers)
Question: What is Astrid Gruber's email and phone number?
SQL: SELECT email ,  phone FROM customers WHERE first_name = "Astrid" AND last_name = "Gruber";
Database: store_1 (tables: customers)
Question: What is the email and phone number of Astrid Gruber the customer?
SQL: SELECT email ,  phone FROM customers WHERE first_name = "Astrid" AND last_name = "Gruber";
Database: store_1 (tables: customers)
Question: How many customers live in Prague city?
SQL: SELECT count(*) FROM customers WHERE city = "Prague";
Database: store_1 (tables: customers)
Question: How many customers live in the city of Prague?
SQL: SELECT count(*) FROM customers WHERE city = "Prague";
Database: store_1 (tables: customers)
Question: How many customers in state of CA?
SQL: SELECT count(*) FROM customers WHERE state = "CA";
Database: store_1 (tables: customers)
Question: How many customers are from California?
SQL: SELECT count(*) FROM customers WHERE state = "CA";
Database: store_1 (tables: customers)
Question: What country does Roberto Almeida live?
SQL: SELECT country FROM customers WHERE first_name = "Roberto" AND last_name = "Almeida";
Database: store_1 (tables: customers)
Question: In which country does Roberto Almeida?
SQL: SELECT country FROM customers WHERE first_name = "Roberto" AND last_name = "Almeida";
Database: store_1 (tables: artists, albums)
Question: List the name of albums that are released by aritist whose name has 'Led'
SQL: SELECT T2.title FROM artists AS T1 JOIN albums AS T2 ON T1.id  =  T2.artist_id WHERE T1.name LIKE '%Led%'
Database: store_1 (tables: artists, albums)
Question: What is the title of the album that was released by the artist whose name has the phrase 'Led'?
SQL: SELECT T2.title FROM artists AS T1 JOIN albums AS T2 ON T1.id  =  T2.artist_id WHERE T1.name LIKE '%Led%'
Database: store_1 (tables: employees, customers)
Question: How many customers does Steve Johnson support?
SQL: SELECT count(*) FROM employees AS T1 JOIN customers AS T2 ON T2.support_rep_id = T1.id WHERE T1.first_name = "Steve" AND T1.last_name = "Johnson";
Database: store_1 (tables: employees, customers)
Question: What is the count of customers that Steve Johnson supports?
SQL: SELECT count(*) FROM employees AS T1 JOIN customers AS T2 ON T2.support_rep_id = T1.id WHERE T1.first_name = "Steve" AND T1.last_name = "Johnson";
Database: store_1 (tables: employees)
Question: What is the title, phone and hire date of Nancy Edwards?
SQL: SELECT title ,  phone ,  hire_date FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees)
Question: What is the title, phone number and hire date for the employee named Nancy Edwards?
SQL: SELECT title ,  phone ,  hire_date FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees)
Question: find the full name of employees who report to Nancy Edwards?
SQL: SELECT T2.first_name , T2.last_name FROM employees AS T1 JOIN employees AS T2 ON T1.id = T2.reports_to WHERE T1.first_name = "Nancy" AND T1.last_name = "Edwards";
Database: store_1 (tables: employees)
Question: What is the first and last name of the employee who reports to Nancy Edwards?
SQL: SELECT T2.first_name , T2.last_name FROM employees AS T1 JOIN employees AS T2 ON T1.id = T2.reports_to WHERE T1.first_name = "Nancy" AND T1.last_name = "Edwards";
Database: store_1 (tables: employees)
Question: What is the address of employee Nancy Edwards?
SQL: SELECT address FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees)
Question: What is Nancy Edwards's address?
SQL: SELECT address FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees, customers)
Question: Find the full name of employee who supported the most number of customers.
SQL: SELECT T1.first_name , T1.last_name FROM employees AS T1 JOIN customers AS T2 ON T1.id  =  T2.support_rep_id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1
Database: store_1 (tables: employees, customers)
Question: What is the full name of the employee who has the most customers?
SQL: SELECT T1.first_name , T1.last_name FROM employees AS T1 JOIN customers AS T2 ON T1.id  =  T2.support_rep_id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1
Database: store_1 (tables: employees)
Question: How many employees are living in Canada?
SQL: SELECT count(*) FROM employees WHERE country = "Canada";
Database: store_1 (tables: employees)
Question: How many employees live in Canada?
SQL: SELECT count(*) FROM employees WHERE country = "Canada";
Database: store_1 (tables: employees)
Question: What is employee Nancy Edwards's phone number?
SQL: SELECT phone FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees)
Question: What is the the phone number of Nancy Edwards?
SQL: SELECT phone FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";
Database: store_1 (tables: employees)
Question: Who is the youngest employee in the company? List employee's first and last name.
SQL: SELECT first_name , last_name FROM employees ORDER BY birth_date DESC LIMIT 1;
Database: store_1 (tables: employees)
Question: What si the youngest employee's first and last name?
SQL: SELECT first_name , last_name FROM employees ORDER BY birth_date DESC LIMIT 1;
Database: store_1 (tables: employees)
Question: List top 10 employee work longest in the company. List employee's first and last name.
SQL: SELECT first_name , last_name FROM employees ORDER BY hire_date ASC LIMIT 10;
Database: store_1 (tables: employees)
Question: What are the first and last names of the top 10 longest-serving employees?
SQL: SELECT first_name , last_name FROM employees ORDER BY hire_date ASC LIMIT 10;
Database: store_1 (tables: employees)
Question: Find the number of employees whose title is IT Staff from each city?
SQL: SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
Database: store_1 (tables: employees)
Question: How many employees who are IT staff are from each city?
SQL: SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
Database: store_1 (tables: employees)
Question: Which employee manage most number of peoples? List employee's first and last name, and number of people report to that employee.
SQL: SELECT T2.first_name , T2.last_name ,  count(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY count(T1.reports_to) DESC LIMIT 1;
Database: store_1 (tables: employees)
Question: What are the first and last names of all the employees and how many people report to them?
SQL: SELECT T2.first_name , T2.last_name ,  count(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY count(T1.reports_to) DESC LIMIT 1;
Database: store_1 (tables: invoices, customers)
Question: How many orders does Lucas Mancini has?
SQL: SELECT count(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
Database: store_1 (tables: invoices, customers)
Question: How many orders does Luca Mancini have in his invoices?
SQL: SELECT count(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
Database: store_1 (tables: invoices, customers)
Question: What is the total amount of money spent by Lucas Mancini?
SQL: SELECT sum(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
Database: store_1 (tables: invoices, customers)
Question: How much money did Lucas Mancini spend?
SQL: SELECT sum(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
Database: store_1 (tables: media_types)
Question: List all media types.
SQL: SELECT name FROM media_types;
Database: store_1 (tables: media_types)
Question: What are the names of all the media types?
SQL: SELECT name FROM media_types;
Database: store_1 (tables: genres)
Question: List all different genre types.
SQL: SELECT DISTINCT name FROM genres;
Database: store_1 (tables: genres)
Question: What are the different names of the genres?
SQL: SELECT DISTINCT name FROM genres;
Database: store_1 (tables: playlists)
Question: List the name of all playlist.
SQL: SELECT name FROM playlists;
Database: store_1 (tables: playlists)
Question: What are the names of all the playlists?
SQL: SELECT name FROM playlists;
Database: store_1 (tables: tracks)
Question: Who is the composer of track Fast As a Shark?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: tracks)
Question: What is the composer who created the track "Fast As a Shark"?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: tracks)
Question: How long does track Fast As a Shark has?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: tracks)
Question: How many milliseconds long is Fast As a Shark?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: genres, tracks)
Question: What is the name of tracks whose genre is Rock?
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.name = "Rock";
Database: store_1 (tables: genres, tracks)
Question: What is the name of all tracks in the Rock genre?
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.name = "Rock";
Database: store_1 (tables: albums, tracks)
Question: What is title of album which track Balls to the Wall belongs to?
SQL: SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T2.name = "Balls to the Wall";
Database: store_1 (tables: albums, tracks)
Question: What is the name of the album that has the track Ball to the Wall?
SQL: SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T2.name = "Balls to the Wall";
Database: store_1 (tables: albums, tracks)
Question: List name of all tracks in Balls to the Wall.
SQL: SELECT T2.name FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.title = "Balls to the Wall";
Database: store_1 (tables: albums, tracks)
Question: What is the name of all tracks in the album named Balls to the Wall?
SQL: SELECT T2.name FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.title = "Balls to the Wall";
Database: store_1 (tables: albums, tracks)
Question: List title of albums have the number of tracks greater than 10.
SQL: SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.album_id GROUP BY T1.id HAVING count(T1.id)  >  10;
Database: store_1 (tables: albums, tracks)
Question: What are the names of the albums that have more than 10 tracks?
SQL: SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.album_id GROUP BY T1.id HAVING count(T1.id)  >  10;
Database: store_1 (tables: genres, tracks, media_types)
Question: List the name of tracks belongs to genre Rock and whose media type is MPEG audio file.
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = "Rock" AND T3.name = "MPEG audio file";
Database: store_1 (tables: genres, tracks, media_types)
Question: What are the names of all Rock tracks that are stored on MPEG audio files?
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = "Rock" AND T3.name = "MPEG audio file";
Database: store_1 (tables: genres, tracks, media_types)
Question: List the name of tracks belongs to genre Rock or media type is MPEG audio file.
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = "Rock" OR T3.name = "MPEG audio file";
Database: store_1 (tables: genres, tracks, media_types)
Question: What are the names of all tracks that belong to the Rock genre and whose media type is MPEG?
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = "Rock" OR T3.name = "MPEG audio file";
Database: store_1 (tables: genres, tracks)
Question: List the name of tracks belongs to genre Rock or genre Jazz.
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.name = "Rock" OR T1.name = "Jazz"
Database: store_1 (tables: genres, tracks)
Question: What are the names of the tracks that are Rock or Jazz songs?
SQL: SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.name = "Rock" OR T1.name = "Jazz"
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: List the name of all tracks in the playlists of Movies.
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T3.id = T2.playlist_id WHERE T3.name = "Movies";
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: What are the names of all tracks that are on playlists titled Movies?
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T3.id = T2.playlist_id WHERE T3.name = "Movies";
Database: store_1 (tables: playlists, playlist_tracks)
Question: List the name of playlist which has number of tracks greater than 100.
SQL: SELECT T2.name FROM playlist_tracks AS T1 JOIN playlists AS T2 ON T2.id = T1.playlist_id GROUP BY T1.playlist_id HAVING count(T1.track_id)  >  100;
Database: store_1 (tables: playlists, playlist_tracks)
Question: What are the names of all playlists that have more than 100 tracks?
SQL: SELECT T2.name FROM playlist_tracks AS T1 JOIN playlists AS T2 ON T2.id = T1.playlist_id GROUP BY T1.playlist_id HAVING count(T1.track_id)  >  100;
Database: store_1 (tables: customers, invoices, tracks, invoice_lines)
Question: List all tracks bought by customer Daan Peeters.
SQL: SELECT T1.name FROM tracks AS T1 JOIN invoice_lines AS T2 ON T1.id = T2.track_id JOIN invoices AS T3 ON T3.id = T2.invoice_id JOIN customers AS T4 ON T4.id = T3.customer_id WHERE T4.first_name = "Daan" AND T4.last_name = "Peeters";
Database: store_1 (tables: customers, invoices, tracks, invoice_lines)
Question: What are the tracks that Dean Peeters bought?
SQL: SELECT T1.name FROM tracks AS T1 JOIN invoice_lines AS T2 ON T1.id = T2.track_id JOIN invoices AS T3 ON T3.id = T2.invoice_id JOIN customers AS T4 ON T4.id = T3.customer_id WHERE T4.first_name = "Daan" AND T4.last_name = "Peeters";
Database: store_1 (tables: tracks)
Question: How much is the track Fast As a Shark?
SQL: SELECT unit_price FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: tracks)
Question: What is the unit price of the tune "Fast As a Shark"?
SQL: SELECT unit_price FROM tracks WHERE name = "Fast As a Shark";
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: Find the name of tracks which are in Movies playlist but not in music playlist.
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Movies' EXCEPT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Music'
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: What are the names of all tracks that are on the Movies playlist but not in the music playlist?
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Movies' EXCEPT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Music'
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: Find the name of tracks which are in both Movies and music playlists.
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Movies' INTERSECT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Music'
Database: store_1 (tables: tracks, playlists, playlist_tracks)
Question: What are the names of all the tracks that are in both the Movies and music playlists?
SQL: SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Movies' INTERSECT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id  =  T2.track_id JOIN playlists AS T3 ON T2.playlist_id  =  T3.id WHERE T3.name  =  'Music'
Database: store_1 (tables: genres, tracks)
Question: Find number of tracks in each genre?
SQL: SELECT count(*) ,  T1.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id GROUP BY T1.name;
Database: store_1 (tables: genres, tracks)
Question: How many tracks are in each genre?
SQL: SELECT count(*) ,  T1.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id GROUP BY T1.name;
Database: journal_committee (tables: editor)
Question: How many editors are there?
SQL: SELECT count(*) FROM editor
Database: journal_committee (tables: editor)
Question: List the names of editors in ascending order of age.
SQL: SELECT Name FROM editor ORDER BY Age ASC