Assume that a database has a table named Inventory, with the following columns:
Column Name | Type |
Product ID | CHAR(10) |
QtyOnHand | INT |
Cost | DOUBLE |
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 Costis less than 17.00.
e. Write a SELECT statement that will return all of the columns from the rows where ProductID ends with “ZZ.”
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.