target-benchmark/spider-queries huggingface dataset:
Database: game_1 (tables: sportsinfo)
Question: How many games are played for all students?
SQL: SELECT sum(gamesplayed) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: What is the total number of games played?
SQL: SELECT sum(gamesplayed) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: How many games are played for all football games by students on scholarship?
SQL: SELECT sum(gamesplayed) FROM Sportsinfo WHERE sportname  =  "Football" AND onscholarship  =  'Y'
Database: game_1 (tables: sportsinfo)
Question: What is the total number of all football games played by scholarship students?
SQL: SELECT sum(gamesplayed) FROM Sportsinfo WHERE sportname  =  "Football" AND onscholarship  =  'Y'
Database: game_1 (tables: sportsinfo)
Question: Show all sport name and the number of students.
SQL: SELECT sportname ,  count(*) FROM Sportsinfo GROUP BY sportname
Database: game_1 (tables: sportsinfo)
Question: How many students play each sport?
SQL: SELECT sportname ,  count(*) FROM Sportsinfo GROUP BY sportname
Database: game_1 (tables: sportsinfo)
Question: Show all student IDs with the number of sports and total number of games played
SQL: SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID
Database: game_1 (tables: sportsinfo)
Question: What are the ids of all students along with how many sports and games did they play?
SQL: SELECT StuID ,  count(*) ,  sum(gamesplayed) FROM Sportsinfo GROUP BY StuID
Database: game_1 (tables: sportsinfo)
Question: Show all student IDs with more than total 10 hours per week on all sports played.
SQL: SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING sum(hoursperweek)  >  10
Database: game_1 (tables: sportsinfo)
Question: What are the student IDs for everybody who worked for more than 10 hours per week on all sports?
SQL: SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING sum(hoursperweek)  >  10
Database: game_1 (tables: student, sportsinfo)
Question: What is the first name and last name of the student who have most number of sports?
SQL: SELECT T2.Fname ,  T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID GROUP BY T1.StuID ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: student, sportsinfo)
Question: What is the first and last name of the student who played the most sports?
SQL: SELECT T2.Fname ,  T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID GROUP BY T1.StuID ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: sportsinfo)
Question: Which sport has most number of students on scholarship?
SQL: SELECT sportname FROM Sportsinfo WHERE onscholarship  =  'Y' GROUP BY sportname ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: sportsinfo)
Question: What is the sport with the most scholarship students?
SQL: SELECT sportname FROM Sportsinfo WHERE onscholarship  =  'Y' GROUP BY sportname ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: student, sportsinfo)
Question: Show student ids who don't have any sports.
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Sportsinfo
Database: game_1 (tables: student, sportsinfo)
Question: What are the ids of all students who don't play sports?
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Sportsinfo
Database: game_1 (tables: student, sportsinfo)
Question: Show student ids who are on scholarship and have major 600.
SQL: SELECT StuID FROM Student WHERE major  =  600 INTERSECT SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
Database: game_1 (tables: student, sportsinfo)
Question: What are the student ids for those on scholarship in major number 600?
SQL: SELECT StuID FROM Student WHERE major  =  600 INTERSECT SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
Database: game_1 (tables: student, sportsinfo)
Question: Show student ids who are female and play football.
SQL: SELECT StuID FROM Student WHERE sex  =  'F' INTERSECT SELECT StuID FROM Sportsinfo WHERE sportname  =  "Football"
Database: game_1 (tables: student, sportsinfo)
Question: What are the ids of all female students who play football?
SQL: SELECT StuID FROM Student WHERE sex  =  'F' INTERSECT SELECT StuID FROM Sportsinfo WHERE sportname  =  "Football"
Database: game_1 (tables: student, sportsinfo)
Question: Show all male student ids who don't play football.
SQL: SELECT StuID FROM Student WHERE sex  =  'M' EXCEPT SELECT StuID FROM Sportsinfo WHERE sportname  =  "Football"
Database: game_1 (tables: student, sportsinfo)
Question: What are the ids of all male students who do not play football?
SQL: SELECT StuID FROM Student WHERE sex  =  'M' EXCEPT SELECT StuID FROM Sportsinfo WHERE sportname  =  "Football"
Database: game_1 (tables: student, sportsinfo)
Question: Show total hours per week and number of games played for student David Shieber.
SQL: SELECT sum(hoursperweek) ,  sum(gamesplayed) FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T2.Fname  =  "David" AND T2.Lname  =  "Shieber"
Database: game_1 (tables: student, sportsinfo)
Question: What is the total number of hours per work and number of games played by David Shieber?
SQL: SELECT sum(hoursperweek) ,  sum(gamesplayed) FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T2.Fname  =  "David" AND T2.Lname  =  "Shieber"
Database: game_1 (tables: student, sportsinfo)
Question: Show total hours per week and number of games played for students under 20.
SQL: SELECT sum(hoursperweek) ,  sum(gamesplayed) FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T2.age  <  20
Database: game_1 (tables: student, sportsinfo)
Question: What is the total number of hours per week and number of games played by students under 20?
SQL: SELECT sum(hoursperweek) ,  sum(gamesplayed) FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T2.age  <  20
Database: game_1 (tables: plays_games)
Question: How many students play video games?
SQL: SELECT count(DISTINCT StuID) FROM Plays_games
Database: game_1 (tables: plays_games)
Question: How many different students play games?
SQL: SELECT count(DISTINCT StuID) FROM Plays_games
Database: game_1 (tables: student, plays_games)
Question: Show ids of students who don't play video game.
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Plays_games
Database: game_1 (tables: student, plays_games)
Question: What are the ids of all students who are not video game players?
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Plays_games
Database: game_1 (tables: sportsinfo, plays_games)
Question: Show ids of students who play video game and play sports.
SQL: SELECT StuID FROM Sportsinfo INTERSECT SELECT StuID FROM Plays_games
Database: game_1 (tables: sportsinfo, plays_games)
Question: What are the ids of all students who played video games and sports?
SQL: SELECT StuID FROM Sportsinfo INTERSECT SELECT StuID FROM Plays_games
Database: game_1 (tables: plays_games)
Question: Show all game ids and the number of hours played.
SQL: SELECT gameid ,  sum(hours_played) FROM Plays_games GROUP BY gameid
Database: game_1 (tables: plays_games)
Question: What are ids and total number of hours played for each game?
SQL: SELECT gameid ,  sum(hours_played) FROM Plays_games GROUP BY gameid
Database: game_1 (tables: plays_games)
Question: Show all student ids and the number of hours played.
SQL: SELECT Stuid ,  sum(hours_played) FROM Plays_games GROUP BY Stuid
Database: game_1 (tables: plays_games)
Question: What are the ids of all students and number of hours played?
SQL: SELECT Stuid ,  sum(hours_played) FROM Plays_games GROUP BY Stuid
Database: game_1 (tables: video_games, plays_games)
Question: Show the game name that has most number of hours played.
SQL: SELECT gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid GROUP BY T1.gameid ORDER BY sum(hours_played) DESC LIMIT 1
Database: game_1 (tables: video_games, plays_games)
Question: What is the name of the game that has been played the most?
SQL: SELECT gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid GROUP BY T1.gameid ORDER BY sum(hours_played) DESC LIMIT 1
Database: game_1 (tables: video_games, plays_games)
Question: Show all game names played by at least 1000 hours.
SQL: SELECT gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid GROUP BY T1.gameid HAVING sum(hours_played)  >=  1000
Database: game_1 (tables: video_games, plays_games)
Question: What are the names of all the games that have been played for at least 1000 hours?
SQL: SELECT gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid GROUP BY T1.gameid HAVING sum(hours_played)  >=  1000
Database: game_1 (tables: video_games, student, plays_games)
Question: Show all game names played by Linda Smith
SQL: SELECT Gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid JOIN Student AS T3 ON T3.Stuid  =  T1.Stuid WHERE T3.Lname  =  "Smith" AND T3.Fname  =  "Linda"
Database: game_1 (tables: video_games, student, plays_games)
Question: What are the names of all games played by Linda Smith?
SQL: SELECT Gname FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.gameid  =  T2.gameid JOIN Student AS T3 ON T3.Stuid  =  T1.Stuid WHERE T3.Lname  =  "Smith" AND T3.Fname  =  "Linda"
Database: game_1 (tables: student, sportsinfo)
Question: Find the last and first name of students who are playing Football or Lacrosse.
SQL: SELECT T2.lname ,  T2.fname FROM SportsInfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T1.SportName  =  "Football" OR T1.SportName  =  "Lacrosse"
Database: game_1 (tables: student, sportsinfo)
Question: What is the first and last name of all students who play Football or Lacrosse?
SQL: SELECT T2.lname ,  T2.fname FROM SportsInfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T1.SportName  =  "Football" OR T1.SportName  =  "Lacrosse"
Database: game_1 (tables: student, sportsinfo)
Question: Find the first name and age of the students who are playing both Football and Lacrosse.
SQL: SELECT fname ,  age FROM Student WHERE StuID IN (SELECT StuID FROM Sportsinfo WHERE SportName  =  "Football" INTERSECT SELECT StuID FROM Sportsinfo WHERE SportName  =  "Lacrosse")
Database: game_1 (tables: student, sportsinfo)
Question: What are the first names and ages of all students who are playing both Football and Lacrosse?
SQL: SELECT fname ,  age FROM Student WHERE StuID IN (SELECT StuID FROM Sportsinfo WHERE SportName  =  "Football" INTERSECT SELECT StuID FROM Sportsinfo WHERE SportName  =  "Lacrosse")
Database: game_1 (tables: video_games, student, plays_games)
Question: Find the last name and gender of the students who are playing both Call of Destiny and Works of Widenius games.
SQL: SELECT lname ,  sex FROM Student WHERE StuID IN (SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID  =  T2.GameID WHERE T2.Gname  =  "Call of Destiny" INTERSECT SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID  =  T2.GameID WHERE T2.Gname  =  "Works of Widenius")
Database: game_1 (tables: video_games, student, plays_games)
Question: what is the last name and gender of all students who played both Call of Destiny and Works of Widenius?
SQL: SELECT lname ,  sex FROM Student WHERE StuID IN (SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID  =  T2.GameID WHERE T2.Gname  =  "Call of Destiny" INTERSECT SELECT T1.StuID FROM Plays_games AS T1 JOIN Video_games AS T2 ON T1.GameID  =  T2.GameID WHERE T2.Gname  =  "Works of Widenius")
Database: customers_and_addresses (tables: customers)
Question: Find the name of all customers.
SQL: SELECT customer_name FROM customers
Database: customers_and_addresses (tables: customers)
Question: What are the names of all the customers?
SQL: SELECT customer_name FROM customers
Database: customers_and_addresses (tables: customers)
Question: How many customers are there?
SQL: SELECT count(*) FROM customers
Database: customers_and_addresses (tables: customers)
Question: Return the total number of distinct customers.
SQL: SELECT count(*) FROM customers
Database: customers_and_addresses (tables: order_items)
Question: What is the average amount of items ordered in each order?
SQL: SELECT avg(order_quantity) FROM order_items
Database: customers_and_addresses (tables: order_items)
Question: Find the average order quantity per order.
SQL: SELECT avg(order_quantity) FROM order_items
Database: customers_and_addresses (tables: customers)
Question: What are the names of customers who use payment method "Cash"?
SQL: SELECT customer_name FROM customers WHERE payment_method  =  "Cash"
Database: customers_and_addresses (tables: customers)
Question: Which customers use "Cash" for payment method? Return the customer names.
SQL: SELECT customer_name FROM customers WHERE payment_method  =  "Cash"
Database: customers_and_addresses (tables: customers)
Question: Find the "date became customers" of the customers whose ID is between 10 and 20.
SQL: SELECT date_became_customer FROM customers WHERE customer_id BETWEEN 10 AND 20
Database: customers_and_addresses (tables: customers)
Question: What are the dates when customers with ids between 10 and 20 became customers?
SQL: SELECT date_became_customer FROM customers WHERE customer_id BETWEEN 10 AND 20
Database: customers_and_addresses (tables: customers)
Question: Which payment method is used by most customers?
SQL: SELECT payment_method FROM customers GROUP BY payment_method ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: customers)
Question: Find the payment method that is used most frequently.
SQL: SELECT payment_method FROM customers GROUP BY payment_method ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: customers)
Question: What are the names of customers using the most popular payment method?
SQL: SELECT customer_name FROM customers WHERE payment_method  =  (SELECT payment_method FROM customers GROUP BY payment_method ORDER BY count(*) DESC LIMIT 1)
Database: customers_and_addresses (tables: customers)
Question: Find the name of the customers who use the most frequently used payment method.
SQL: SELECT customer_name FROM customers WHERE payment_method  =  (SELECT payment_method FROM customers GROUP BY payment_method ORDER BY count(*) DESC LIMIT 1)
Database: customers_and_addresses (tables: customers)
Question: What are all the payment methods?
SQL: SELECT DISTINCT payment_method FROM customers
Database: customers_and_addresses (tables: customers)
Question: Return all the distinct payment methods used by customers.
SQL: SELECT DISTINCT payment_method FROM customers
Database: customers_and_addresses (tables: products)
Question: What are the details of all products?
SQL: SELECT DISTINCT product_details FROM products
Database: customers_and_addresses (tables: products)
Question: Return the the details of all products.
SQL: SELECT DISTINCT product_details FROM products
Database: customers_and_addresses (tables: customers)
Question: Find the name of all customers whose name contains "Alex".
SQL: SELECT customer_name FROM customers WHERE customer_name LIKE "%Alex%"
Database: customers_and_addresses (tables: customers)
Question: Which customer's name contains "Alex"? Find the full name.
SQL: SELECT customer_name FROM customers WHERE customer_name LIKE "%Alex%"
Database: customers_and_addresses (tables: products)
Question: Find the detail of products whose detail contains the word "Latte" or the word "Americano"
SQL: SELECT product_details FROM products WHERE product_details LIKE "%Latte%" OR product_details LIKE "%Americano%"
Database: customers_and_addresses (tables: products)
Question: Which product's detail contains the word "Latte" or "Americano"? Return the full detail.
SQL: SELECT product_details FROM products WHERE product_details LIKE "%Latte%" OR product_details LIKE "%Americano%"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: What is the address content of the customer named "Maudie Kertzmann"?
SQL: SELECT t3.address_content FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t1.customer_name  =  "Maudie Kertzmann"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Return the address content for the customer whose name is "Maudie Kertzmann".
SQL: SELECT t3.address_content FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t1.customer_name  =  "Maudie Kertzmann"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: How many customers are living in city "Lake Geovannyton"?
SQL: SELECT count(*) FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.city  =  "Lake Geovannyton"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Find the number of customers who live in the city called Lake Geovannyton.
SQL: SELECT count(*) FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.city  =  "Lake Geovannyton"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Find the name of customers who are living in Colorado?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.state_province_county  =  "Colorado"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: What are the names of customers who live in Colorado state?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.state_province_county  =  "Colorado"
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Find the list of cities that no customer is living in.
SQL: SELECT city FROM addresses WHERE city NOT IN ( SELECT DISTINCT t3.city FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id)
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: What are the cities no customers live in?
SQL: SELECT city FROM addresses WHERE city NOT IN ( SELECT DISTINCT t3.city FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id)
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Which city has the most customers living in?
SQL: SELECT t3.city FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id GROUP BY t3.city ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: addresses, customers, customer_addresses)
Question: Find the city where the most customers live.
SQL: SELECT t3.city FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id GROUP BY t3.city ORDER BY count(*) DESC LIMIT 1
Database: customers_and_addresses (tables: addresses)
Question: Retrieve the list of all cities.
SQL: SELECT DISTINCT city FROM addresses
Database: customers_and_addresses (tables: addresses)
Question: List all the distinct cities
SQL: SELECT DISTINCT city FROM addresses
Database: customers_and_addresses (tables: addresses)
Question: Find the city with post code 255.
SQL: SELECT city FROM addresses WHERE zip_postcode  =  255
Database: customers_and_addresses (tables: addresses)
Question: Which city is post code 255 located in?
SQL: SELECT city FROM addresses WHERE zip_postcode  =  255
Database: customers_and_addresses (tables: addresses)
Question: Find the state and country of all cities with post code starting with 4.
SQL: SELECT state_province_county ,  country FROM addresses WHERE zip_postcode LIKE "4%"
Database: customers_and_addresses (tables: addresses)
Question: What are the state and country of all the cities that have post codes starting with 4.\
SQL: SELECT state_province_county ,  country FROM addresses WHERE zip_postcode LIKE "4%"
Database: customers_and_addresses (tables: addresses)
Question: List the countries having more than 4 addresses listed.
SQL: SELECT country FROM addresses GROUP BY country HAVING count(address_id)  >  4
Database: customers_and_addresses (tables: addresses)
Question: For which countries are there more than four distinct addresses listed?
SQL: SELECT country FROM addresses GROUP BY country HAVING count(address_id)  >  4
Database: customers_and_addresses (tables: customer_contact_channels)
Question: List all the contact channel codes that were used less than 5 times.
SQL: SELECT channel_code FROM customer_contact_channels GROUP BY channel_code HAVING count(customer_id)  <  5
Database: customers_and_addresses (tables: customer_contact_channels)
Question: Which contact channel codes were used less than 5 times?
SQL: SELECT channel_code FROM customer_contact_channels GROUP BY channel_code HAVING count(customer_id)  <  5
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: Which contact channel has been used by the customer with name "Tillman Ernser"?
SQL: SELECT DISTINCT channel_code FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: Find the contact channel code that was used by the customer named "Tillman Ernser".
SQL: SELECT DISTINCT channel_code FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: What is the "active to date" of the latest contact channel used by "Tillman Ernser"?
SQL: SELECT max(t2.active_to_date) FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"
Database: customers_and_addresses (tables: customer_contact_channels, customers)
Question: Return the the "active to date" of the latest contact channel used by the customer named "Tillman Ernser".
SQL: SELECT max(t2.active_to_date) FROM customers AS t1 JOIN customer_contact_channels AS t2 ON t1.customer_id  =  t2.customer_id WHERE t1.customer_name  =  "Tillman Ernser"
Database: customers_and_addresses (tables: customer_contact_channels)
Question: What is the average time span of contact channels in the database?
SQL: SELECT avg(active_to_date - active_from_date) FROM customer_contact_channels
Database: customers_and_addresses (tables: customer_contact_channels)
Question: Compute the average active time span of contact channels.
SQL: SELECT avg(active_to_date - active_from_date) FROM customer_contact_channels
Database: customers_and_addresses (tables: customer_contact_channels)
Question: What is the channel code and contact number of the customer contact channel that was active for the longest time?
SQL: SELECT channel_code ,  contact_number FROM customer_contact_channels WHERE active_to_date - active_from_date  =  (SELECT active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC LIMIT 1)
Database: customers_and_addresses (tables: customer_contact_channels)
Question: Return the channel code and contact number of the customer contact channel whose active duration was the longest.
SQL: SELECT channel_code ,  contact_number FROM customer_contact_channels WHERE active_to_date - active_from_date  =  (SELECT active_to_date - active_from_date FROM customer_contact_channels ORDER BY (active_to_date - active_from_date) DESC LIMIT 1)