Introduction
Quick refresher
PARTITION BY ORDER BY with ranking
PARTITION BY ORDER BY with window frames
PARTITION BY ORDER BY with analytical functions
Revision
23. Exercise 2

Instruction

Very good, let's move on.

Exercise

For each phone, show the following information: phone, day, revenue and the revenue for the first repair for each phone (column name first_revenue)

Console

Code editor

Result

TableConsole