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
Which browsers have market share greater than 15?
assistant
SELECT name FROM browser WHERE market_share > 15;
human
Which of those are compatible with some accelerator?
assistant
SELECT name FROM browser WHERE market_share > 15 AND id IN ( SELECT browser_id FROM accelerator_compatible_browser ) ;