Scenario: In a database with a Products table containing columns ProductID, ProductName, and StockQuantity, which SQL query would create a view named LowStockProducts to retrieve products with a stock quantity less than $20?$

Context:

Products Table Columns:

ProductID

ProductName

StockQuantity

A

CREATE VIEW LowStockProducts AS

SELECT ProductID, ProductName, StockQuantity

FROM Products

WHERE StockQuantity $<20$;

B

CREATE VIEW LowStockProducts AS

SELECT $*$

FROM Products

WHERE StockQuantity $<20$;

C

CREATE VIEW LowStockProducts $($ProductID$,$ ProductName, StockQuantity$)$ AS

SELECT $*$

FROM Products

WHERE StockQuantity $<20$;

D

CREATE VIEW LowStockProducts AS

SELECT ProductID, ProductName, StockQuantity

FROM Products

GROUP BY StockQuantity

HAVING StockQuantity $<20$;