Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Introduction
Quick refresher
PARTITION BY ORDER BY with ranking
PARTITION BY ORDER BY with window frames
PARTITION BY ORDER BY with analytical functions
Summary
24. Exercise 3

Instruction

Fine! And finally, the last question.

Exercise

For each phone, show the following information: phone, day, the number of paid repairs, the number of paid repairs on the previous day and the difference between these two values.