Database schema:

CREATE TABLE "PlayerInfo" (
	"ELITEID" INTEGER, 
	"PlayerName" TEXT, 
	birthdate TEXT, 
	birthyear DATE, 
	birthmonth INTEGER, 
	birthday INTEGER, 
	birthplace TEXT, 
	nation TEXT, 
	height INTEGER, 
	weight INTEGER, 
	position_info TEXT, 
	shoots TEXT, 
	draftyear INTEGER, 
	draftround INTEGER, 
	overall INTEGER, 
	overallby TEXT, 
	"CSS_rank" INTEGER, 
	"sum_7yr_GP" INTEGER, 
	"sum_7yr_TOI" INTEGER, 
	"GP_greater_than_0" TEXT, 
	PRIMARY KEY ("ELITEID"), 
	CONSTRAINT fk_playerinfo_height_info FOREIGN KEY(height) REFERENCES height_info (height_id),
	CONSTRAINT fk_playerinfo_weight_info FOREIGN KEY(weight) REFERENCES weight_info (weight_id)
)


CREATE TABLE "SeasonStatus" (
	"ELITEID" INTEGER -- example: ['3668', '3667'],
	"SEASON" TEXT -- example: ['1999-2000', '1997-1998'],
	"TEAM" TEXT -- example: ['Canada U20', 'Rimouski Oceanic'],
	"LEAGUE" TEXT -- example: ['QMJHL', 'WJC-20'],
	"GAMETYPE" TEXT -- example: ['Regular Season', 'Playoffs'],
	"GP" INTEGER -- example: ['58', '18'],
	"G" INTEGER -- example: ['15', '44'],
	"A" INTEGER -- example: ['71', '26'],
	"P" INTEGER -- example: ['115', '41'],
	"PIM" INTEGER -- example: ['117', '46'],
	"PLUSMINUS" INTEGER -- example: ['4', '27'],
	CONSTRAINT fk_seasonstatus_playerinfo FOREIGN KEY("ELITEID") REFERENCES "PlayerInfo" ("ELITEID")
)


CREATE TABLE height_info (
	height_id INTEGER -- example: ['65', '67'],
	height_in_cm INTEGER -- example: ['170', '165'],
	height_in_inch TEXT -- example: ['5\'5"', '5\'7"'],
	PRIMARY KEY (height_id)
)


CREATE TABLE weight_info (
	weight_id INTEGER -- example: ['159', '154'],
	weight_in_kg INTEGER -- example: ['72', '70'],
	weight_in_lbs INTEGER -- example: ['159', '154'],
	PRIMARY KEY (weight_id)
)

Question: What is the difference in the number of goals scored by Pavel Brendl during the regular season versus the playoffs in the 1998-1999 season?
Evidence: difference = SUBTRACT(SUM(G WHERE GAMETYPE = 'Regular Season'), SUM(G WHERE GAMETYPE = 'Playoffs') WHERE SEASON = '1998-1999'); number of goals scored refers to G; regular season refers to GAMETYPE = 'Regular Season'; playoffs refers to GAMETYPE = 'Playoffs'; 1998-1999 season refers to SEASON = '1998-1999';

SQL:
SELECT T3.Rs_G - T4.Pf_G AS diff FROM ( SELECT T2.PlayerName, T1.G AS Rs_G FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.PlayerName = 'Pavel Brendl' AND T1.SEASON = '1998-1999' AND T1.GAMETYPE = 'Regular Season' ) AS T3 INNER JOIN ( SELECT T2.PlayerName, T1.G AS Pf_G FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.PlayerName = 'Pavel Brendl' AND T1.SEASON = '1998-1999' AND T1.GAMETYPE = 'Playoffs' ) AS T4 ON T3.PlayerName = T4.PlayerName