Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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.

If there is more than one repair on that day consider all of them.