Question: Submit the.sql file only. Use comments to label the queries with the number of the exercise. Include USE statements or fully qualified names to guarantee

Submit the.sql file only. Use comments to label the queries with the number of the exercise. Include USE statements or fully qualified names to guarantee the correct database is being accessed. Use the cape_codd database for questions 1-6. 1. Write a SQL query that displays the SKU and SKU_Description columns from the inventory table with SKU_Description containing the string "mask". Remove all duplicate rows. Use LIKE. 2. Write a SQL query that displays the SKU and SKU_Description columns from the inventory table with SKU_Description containing the string "mask". Remove all duplicate rows. Use REGEXP. 3. Write a SQL query to display all columns from the warehouse table with the second letter in the Manager's first name is "a". Use LIKE. 4. Write a SQL query to display all columns from the warehouse table with the second letter in the Manager's first name is "a". Use REGEXP. 5. Write a SQL query to display all columns from catalog_sku_2015 table where the Catalog Page is null. 6. Write a SQL query to display all columns from catalog_sku_2015 table where the Catalog Page is not null. Use the vrg database for question 7. 7. Write a SQL query to display the LastName, FirstName, and EmailAddress columns from the customer table. If the EmailAddress column is NULL, replace the NULL value with 'No email available' or a similar message
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
