Introduction
Quick refresher
PARTITION BY ORDER BY with ranking
PARTITION BY ORDER BY with window frames
PARTITION BY ORDER BY with analytical functions
Revision
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.

Console

Code editor

Result

TableConsole