View difference between Paste ID: udN4Ea8y and ghBHQ02u

-CREATE PROC usp_FindTotalIncome (@start_date int,  @end_date int, @company_name nvarchar(50))
+CREATE PROC usp_FindTotalIncome (@start_date int,  @end_date int, @company_name nvarchar(50))
-AS
+AS
-SELECT SUM(od.Quantity*od.UnitPrice) as TotalIncome
+SELECT SUM(od.Quantity*od.UnitPrice) as TotalIncome
-FROM Suppliers s
+FROM Suppliers s
-INNER join Products p
+INNER join Products p
-on p.SupplierID = p.SupplierID
+on s.SupplierID = p.SupplierID
-inner JOIN [Order Details] od
+inner JOIN [Order Details] od
-on od.ProductID = p.ProductID
+on od.ProductID = p.ProductID
-inner join Orders o
+inner join Orders o
-on od.OrderID = o.OrderID
+on od.OrderID = o.OrderID
-WHERE s.CompanyName = @company_name and (YEAR(o.OrderDate) = @start_date AND YEAR(o.ShippedDate) <= @end_date);
+WHERE s.CompanyName = @company_name and (YEAR(o.OrderDate) >= @start_date AND YEAR(o.OrderDate) <= @end_date);
 GO