100 Days of SQL


Day 89 – Views

CREATE VIEW vwProductSales
SELECT Products.ProductName, SUM(OrderDetails.Quantity) AS TotalSales
FROM Products
INNER JOIN OrderDetails ON Products.ProductID = OrderDetails.ProductID
GROUP BY Products.ProductName
HAVING SUM(OrderDetails.Quantity) > 1000

SELECT * FROM vwProductSales

In this example, a view named vwProductSales is created to retrieve the total sales for each product and filter the results to only include products with total sales greater than 1000. The view is then queried using a standard SELECT statement.