as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
create a sql query to find the 5 most popular restaurants in a given city.
user
select restaurant_name, count(*) as frequency 
from restaurant_table 
where city = '<given city name>' 
group by restaurant_name 
order by frequency desc 
limit 5;
assistant