SQL语句应当如何使用内嵌视图与临时表

CREATE TABLE #Temp1 (OrderID INT NOT NULL, _ 
                    
OrderDate DATETIME NOT NULL)INSERT INTO #Temp1 (OrderID, OrderDate)SELECT
     
TOP 5 o.OrderID, o.OrderDateFROM Orders o ORDER BY o.OrderDate DESCSELECT 

p.ProductName, SUM(od.Quantity) AS ProductQuantityFROM     #Temp1 t 
    
INNER JOIN [Order Details] od ON t.OrderID = od.OrderID  
  
INNER JOIN Products p ON od.ProductID = p.ProductID 
GROUP BY p.ProductNameORDER BY p.ProductNameDROP TABLE #Temp1

SELECT p.ProductName,     
SUM(od.Quantity) AS ProductQuantityFROM
     
(SELECT TOP 5 o.OrderID, o.OrderDate 
   
FROM     Orders o     ORDER BY o.OrderDate DESC    ) t 
    
INNER JOIN [Order Details] od ON t.OrderID = od.OrderID 
   
INNER JOIN Products p ON od.ProductID = p.ProductID GROUP BY 
   
p.ProductNameORDER BY    p.ProductName