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 are compatible with some accelerator(s)?
assistant
SELECT name FROM browser WHERE id IN ( SELECT browser_id FROM accelerator_compatible_browser );
human
Which is compatible with the most?
assistant
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 ;