1. A database table called SoftDrinks stores details of the soft drinks sold by a small shop.

Complete the structured query language (SQL) statement to return the number of cans the shop has in stock.

SELECT ..................(..............)

FROM ................

WHERE ......................... =...........................;