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' )