Create a SQL Server in memory table variables:
https://odetocode.com/articles/365.aspx

DECLARE @ProductTotals TABLE
(
  ProductID int, 
  Revenue money
)