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 are the ids and names of the web accelerators that are compatible with two or more browsers?
assistant
SELECT T1.id , T1.Name FROM web_client_accelerator AS T1 JOIN accelerator_compatible_browser AS T2 ON T2.accelerator_id = T1.id GROUP BY T1.id HAVING COUNT( * ) > = 2;
human
how many browser id?
assistant
SELECT COUNT( distinct browser_id ) FROM accelerator_compatible_browser;
human
what are using CProxy in Operating system?
assistant
SELECT operating_system FROM Web_client_accelerator WHERE name = "CProxy" ;