Question

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 Product 10 column from every row in table. c) Write a SELECT statement that will return the Product to column and the QtyonHand column from every row in table. d) Write a SELECT statement that will return the Product 10 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 Product 10 ends with \(^{*} Z Z^{*}\)

Short answer

Question: Write different SQL SELECT statements for the Inventory table based on the following scenarios: a) Select all columns and rows. b) Select only the Product10 column. c) Select both the Product10 and QtyonHand columns. d) Select the Product10 column only for rows where the cost is less than 17.00. e) Select all columns for rows where the value in the Product10 column ends with the letter 'Z'.

Step-by-step solution

a) Select All Columns and Rows

To select all columns and rows in the Inventory table, we use the asterisk symbol (*) and the SELECT statement as follows: ```sql SELECT * FROM Inventory; ```

b) Select the Product10 Column

To select the Product10 column from every row in the table, we specify this column in the SELECT statement: ```sql SELECT Product10 FROM Inventory; ```

c) Select the Product10 and QtyonHand Columns

To select the Product10 and QtyonHand columns from every row in the table, we list both columns separated by commas in the SELECT statement: ```sql SELECT Product10, QtyonHand FROM Inventory; ```

d) Select the Product10 Column with a Condition

To select the Product10 column only for rows where the cost is less than 17.00, we use a WHERE clause in the SELECT statement to apply the given condition: ```sql SELECT Product10 FROM Inventory WHERE cost < 17.00; ```

e) Select All Columns with a Condition

To select all columns for rows where the Product10 value ends with 'Z', we use the LIKE keyword along with a WHERE clause to apply the given condition. The '%' character is used as a wildcard to match any sequence of characters: ```sql SELECT * FROM Inventory WHERE Product10 LIKE '%\(^*Z^*Z\)^*%'; ```