### Database Schema:
CREATE TABLE location (
	locationID	INTEGER	NULL	PRIMARY KEY,
	locationcity	TEXT	NULL,
	address	TEXT	NULL,
	state	TEXT	NULL,
	zipcode	INTEGER	NULL,
	officephone	TEXT	NULL
);

CREATE TABLE employee (
	ssn	TEXT	NULL	PRIMARY KEY,
	lastname	TEXT	NULL,
	firstname	TEXT	NULL,
	hiredate	TEXT	NULL,
	salary	TEXT	NULL,
	gender	TEXT	NULL,
	performance	TEXT	NULL,
	positionID	INTEGER	NULL,
	locationID	INTEGER	NULL,
	foreign key (positionID) references position (positionID),
	foreign key (locationID) references location (locationID)
);

CREATE TABLE position (
	positionID	INTEGER	NULL	PRIMARY KEY,
	positiontitle	TEXT	NULL,
	educationrequired	TEXT	NULL,
	minsalary	TEXT	NULL,
	maxsalary	TEXT	NULL
);

### User's Query:
How many "account representatives" are there in Chicago with a good performance?

### Extra Knowledge:
account representatives is a position title; Chicago refers to locationcity = 'Chicago'; good performance refers to performance = 'Good'
SELECT COUNT(*) FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID INNER JOIN position AS T3  ON T3.positionID = T1.positionID WHERE T3.positiontitle = 'Account Representative' AND T2.locationcity = 'Chicago' AND T1.performance = 'Good'