Introduction
Quick Refresher
PARTITION BY ORDER BY with Ranking
PARTITION BY ORDER BY with Window Frames
Using PARTITION BY ORDER BY with Analytical Functions
Summary and Review
21. Exercise 1

Instruction

Ok, let's get started.

Exercise

For each day, show the Day and the name of the second most frequently repaired phone on that day. Only take into account FreeRepairs.