Introduction
Quick refresher
PARTITION BY ORDER BY with ranking
PARTITION BY ORDER BY with window frames
PARTITION BY ORDER BY with analytical functions
Summary
22. Exercise 1

Instruction

Ok, let's get started.

Exercise

For each day, show the following two columns: day and the name of the second most frequently repaired phone on that day. Only take into account free_repairs.