To 🔥 celebrate the holiday season, Also check out our NEWLY launched Annual plan (Up to 50% off). Use coupon code THANKSGIVING15 and enjoy additional 15% off all paid plans. Coupon expires at 2020/11/30 .
1. Top store for movie sales easy

Instruction

Write a query to return the name of the store and its manager, that has the most sales.

Table: sales_by_store

Movie sales by store

  col_name   | col_type
-------------+----------
 store       | text
 manager     | text
 total_sales | numeric

  

Sample results

   store   |   manager
-----------+--------------
 Woodridge | Jon Stephens