
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
*/
What is the name of the browser that became compatible with the accelerator 'CProxy' after year 1998 ?
SELECT T1.name FROM browser AS T1 JOIN accelerator_compatible_browser AS T2 ON T1.id  =  T2.browser_id JOIN web_client_accelerator AS T3 ON T2.accelerator_id  =  T3.id WHERE T3.name  =  'CProxy' AND T2.compatible_since_year  >  1998
[{'name': 'Opera'}]