Assume that a database has a table named Inventory, with the following columns: 

a) Write a SELECT statement that will return all of the columns from every row in table.

b) Write a SELECT statement that will return the ProductID column from every row in table.

c) Write a SELECT statement that will return the ProductID column and the QtyOnHand column from every row in table.

d) Write a SELECT statement that will return the ProductID column only from the rows where Cost is less than 17.00.

e) Write a SELECT statement that will return all of the columns from the rows where ProductID ends with “ZZ”.

Transcribed Image Text:

Column Name Product ID QtyOnHand Cost Type CHAR(10) INT DOUBLE