Answer:
The query is as follows:
select sum(stock) as total_stock from products
Explanation:
Required
Return total stock using the alias total_stock from the product table.
The explanation of the query is as follows:
select ----> This implies that data is to be selected from the table
sum(stock) ----> This adds up entries in stock column
as total_stock ---> This represents the alias used for sum(stock)column where
from products ----> The table being queried
Take for instance, the content of the table is:
SN Product Stock
1 Apple 5
2 Orange 3
3 Banana 8
The query will return the following table:
total_stock
16
