human
Schema:
Web_client_accelerator (id, name, Operating_system, Client, Connection)
browser (id, name, market_share)
accelerator_compatible_browser (accelerator_id, browser_id, compatible_since_year)
Please answer with SQL.
assistant
Sure, I understand.
human
What distinct accelerator names are compatible with the browswers that have market share higher than 15?
assistant
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;
human
What is the id and market share of the browser Safari?
assistant
SELECT id , market_share FROM browser WHERE name = 'Safari'
human
List the ids, names and market shares of all browsers.
assistant
SELECT id , name , market_share FROM browser
human
List the name of browsers in descending order by market share.
assistant
SELECT name FROM browser ORDER BY market_share DESC
human
What is the maximum, minimum and average market share of the listed browsers?
assistant
SELECT max(market_share) , min(market_share) , avg(market_share) FROM browser
human
How many main stream browsers whose market share is at least 5 exist?
assistant
SELECT COUNT( * ) FROM browser WHERE market_share >= 5 ;