Introduction
2. The StockChange table
ROWS
RANGE
Default window frame
Summary

Instruction

Okay, let's look at another table.

Exercise

Select all the information from the StockChange table.

A single row in StockChange means that a given number of products either left the warehouse or were delivered to the warehouse.

Each row has:

  • the Id of the change,
  • the ProductId,
  • the Quantity (a positive value means a delivery, a negative value means shipment out),
  • the ChangedDate – when it happened.