SQL Crash course, and Resources

Some useful functions

ROWS BETWEEN lower_bound AND upper_bound

The bounds can be any of these five options:

• UNBOUNDED PRECEDING – All rows before the current row.

• n PRECEDING – n rows before the current row.

• CURRENT ROW – Just the current row.

• n FOLLOWING – n rows after the current row.

• UNBOUNDED FOLLOWING – All rows after the current row.

SELECT 

 Product,  D…