
CREATE TABLE "Web_client_accelerator" (
	id INTEGER, 
	name TEXT, 
	"Operating_system" TEXT, 
	"Client" TEXT, 
	"Connection" TEXT, 
	PRIMARY KEY (id)
)


CREATE TABLE accelerator_compatible_browser (
	accelerator_id INTEGER, 
	browser_id INTEGER, 
	compatible_since_year INTEGER, 
	PRIMARY KEY (accelerator_id, browser_id), 
	FOREIGN KEY(browser_id) REFERENCES browser (id), 
	FOREIGN KEY(accelerator_id) REFERENCES "Web_client_accelerator" (id)
)


CREATE TABLE browser (
	id INTEGER, 
	name TEXT, 
	market_share REAL, 
	PRIMARY KEY (id)
)

CREATE TABLE "Web_client_accelerator" (
	id INTEGER, 
	name TEXT, 
	"Operating_system" TEXT, 
	"Client" TEXT, 
	"Connection" TEXT, 
	PRIMARY KEY (id)
)

/*
2 rows from Web_client_accelerator table:
id	name	Operating_system	Client	Connection
1	CACHEbox	Appliance (Linux)	End user, ISP	Broadband, Satellite, Wireless, Fiber, DSL
2	CProxy	Windows	user	up to 756kbit/s
*/


CREATE TABLE accelerator_compatible_browser (
	accelerator_id INTEGER, 
	browser_id INTEGER, 
	compatible_since_year INTEGER, 
	PRIMARY KEY (accelerator_id, browser_id), 
	FOREIGN KEY(browser_id) REFERENCES browser (id), 
	FOREIGN KEY(accelerator_id) REFERENCES "Web_client_accelerator" (id)
)

/*
2 rows from accelerator_compatible_browser table:
accelerator_id	browser_id	compatible_since_year
1	1	1995
1	2	1996
*/


CREATE TABLE browser (
	id INTEGER, 
	name TEXT, 
	market_share REAL, 
	PRIMARY KEY (id)
)

/*
2 rows from browser table:
id	name	market_share
1	Internet Explorer	28.96
2	Firefox	18.11
*/
How many accelerators are not compatible with the browsers listed ?
SELECT count(*) FROM web_client_accelerator WHERE id NOT IN ( SELECT accelerator_id FROM accelerator_compatible_browser );
[{'count(*)': 14}]