Database schema:

CREATE TABLE generalinfo (
	id_restaurant INTEGER NOT NULL -- example: ['2', '1'],
	label TEXT -- example: ['kabul afghan cuisine', "sparky's diner"],
	food_type TEXT -- example: ['afghani', '24 hour diner'],
	city TEXT -- example: ['san francisco', 'san carlos'],
	review REAL -- example: ['2.3', '3.8'],
	PRIMARY KEY (id_restaurant), 
	CONSTRAINT fk_generalinfo_geographic FOREIGN KEY(city) REFERENCES geographic (city)
)


CREATE TABLE geographic (
	city TEXT NOT NULL -- example: ['alamo', 'alameda'],
	county TEXT -- example: ['alameda county', 'contra costa county'],
	region TEXT -- example: ['napa valley', 'bay area'],
	PRIMARY KEY (city)
)


CREATE TABLE location (
	id_restaurant INTEGER NOT NULL -- example: ['2', '1'],
	street_num INTEGER -- example: ['242', '135'],
	street_name TEXT -- example: ['church st', 'el camino real'],
	city TEXT -- example: ['san francisco', 'san carlos'],
	PRIMARY KEY (id_restaurant), 
	CONSTRAINT fk_location_geographic FOREIGN KEY(city) REFERENCES geographic (city),
	CONSTRAINT fk_location_generalinfo FOREIGN KEY(id_restaurant) REFERENCES generalinfo (id_restaurant)
)

Question: Among the restaurants located on the street number ranges from 1000 to 2000, what is the percentage of Afghani restaurants are there?
Evidence: street number ranges from 1000 to 2000 refers to 1000 < = street_num < = 2000; Afghani restaurant refers to food_type = 'afghani'; percentage = divide(count(id_restaurant where food_type = 'afghani'), count(id_restaurant)) * 100%

SQL:
SELECT CAST(SUM(IIF(T2.food_type = 'afghani', 1, 0)) AS REAL) * 100 / COUNT(T1.id_restaurant) FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE 1000 <= T1.street_num <= 2000