SQL practice: LAG and LEAD

For each customer, show each order date with their previous order date.

For each customer, show the number of days between each order and the previous one.

For each customer, show each order with the next order date.

Find each customer's most recent order using LEAD being NULL.

For stock transfers, show each transfer with the previous transfer's quantity.

Show monthly order counts with the previous month's count beside each one.

Show monthly order counts and the change from the previous month.

For each employee within their branch, ordered by hire date, show who was hired just before them.

For each order, show the same customer's previous order date (NULL for their first order). First orders show another customer's date instead. Fix it.