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 Firefox.
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.name = 'Firefox';
human
What distinct accelerator names are compatible with the browsers that have a 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 distinct accelerator names have been compatible since at least 1996.
assistant
SELECT DISTINCT T2.name FROM accelerator_compatible_browser AS T1 JOIN Web_client_accelerator AS T2 ON T1.accelerator_id = T2.id WHERE compatible_since_year > = 1996 ;