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 accelerator ids are not compatible with Opera?
assistant
SELECT id FROM web_client_accelerator WHERE id NOT IN ( SELECT t1.accelerator_id FROM accelerator_compatible_browser AS t1 JOIN browser AS t2 ON t1.browser_id = t2.id WHERE t2.name = 'Opera' );
human
For these, show the names and supporting operating systems.
assistant
SELECT name , operating_system FROM web_client_accelerator EXCEPT SELECT T1.name , T1.operating_system 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 = "Opera" ;