target-benchmark/spider-queries huggingface dataset:
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: Find the name and active date of the customer that use email as the contact channel.
SQL: SELECT t1.customer_name ,  t2.active_from_date FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t2.channel_code  =  'Email'
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: What are the name and active date of the customers whose contact channel code is email?
SQL: SELECT t1.customer_name ,  t2.active_from_date FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t2.channel_code  =  'Email'
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: What is the name of the customer that made the order with the largest quantity?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t3.order_quantity  =  ( SELECT max(order_quantity) FROM order_items)
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: Find the name of the customer who made the order of the largest amount of goods.
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t3.order_quantity  =  ( SELECT max(order_quantity) FROM order_items)
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: What is the name of the customer that has purchased the most items?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id GROUP BY t1.customer_name ORDER BY sum(t3.order_quantity) DESC LIMIT 1
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: Give me the name of the customer who ordered the most items in total.
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id GROUP BY t1.customer_name ORDER BY sum(t3.order_quantity) DESC LIMIT 1
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: What is the payment method of the customer that has purchased the least quantity of items?
SQL: SELECT t1.payment_method FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id GROUP BY t1.customer_name ORDER BY sum(t3.order_quantity) LIMIT 1
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: Tell me the payment method used by the customer who ordered the least amount of goods in total.
SQL: SELECT t1.payment_method FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id GROUP BY t1.customer_name ORDER BY sum(t3.order_quantity) LIMIT 1
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: How many types of products have Rodrick Heaney bought in total?
SQL: SELECT count(DISTINCT t3.product_id) FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t1.customer_name  =  "Rodrick Heaney"
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: Find the number of distinct products Rodrick Heaney has bought so far.
SQL: SELECT count(DISTINCT t3.product_id) FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t1.customer_name  =  "Rodrick Heaney"
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: What is the total quantity of products purchased by "Rodrick Heaney"?
SQL: SELECT sum(t3.order_quantity) FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t1.customer_name  =  "Rodrick Heaney"
Database: customers_and_addresses (tables: customer_orders, customers, order_items)
Question: Tell me the total quantity of products bought by the customer called "Rodrick Heaney".
SQL: SELECT sum(t3.order_quantity) FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id WHERE t1.customer_name  =  "Rodrick Heaney"
Database: customers_and_addresses (tables: customer_orders)
Question: How many customers have at least one order with status "Cancelled"?
SQL: SELECT count(DISTINCT customer_id) FROM customer_orders WHERE order_status  =  "Cancelled"
Database: customers_and_addresses (tables: customer_orders)
Question: Return the number of customers who have at least one order with "Cancelled" status.
SQL: SELECT count(DISTINCT customer_id) FROM customer_orders WHERE order_status  =  "Cancelled"
Database: customers_and_addresses (tables: customer_orders)
Question: How many orders have detail "Second time"?
SQL: SELECT count(*) FROM customer_orders WHERE order_details  =  "Second time"
Database: customers_and_addresses (tables: customer_orders)
Question: Tell me the number of orders with "Second time" as order detail.
SQL: SELECT count(*) FROM customer_orders WHERE order_details  =  "Second time"
Database: customers_and_addresses (tables: customer_orders, customers)
Question: Find the customer name and date of the orders that have the status "Delivered".
SQL: SELECT t1.customer_name ,  t2.order_date FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id WHERE order_status  =  "Delivered"
Database: customers_and_addresses (tables: customer_orders, customers)
Question: What are the customer name and date of the orders whose status is "Delivered".
SQL: SELECT t1.customer_name ,  t2.order_date FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id WHERE order_status  =  "Delivered"
Database: customers_and_addresses (tables: customer_orders, order_items)
Question: What is the total number of products that are in orders with status "Cancelled"?
SQL: SELECT sum(t2.order_quantity) FROM customer_orders AS t1 JOIN order_items AS t2 ON t1.order_id  =  t2.order_id WHERE t1.order_status  =  "Cancelled"
Database: customers_and_addresses (tables: customer_orders, order_items)
Question: Find the total quantity of products associated with the orders in the "Cancelled" status.
SQL: SELECT sum(t2.order_quantity) FROM customer_orders AS t1 JOIN order_items AS t2 ON t1.order_id  =  t2.order_id WHERE t1.order_status  =  "Cancelled"
Database: customers_and_addresses (tables: customer_orders, order_items)
Question: Find the total amount of products ordered before 2018-03-17 07:13:53.
SQL: SELECT sum(t2.order_quantity) FROM customer_orders AS t1 JOIN order_items AS t2 ON t1.order_id  =  t2.order_id WHERE t1.order_date  <  "2018-03-17 07:13:53"
Database: customers_and_addresses (tables: customer_orders, order_items)
Question: What is the total amount of products purchased before 2018-03-17 07:13:53?
SQL: SELECT sum(t2.order_quantity) FROM customer_orders AS t1 JOIN order_items AS t2 ON t1.order_id  =  t2.order_id WHERE t1.order_date  <  "2018-03-17 07:13:53"
Database: customers_and_addresses (tables: customer_orders, customers)
Question: Who made the latest order?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id ORDER BY t2.order_date DESC LIMIT 1
Database: customers_and_addresses (tables: customer_orders, customers)
Question: Find the name of the customer who made an order most recently.
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id ORDER BY t2.order_date DESC LIMIT 1
Database: customers_and_addresses (tables: products, order_items)
Question: Which product has been ordered most number of times?
SQL: SELECT t2.product_details FROM order_items AS t1 JOIN products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_id ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: products, order_items)
Question: What is the most frequently ordered product? Tell me the detail of the product
SQL: SELECT t2.product_details FROM order_items AS t1 JOIN products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_id ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: products, order_items)
Question: Find the name and ID of the product whose total order quantity is the largest.
SQL: SELECT t2.product_details ,  t2.product_id FROM order_items AS t1 JOIN products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_id ORDER BY sum(t1.order_quantity) LIMIT 1
Database: customers_and_addresses (tables: products, order_items)
Question: What are the name and ID of the product bought the most.
SQL: SELECT t2.product_details ,  t2.product_id FROM order_items AS t1 JOIN products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_id ORDER BY sum(t1.order_quantity) LIMIT 1
Database: customers_and_addresses (tables: addresses)
Question: Find all the addresses in East Julianaside, Texas or in Gleasonmouth, Arizona.
SQL: SELECT address_content FROM addresses WHERE city  =  "East Julianaside" AND state_province_county  =  "Texas" UNION SELECT address_content FROM addresses WHERE city  =  "Gleasonmouth" AND state_province_county  =  "Arizona"
Database: customers_and_addresses (tables: addresses)
Question: What are all the addresses in East Julianaside, Texas or in Gleasonmouth, Arizona.
SQL: SELECT address_content FROM addresses WHERE city  =  "East Julianaside" AND state_province_county  =  "Texas" UNION SELECT address_content FROM addresses WHERE city  =  "Gleasonmouth" AND state_province_county  =  "Arizona"
Database: customers_and_addresses (tables: customers)
Question: Find the name of customers who did not pay with Cash.
SQL: SELECT customer_name FROM customers WHERE payment_method != 'Cash'
Database: customers_and_addresses (tables: customers)
Question: What is the name of customers who do not use Cash as payment method.
SQL: SELECT customer_name FROM customers WHERE payment_method != 'Cash'
Database: customers_and_addresses (tables: products, customer_orders, customers, order_items)
Question: Find the names of customers who never ordered product Latte.
SQL: SELECT customer_name FROM customers EXCEPT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Latte'
Database: customers_and_addresses (tables: products, customer_orders, customers, order_items)
Question: What are names of customers who never ordered product Latte.
SQL: SELECT customer_name FROM customers EXCEPT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Latte'
Database: customers_and_addresses (tables: customer_orders, customers)
Question: Find the names of customers who never placed an order.
SQL: SELECT customer_name FROM customers EXCEPT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id
Database: customers_and_addresses (tables: customer_orders, customers)
Question: What are the names of customers who never made an order.
SQL: SELECT customer_name FROM customers EXCEPT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id
Database: customers_and_addresses (tables: products, customer_orders, customers, order_items)
Question: Find the names of customers who ordered both products Latte and Americano.
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Latte' INTERSECT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Americano'
Database: customers_and_addresses (tables: products, customer_orders, customers, order_items)
Question: What are the names of customers who have purchased both products Latte and Americano?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Latte' INTERSECT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Americano'
Database: music_4 (tables: artist)
Question: How many artists are there?
SQL: SELECT count(*) FROM artist
Database: music_4 (tables: artist)
Question: Count the number of artists.
SQL: SELECT count(*) FROM artist
Database: music_4 (tables: artist)
Question: List the age of all music artists.
SQL: SELECT Age FROM artist
Database: music_4 (tables: artist)
Question: What are the ages of all music artists?
SQL: SELECT Age FROM artist
Database: music_4 (tables: artist)
Question: What is the average age of all artists?
SQL: SELECT avg(Age) FROM artist
Database: music_4 (tables: artist)
Question: Return the average age across all artists.
SQL: SELECT avg(Age) FROM artist
Database: music_4 (tables: artist)
Question: What are the famous titles of the artist "Triumfall"?
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"
Database: music_4 (tables: artist)
Question: Return the famous titles of the artist called "Triumfall".
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"
Database: music_4 (tables: artist)
Question: What are the distinct Famous release dates?
SQL: SELECT distinct(Famous_Release_date) FROM artist
Database: music_4 (tables: artist)
Question: Give the distinct famous release dates for all artists.
SQL: SELECT distinct(Famous_Release_date) FROM artist
Database: music_4 (tables: music_festival)
Question: Return the dates of ceremony and the results of all music festivals
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival
Database: music_4 (tables: music_festival)
Question: What are the dates of ceremony and results for each music festival?
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival
Database: music_4 (tables: music_festival)
Question: What are the category of music festivals with result "Awarded"?
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"
Database: music_4 (tables: music_festival)
Question: Return the categories of music festivals that have the result "Awarded".
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"
Database: music_4 (tables: volume)
Question: What are the maximum and minimum week on top of all volumes?
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume
Database: music_4 (tables: volume)
Question: Give the maximum and minimum weeks on top across all volumes.
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume
Database: music_4 (tables: volume)
Question: What are the songs in volumes with more than 1 week on top?
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1
Database: music_4 (tables: volume)
Question: Give the songs included in volumes that have more than 1 week on top.
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1
Database: music_4 (tables: volume)
Question: Please list all songs in volumes in ascending alphabetical order.
SQL: SELECT Song FROM volume ORDER BY Song
Database: music_4 (tables: volume)
Question: What are the the songs in volumes, listed in ascending order?
SQL: SELECT Song FROM volume ORDER BY Song
Database: music_4 (tables: volume)
Question: How many distinct artists do the volumes associate to?
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume
Database: music_4 (tables: volume)
Question: Count the number of distinct artists who have volumes.
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume
Database: music_4 (tables: volume, music_festival)
Question: Please show the date of ceremony of the volumes that last more than 2 weeks on top.
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2
Database: music_4 (tables: volume, music_festival)
Question: What are the dates of ceremony at music festivals corresponding to volumes that lasted more than 2 weeks on top?
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2
Database: music_4 (tables: volume, music_festival)
Question: Please show the songs that have result "nominated" at music festivals.
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"
Database: music_4 (tables: volume, music_festival)
Question: What are the songs in volumes that have resulted in a nomination at music festivals?
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"
Database: music_4 (tables: volume, artist)
Question: What are the issue dates of volumes associated with the artist "Gorgoroth"?
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"
Database: music_4 (tables: volume, artist)
Question: Return the issue dates of volumes that are by the artist named Gorgoroth.
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"
Database: music_4 (tables: volume, artist)
Question: What are the songs in volumes associated with the artist aged 32 or older?
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32
Database: music_4 (tables: volume, artist)
Question: Return names of songs in volumes that are by artists that are at least 32 years old.
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32
Database: music_4 (tables: volume, artist)
Question: What is the average weeks on top of volumes associated with the artist aged 25 or younger?
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25
Database: music_4 (tables: volume, artist)
Question: Return the average number of weeks on top for volumes by artists that are at most 25 years old.
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25
Database: music_4 (tables: volume, artist)
Question: What are the famous title of the artists associated with volumes with more than 2 weeks on top?
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2
Database: music_4 (tables: volume, artist)
Question: Return the famous titles for artists that have volumes that lasted more than 2 weeks on top.
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2
Database: music_4 (tables: artist)
Question: Please list the age and famous title of artists in descending order of age.
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC
Database: music_4 (tables: artist)
Question: What are the famous titles and ages of each artist, listed in descending order by age?
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC
Database: music_4 (tables: artist)
Question: What is the famous release date of the artist with the oldest age?
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1
Database: music_4 (tables: artist)
Question: Return the famous release date for the oldest artist.
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1
Database: music_4 (tables: music_festival)
Question: Please show the categories of the music festivals and the count.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category
Database: music_4 (tables: music_festival)
Question: Return the number of music festivals of each category.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category
Database: music_4 (tables: music_festival)
Question: What is the most common result of the music festival?
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
Database: music_4 (tables: music_festival)
Question: Return the result that is most frequent at music festivals.
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
Database: music_4 (tables: music_festival)
Question: Please show the categories of the music festivals with count more than 1.
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1
Database: music_4 (tables: music_festival)
Question: What are the categories of music festivals for which there have been more than 1 music festival?
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1
Database: music_4 (tables: volume)
Question: What is the song in the volume with the maximum weeks on top?
SQL: SELECT Song FROM volume ORDER BY Weeks_on_Top DESC LIMIT 1
Database: music_4 (tables: volume)
Question: Return the song in the volume that has spent the most weeks on top?
SQL: SELECT Song FROM volume ORDER BY Weeks_on_Top DESC LIMIT 1
Database: music_4 (tables: volume, artist)
Question: Find the famous titles of artists that do not have any volume.
SQL: SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)
Database: music_4 (tables: volume, artist)
Question: What are the famous titles of artists who do not have any volumes?
SQL: SELECT Famous_Title FROM artist WHERE Artist_ID NOT IN(SELECT Artist_ID FROM volume)
Database: music_4 (tables: volume, artist)
Question: Show the famous titles of the artists with both volumes that lasted more than 2 weeks on top and volumes that lasted less than 2 weeks on top.
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2 INTERSECT SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  <  2
Database: music_4 (tables: volume, artist)
Question: What are the famous titles of artists who have not only had volumes that spent more than 2 weeks on top but also volumes that spent less than 2 weeks on top?
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2 INTERSECT SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  <  2
Database: music_4 (tables: music_festival)
Question: What are the date of ceremony of music festivals with category "Best Song" and result "Awarded"?
SQL: SELECT Date_of_ceremony FROM music_festival WHERE Category  =  "Best Song" AND RESULT  =  "Awarded"
Database: music_4 (tables: music_festival)
Question: Return the dates of ceremony corresponding to music festivals that had the category "Best Song" and result "Awarded".
SQL: SELECT Date_of_ceremony FROM music_festival WHERE Category  =  "Best Song" AND RESULT  =  "Awarded"
Database: music_4 (tables: volume)
Question: What is the issue date of the volume with the minimum weeks on top?
SQL: SELECT Issue_Date FROM volume ORDER BY Weeks_on_Top ASC LIMIT 1