Supermarket Q2

A supermarket has a SQL database which stores information about products and the stock they hold, and in which location.

The schema for the supermarket’s database is shown below.

Schema

Product(ProductID, Name, PricePence)

Stock(StockID, Location)

ProductStock(ProductID, StockID, Quantity)

Question

ProductStock contains several records where the quantity is 0

Write a query to delete these records