Database: store_1

Create Tables
********************************************************************************/
CREATE TABLE artists
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(120)
);
CREATE TABLE albums
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title VARCHAR(160)  NOT NULL,
    artist_id INTEGER  NOT NULL,
    FOREIGN KEY (artist_id) REFERENCES artists (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE employees
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    last_name VARCHAR(20)  NOT NULL,
    first_name VARCHAR(20)  NOT NULL,
    title VARCHAR(30),
    reports_to INTEGER,
    birth_date TIMESTAMP,
    hire_date TIMESTAMP,
    address VARCHAR(70),
    city VARCHAR(40),
    state VARCHAR(40),
    country VARCHAR(40),
    postal_code VARCHAR(10),
    phone VARCHAR(24),
    fax VARCHAR(24),
    email VARCHAR(60),
    FOREIGN KEY (reports_to) REFERENCES employees (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE customers
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    first_name VARCHAR(40)  NOT NULL,
    last_name VARCHAR(20)  NOT NULL,
    company VARCHAR(80),
    address VARCHAR(70),
    city VARCHAR(40),
    state VARCHAR(40),
    country VARCHAR(40),
    postal_code VARCHAR(10),
    phone VARCHAR(24),
    fax VARCHAR(24),
    email VARCHAR(60)  NOT NULL,
    support_rep_id INTEGER,
    FOREIGN KEY (support_rep_id) REFERENCES employees (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE genres
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(120)
);
CREATE TABLE invoices
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    customer_id INTEGER  NOT NULL,
    invoice_date TIMESTAMP  NOT NULL,
    billing_address VARCHAR(70),
    billing_city VARCHAR(40),
    billing_state VARCHAR(40),
    billing_country VARCHAR(40),
    billing_postal_code VARCHAR(10),
    total NUMERIC(10,2)  NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES customers (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE media_types
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(120)
);
CREATE TABLE tracks
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(200)  NOT NULL,
    album_id INTEGER,
    media_type_id INTEGER  NOT NULL,
    genre_id INTEGER,
    composer VARCHAR(220),
    milliseconds INTEGER  NOT NULL,
    bytes INTEGER,
    unit_price NUMERIC(10,2)  NOT NULL,
    FOREIGN KEY (album_id) REFERENCES albums (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (genre_id) REFERENCES genres (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (media_type_id) REFERENCES media_types (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE invoice_lines
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    invoice_id INTEGER  NOT NULL,
    track_id INTEGER  NOT NULL,
    unit_price NUMERIC(10,2)  NOT NULL,
    quantity INTEGER  NOT NULL,
    FOREIGN KEY (invoice_id) REFERENCES invoices (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (track_id) REFERENCES tracks (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);
CREATE TABLE playlists
(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(120)
);
CREATE TABLE playlist_tracks
(
    playlist_id INTEGER  NOT NULL,
    track_id INTEGER  NOT NULL,
    CONSTRAINT PK_PlaylistTrack PRIMARY KEY  (playlist_id, track_id),
    FOREIGN KEY (playlist_id) REFERENCES playlists (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (track_id) REFERENCES tracks (id)
    ON DELETE NO ACTION ON UPDATE NO ACTION
);

Question: A list of the top 5 countries by number of invoices. List country name and number of invoices.
SQL: SELECT billing_country ,  COUNT(*) FROM invoices GROUP BY billing_country ORDER BY count(*) DESC LIMIT 5;

Question: What are the top 5 countries by number of invoices and how many do they have?
SQL: SELECT billing_country ,  COUNT(*) FROM invoices GROUP BY billing_country ORDER BY count(*) DESC LIMIT 5;

Question: A list of the top 8 countries by gross/total invoice size. List country name and gross invoice size.
SQL: SELECT billing_country ,  SUM(total) FROM invoices GROUP BY billing_country ORDER BY SUM(total) DESC LIMIT 8;

Question: What are the names of the top 8 countries by total invoice size and what are those sizes?
SQL: SELECT billing_country ,  SUM(total) FROM invoices GROUP BY billing_country ORDER BY SUM(total) DESC LIMIT 8;

Question: A list of the top 10 countries by average invoice size. List country name and average invoice size.
SQL: SELECT billing_country ,  AVG(total) FROM invoices GROUP BY billing_country ORDER BY AVG(total) DESC LIMIT 10;

Question: What are the names of the countries and average invoice size of the top countries by size?
SQL: SELECT billing_country ,  AVG(total) FROM invoices GROUP BY billing_country ORDER BY AVG(total) DESC LIMIT 10;

Question: Find out 5 customers who most recently purchased something. List customers' first and last name.
SQL: SELECT T1.first_name ,  T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id ORDER BY T2.invoice_date DESC LIMIT 5;

Question: What are the first and last names of the 5 customers who purchased something most recently?
SQL: SELECT T1.first_name ,  T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id ORDER BY T2.invoice_date DESC LIMIT 5;

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;

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;

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;

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;

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;

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;

Question: List every album's title.
SQL: SELECT title FROM albums;

Question: What are the titles of all the albums?
SQL: SELECT title FROM albums;

Question: List every album ordered by album title in ascending order.
SQL: SELECT title FROM albums ORDER BY title;

Question: What are the titles of all the albums alphabetically ascending?
SQL: SELECT title FROM albums ORDER BY title;

Question: List every album whose title starts with A in alphabetical order.
SQL: SELECT title FROM albums WHERE title LIKE 'A%' ORDER BY title;

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;

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;

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;

Question: List total amount of  invoice from Chicago, IL.
SQL: SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";

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";

Question: List the number of invoices from Chicago, IL.
SQL: SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";

Question: How many invoices were billed from Chicago, IL?
SQL: SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";

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;

Question: How many invoices were billed from each state?
SQL: SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state;

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;

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;

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";

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";

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";

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";

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";

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";

Question: Eduardo Martins is a customer at which company?
SQL: SELECT company FROM customers WHERE first_name = "Eduardo" AND last_name = "Martins";

Question: What is the company where Eduardo Martins is a customer?
SQL: SELECT company FROM customers WHERE first_name = "Eduardo" AND last_name = "Martins";

Question: What is Astrid Gruber's email and phone number?
SQL: SELECT email ,  phone FROM customers WHERE first_name = "Astrid" AND last_name = "Gruber";

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";

Question: How many customers live in Prague city?
SQL: SELECT count(*) FROM customers WHERE city = "Prague";

Question: How many customers live in the city of Prague?
SQL: SELECT count(*) FROM customers WHERE city = "Prague";

Question: How many customers in state of CA?
SQL: SELECT count(*) FROM customers WHERE state = "CA";

Question: How many customers are from California?
SQL: SELECT count(*) FROM customers WHERE state = "CA";

Question: What country does Roberto Almeida live?
SQL: SELECT country FROM customers WHERE first_name = "Roberto" AND last_name = "Almeida";

Question: In which country does Roberto Almeida?
SQL: SELECT country FROM customers WHERE first_name = "Roberto" AND last_name = "Almeida";

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%'

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%'

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";

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";

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";

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";

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";

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";

Question: What is the address of employee Nancy Edwards?
SQL: SELECT address FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";

Question: What is Nancy Edwards's address?
SQL: SELECT address FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";

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

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

Question: How many employees are living in Canada?
SQL: SELECT count(*) FROM employees WHERE country = "Canada";

Question: How many employees live in Canada?
SQL: SELECT count(*) FROM employees WHERE country = "Canada";

Question: What is employee Nancy Edwards's phone number?
SQL: SELECT phone FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";

Question: What is the the phone number of Nancy Edwards?
SQL: SELECT phone FROM employees WHERE first_name = "Nancy" AND last_name = "Edwards";

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;

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;

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;

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;

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

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

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;

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;

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";

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";

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";

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";

Question: List all media types.
SQL: SELECT name FROM media_types;

Question: What are the names of all the media types?
SQL: SELECT name FROM media_types;

Question: List all different genre types.
SQL: SELECT DISTINCT name FROM genres;

Question: What are the different names of the genres?
SQL: SELECT DISTINCT name FROM genres;

Question: List the name of all playlist.
SQL: SELECT name FROM playlists;

Question: What are the names of all the playlists?
SQL: SELECT name FROM playlists;

Question: Who is the composer of track Fast As a Shark?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";

Question: What is the composer who created the track "Fast As a Shark"?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";

Question: How long does track Fast As a Shark has?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";

Question: How many milliseconds long is Fast As a Shark?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";

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";

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";

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";

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";

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";

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";

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;

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;

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";

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";

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";

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";

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"

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"

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";

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";

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;

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;

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";

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";

Question: How much is the track Fast As a Shark?
SQL: SELECT unit_price FROM tracks WHERE name = "Fast As a Shark";

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";

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'

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'

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'

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'

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;

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;