target-benchmark/spider-queries huggingface dataset:
Database: gymnast (tables: gymnast, people)
Question: What is the total point count of the youngest gymnast?
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1
Database: gymnast (tables: gymnast, people)
Question: Return the total points of the gymnast with the lowest age.
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1
Database: gymnast (tables: gymnast, people)
Question: What is the average age of all gymnasts?
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
Database: gymnast (tables: gymnast, people)
Question: Return the average age across all gymnasts.
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
Database: gymnast (tables: gymnast, people)
Question: What are the distinct hometowns of gymnasts with total points more than 57.5?
SQL: SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T1.Total_Points  >  57.5
Database: gymnast (tables: gymnast, people)
Question: Give the different hometowns of gymnasts that have a total point score of above 57.5.
SQL: SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T1.Total_Points  >  57.5
Database: gymnast (tables: gymnast, people)
Question: What are the hometowns of gymnasts and the corresponding number of gymnasts?
SQL: SELECT T2.Hometown ,  COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown
Database: gymnast (tables: gymnast, people)
Question: How many gymnasts are from each hometown?
SQL: SELECT T2.Hometown ,  COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown
Database: gymnast (tables: gymnast, people)
Question: What is the most common hometown of gymnasts?
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown ORDER BY COUNT(*) DESC LIMIT 1
Database: gymnast (tables: gymnast, people)
Question: Return the hometown that is most common among gymnasts.
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown ORDER BY COUNT(*) DESC LIMIT 1
Database: gymnast (tables: gymnast, people)
Question: What are the hometowns that are shared by at least two gymnasts?
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown HAVING COUNT(*)  >=  2
Database: gymnast (tables: gymnast, people)
Question: Give the hometowns from which two or more gymnasts are from.
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown HAVING COUNT(*)  >=  2
Database: gymnast (tables: gymnast, people)
Question: List the names of gymnasts in ascending order by their heights.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Height ASC
Database: gymnast (tables: gymnast, people)
Question: What are the names of gymnasts, ordered by their heights ascending?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Height ASC
Database: gymnast (tables: gymnast, people)
Question: List the distinct hometowns that are not associated with any gymnast.
SQL: SELECT DISTINCT Hometown FROM people EXCEPT SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
Database: gymnast (tables: gymnast, people)
Question: From which hometowns did no gymnasts come from?
SQL: SELECT DISTINCT Hometown FROM people EXCEPT SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
Database: gymnast (tables: people)
Question: Show the hometowns shared by people older than 23 and younger than 20.
SQL: SELECT Hometown FROM people WHERE Age  >  23 INTERSECT SELECT Hometown FROM people WHERE Age  <  20
Database: gymnast (tables: people)
Question: From which hometowns did both people older than 23 and younger than 20 come from?
SQL: SELECT Hometown FROM people WHERE Age  >  23 INTERSECT SELECT Hometown FROM people WHERE Age  <  20
Database: gymnast (tables: people)
Question: How many distinct hometowns did these people have?
SQL: SELECT count(DISTINCT Hometown) FROM people
Database: gymnast (tables: people)
Question: Count the number of different hometowns of these people.
SQL: SELECT count(DISTINCT Hometown) FROM people
Database: gymnast (tables: gymnast, people)
Question: Show the ages of gymnasts in descending order of total points.
SQL: SELECT T2.Age FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T1.Total_Points DESC
Database: gymnast (tables: gymnast, people)
Question: What are the ages of the gymnasts, ordered descending by their total points?
SQL: SELECT T2.Age FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T1.Total_Points DESC
Database: small_bank_1 (tables: savings, accounts)
Question: Find the total savings balance of all accounts except the account with name ‘Brown’.
SQL: SELECT sum(T2.balance) FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T1.name != 'Brown'
Database: small_bank_1 (tables: savings, accounts)
Question: What is the total balance of savings accounts not belonging to someone with the name Brown?
SQL: SELECT sum(T2.balance) FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T1.name != 'Brown'
Database: small_bank_1 (tables: accounts)
Question: How many accounts are there in total?
SQL: SELECT count(*) FROM accounts
Database: small_bank_1 (tables: accounts)
Question: Count the number of accounts.
SQL: SELECT count(*) FROM accounts
Database: small_bank_1 (tables: checking)
Question: What is the total checking balance in all accounts?
SQL: SELECT sum(balance) FROM checking
Database: small_bank_1 (tables: checking)
Question: Find the total balance across checking accounts.
SQL: SELECT sum(balance) FROM checking
Database: small_bank_1 (tables: checking)
Question: Find the average checking balance.
SQL: SELECT avg(balance) FROM checking
Database: small_bank_1 (tables: checking)
Question: What is the average balance in checking accounts?
SQL: SELECT avg(balance) FROM checking
Database: small_bank_1 (tables: savings)
Question: How many accounts have a savings balance above the average savings balance?
SQL: SELECT count(*) FROM savings WHERE balance  >  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: savings)
Question: Find the number of accounts with a savings balance that is higher than the average savings balance.
SQL: SELECT count(*) FROM savings WHERE balance  >  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: checking, accounts)
Question: Find the name and id of accounts whose checking balance is below the maximum checking balance.
SQL: SELECT T1.custid ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT max(balance) FROM checking)
Database: small_bank_1 (tables: checking, accounts)
Question: What are the customer id and name corresponding to accounts with a checking balance less than the largest checking balance?
SQL: SELECT T1.custid ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT max(balance) FROM checking)
Database: small_bank_1 (tables: checking, accounts)
Question: What is the checking balance of the account whose owner’s name contains the substring ‘ee’?
SQL: SELECT T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T1.name LIKE '%ee%'
Database: small_bank_1 (tables: checking, accounts)
Question: Find the balance of the checking account belonging to an owner whose name contains 'ee'.
SQL: SELECT T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T1.name LIKE '%ee%'
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the checking balance and saving balance in the Brown’s account.
SQL: SELECT T2.balance ,  T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T1.name  =  'Brown'
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the checking and savings balances in accounts belonging to Brown?
SQL: SELECT T2.balance ,  T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T1.name  =  'Brown'
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the names of accounts whose checking balance is above the average checking balance, but savings balance is below the average savings balance.
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  >  (SELECT avg(balance) FROM checking) INTERSECT SELECT T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names of accounts with checking balances greater than the average checking balance and savings balances below the average savings balance?
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  >  (SELECT avg(balance) FROM checking) INTERSECT SELECT T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the checking balance of the accounts whose savings balance is higher than the average savings balance.
SQL: SELECT T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T1.name IN (SELECT T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  >  (SELECT avg(balance) FROM savings))
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the balances of checking accounts belonging to people with savings balances greater than the average savings balance?
SQL: SELECT T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T1.name IN (SELECT T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  >  (SELECT avg(balance) FROM savings))
Database: small_bank_1 (tables: accounts)
Question: List all customers’ names in the alphabetical order.
SQL: SELECT name FROM accounts ORDER BY name
Database: small_bank_1 (tables: accounts)
Question: What are the names of all the customers in alphabetical order?
SQL: SELECT name FROM accounts ORDER BY name
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name of account that has the lowest total checking and saving balance.
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance + T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What is the name corresponding to the accoung with the lowest sum of checking and savings balances?
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance + T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the names and total checking and savings balances of accounts whose savings balance is higher than the average savings balance.
SQL: SELECT T1.name ,  T2.balance + T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T3.balance  >  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names and sum of checking and savings balances for accounts with savings balances higher than the average savings balance?
SQL: SELECT T1.name ,  T2.balance + T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T3.balance  >  (SELECT avg(balance) FROM savings)
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name and checking balance of the account with the lowest savings balance.
SQL: SELECT T1.name ,  T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names and balances of checking accounts belonging to the customer with the lowest savings balance?
SQL: SELECT T1.name ,  T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, accounts)
Question: Find the number of checking accounts for each account name.
SQL: SELECT count(*) ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
Database: small_bank_1 (tables: checking, accounts)
Question: What are the names of customers with accounts, and how many checking accounts do each of them have?
SQL: SELECT count(*) ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
Database: small_bank_1 (tables: savings, accounts)
Question: Find the total saving balance for each account name.
SQL: SELECT sum(T2.balance) ,  T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
Database: small_bank_1 (tables: savings, accounts)
Question: What are the names of customers with accounts, and what are the total savings balances for each?
SQL: SELECT sum(T2.balance) ,  T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
Database: small_bank_1 (tables: checking, accounts)
Question: Find the name of accounts whose checking balance is below the average checking balance.
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT avg(balance) FROM checking)
Database: small_bank_1 (tables: checking, accounts)
Question: What are the names of customers with checking balances lower than the average checking balance?
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT avg(balance) FROM checking)
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the saving balance of the account with the highest checking balance.
SQL: SELECT T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance DESC LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What is the savings balance of the account belonging to the customer with the highest checking balance?
SQL: SELECT T3.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance DESC LIMIT 1
Database: small_bank_1 (tables: checking, savings)
Question: Find the total checking and saving balance of all accounts sorted by the total balance in ascending order.
SQL: SELECT T1.balance + T2.balance FROM checking AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid ORDER BY T1.balance + T2.balance
Database: small_bank_1 (tables: checking, savings)
Question: What is the sum of checking and savings balances for all customers, ordered by the total balance?
SQL: SELECT T1.balance + T2.balance FROM checking AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid ORDER BY T1.balance + T2.balance
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name and checking balance of the account with the lowest saving balance.
SQL: SELECT T2.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What is the name and checking balance of the account which has the lowest savings balance?
SQL: SELECT T2.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T3.balance LIMIT 1
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name, checking balance and saving balance of all accounts in the bank.
SQL: SELECT T2.balance ,  T3.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names, checking balances, and savings balances for all customers?
SQL: SELECT T2.balance ,  T3.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name, checking balance and savings balance of all accounts in the bank sorted by their total checking and savings balance in descending order.
SQL: SELECT T2.balance ,  T3.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance + T3.balance DESC
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names, checking balances, and savings balances of customers, ordered by the total of checking and savings balances descending?
SQL: SELECT T2.balance ,  T3.balance ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid ORDER BY T2.balance + T3.balance DESC
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name of accounts whose checking balance is higher than corresponding saving balance.
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T2.balance  >  T3.balance
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names of customers with a higher checking balance than savings balance?
SQL: SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T2.balance  >  T3.balance
Database: small_bank_1 (tables: checking, savings, accounts)
Question: Find the name and total checking and savings balance of the accounts whose savings balance is lower than corresponding checking balance.
SQL: SELECT T1.name ,  T3.balance + T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T3.balance  <  T2.balance
Database: small_bank_1 (tables: checking, savings, accounts)
Question: What are the names of customers who have a savings balance lower than their checking balance, and what is the total of their checking and savings balances?
SQL: SELECT T1.name ,  T3.balance + T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid JOIN savings AS T3 ON T1.custid  =  T3.custid WHERE T3.balance  <  T2.balance
Database: small_bank_1 (tables: savings, accounts)
Question: Find the name and savings balance of the top 3 accounts with the highest saving balance sorted by savings balance in descending order.
SQL: SELECT T1.name ,  T2.balance FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid ORDER BY T2.balance DESC LIMIT 3
Database: small_bank_1 (tables: savings, accounts)
Question: What are names and savings balances of the three accounts with the highest savings balances?
SQL: SELECT T1.name ,  T2.balance FROM accounts AS T1 JOIN savings AS T2 ON T1.custid  =  T2.custid ORDER BY T2.balance DESC LIMIT 3
Database: browser_web (tables: browser)
Question: How many main stream browsers whose market share is at least 5 exist?
SQL: SELECT count(*) FROM browser WHERE market_share  >=  5
Database: browser_web (tables: browser)
Question: List the name of browsers in descending order by market share.
SQL: SELECT name FROM browser ORDER BY market_share DESC
Database: browser_web (tables: browser)
Question: List the ids, names and market shares of all browsers.
SQL: SELECT id ,  name ,  market_share FROM browser
Database: browser_web (tables: browser)
Question: What is the maximum, minimum and average market share of the listed browsers?
SQL: SELECT max(market_share) ,  min(market_share) ,  avg(market_share) FROM browser
Database: browser_web (tables: browser)
Question: What is the id and market share of the browser Safari?
SQL: SELECT id ,  market_share FROM browser WHERE name  =  'Safari'
Database: browser_web (tables: web_client_accelerator)
Question: What are the name and os of web client accelerators that do not work with only a 'Broadband' type connection?
SQL: SELECT name ,  operating_system FROM web_client_accelerator WHERE CONNECTION != 'Broadband'
Database: browser_web (tables: browser, accelerator_compatible_browser, web_client_accelerator)
Question: What is the name of the browser that became compatible with the accelerator 'CProxy' after year 1998 ?
SQL: SELECT T1.name FROM browser AS T1 JOIN accelerator_compatible_browser AS T2 ON T1.id  =  T2.browser_id JOIN web_client_accelerator AS T3 ON T2.accelerator_id  =  T3.id WHERE T3.name  =  'CProxy' AND T2.compatible_since_year  >  1998
Database: browser_web (tables: accelerator_compatible_browser, web_client_accelerator)
Question: What are the ids and names of the web accelerators that are compatible with two or more browsers?
SQL: SELECT T1.id ,  T1.Name FROM web_client_accelerator AS T1 JOIN accelerator_compatible_browser AS T2 ON T2.accelerator_id  =  T1.id GROUP BY T1.id HAVING count(*)  >=  2
Database: browser_web (tables: browser, accelerator_compatible_browser)
Question: What is the id and name of the browser that is compatible with the most web accelerators?
SQL: SELECT T1.id ,  T1.name FROM browser AS T1 JOIN accelerator_compatible_browser AS T2 ON T1.id  =  T2.browser_id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1
Database: browser_web (tables: browser, accelerator_compatible_browser, web_client_accelerator)
Question: When did the web accelerator 'CACHEbox' and browser 'Internet Explorer' become compatible?
SQL: SELECT T1.compatible_since_year FROM accelerator_compatible_browser AS T1 JOIN browser AS T2 ON T1.browser_id  =  T2.id JOIN web_client_accelerator AS T3 ON T1.accelerator_id  =  T3.id WHERE T3.name  =  'CACHEbox' AND T2.name  =  'Internet Explorer'
Database: browser_web (tables: web_client_accelerator)
Question: How many different kinds of clients are supported by the web clients accelerators?
SQL: SELECT count(DISTINCT client) FROM web_client_accelerator
Database: browser_web (tables: accelerator_compatible_browser, web_client_accelerator)
Question: How many accelerators are not compatible with the browsers listed ?
SQL: SELECT count(*) FROM web_client_accelerator WHERE id NOT IN ( SELECT accelerator_id FROM accelerator_compatible_browser );
Database: browser_web (tables: browser, accelerator_compatible_browser, web_client_accelerator)
Question: What distinct accelerator names are compatible with the browswers that have market share higher than 15?
SQL: SELECT DISTINCT T1.name FROM web_client_accelerator AS T1 JOIN accelerator_compatible_browser AS T2 ON T2.accelerator_id  =  T1.id JOIN browser AS T3 ON T2.browser_id  =  T3.id WHERE T3.market_share  >  15;