1. Learn
  2. /
  3. Courses
  4. /
  5. Analyzing Business Data in SQL

Connected

Exercise

Executive report

Eve wants to produce a final executive report about the rankings of eateries by the number of unique users who order from them by quarter. She said she'll handle the pivoting, so you only need to prepare the source table for her to pivot.

Send Eve a table of unique ordering users by eatery and by quarter.

Instructions 1/3

undefined XP
    1
    2
    3
  • Fill in the format string that formats 2018-06-01 as Q2 2018.
  • Count the ordering users by eatery and by quarter.