Write a SELECT statement that returns the product_name and list_price columns from the Products table. Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the product_id columns aren’t equal but the list_price columns are equal. Sort the result set by product_name.
**Please use MySQL Workbench and/or MySQL monitor to help ensure that you are providing correct answers. All of the questions will be referencing the my_guitar_database that was installed earlier in the course.**
| 5. |
Write a SELECT statement that returns the product_name and list_price columns from the Products table.
Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the product_id columns aren’t equal but the list_price columns are equal.
Sort the result set by product_name.
|
| 6. | Write a SELECT statement that returns these two columns:
Return one row for each category that has never been used. Hint: Use an outer join and only return rows where the product_id column contains a null value.
|
| 7. |
Use the UNION operator to generate a result set consisting of three columns from the Orders table:
If the order has a value in the ship_date column, the ship_status column should contain a value of SHIPPED. Otherwise, it should contain a value of NOT SHIPPED.
Sort the final result set by order_date. |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
