Restaurant query (classic)

SQL Coding: Restaurant analytics Assume the database contains tables similar to: restaurants(restaurant_id, name, city, ...) orders(order_id, restaurant_id, user_id, order_time, ...) Write a runnable SQL query for one common restaurant-analysis task—the version you are most comfortable implementing: Return the restaurant or restaurants that received the highest number of orders in each city, with ties included. The result should contain city, restaurant_id, name, order_cnt.…