### Database Schema:
CREATE TABLE location (
	id_restaurant	INTEGER	NOT NULL	PRIMARY KEY,
	street_num	INTEGER	NULL,
	street_name	TEXT	NULL,
	city	TEXT	NULL,
	foreign key (city) references geographic (city),
	foreign key (id_restaurant) references generalinfo (id_restaurant)
);

CREATE TABLE geographic (
	city	TEXT	NOT NULL	PRIMARY KEY,
	county	TEXT	NULL,
	region	TEXT	NULL
);

CREATE TABLE generalinfo (
	id_restaurant	INTEGER	NOT NULL	PRIMARY KEY,
	label	TEXT	NULL,
	food_type	TEXT	NULL,
	city	TEXT	NULL,
	review	REAL	NULL,
	foreign key (city) references geographic (city)
);

### User's Query:
How many restaurants in the city of Richmond serve Mediterranean food?

### Extra Knowledge:
Mediterranean food refers to food_type =   'mediterranean'
SELECT COUNT(id_restaurant) FROM generalinfo WHERE food_type = 'mediterranean' AND city = 'richmond'