What are the most popular restaurants in San Francisco among diners?
the most popular refers to max(review); restaurant refers to label; San Francisco refers to city = 'San Francisco'
SELECT id_restaurant, label FROM generalinfo WHERE city = 'San Francisco' AND review = ( SELECT MAX(review) FROM generalinfo WHERE city = 'San Francisco' )
database name:db_id restaurant
geographic table geographic Cols: city dtype text, country dtype text, region dtype text, 
generalinfo table generalinfo Cols: id restaurant dtype integer, label dtype text, food type dtype text, city dtype text, review dtype real, 
location table location Cols: id restaurant dtype integer, street number dtype integer, street name dtype text, city dtype text, 
