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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!