Get products by category for NorthWind2020

NorthWind2020ProductsByCategory.sql

DECLARE @CategoryID INT= 2;
SELECT P.ProductID, 
       P.ProductName, 
       P.UnitPrice, 
       P.UnitsInStock, 
       P.SupplierID, 
       S.CompanyName AS SupplierName, 
       C.[Name] AS SupplierCountry
FROM Products AS P
     INNER JOIN Suppliers AS S ON P.SupplierID = S.SupplierID
     INNER JOIN Countries AS C ON S.CountryIdentifier = C.CountryIdentifier
WHERE P.CategoryID = @CategoryID;