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 is the Id of the browser that is compatible with most web accelerators?
assistant
SELECT T1.id 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;
human
What is the name of browser with id 1?
assistant
SELECT name FROM browser WHERE id = 1;
human
What is the name of the browser with the second largest market share?
assistant
SELECT name FROM browser ORDER by market_share LIMIT 2 ;