Question: please provise sql codes for 1-6. thanks Submit the sal file only. Use comments to label the queries with the number of the exercise. Include

 please provise sql codes for 1-6. thanks Submit the sal file
please provise sql codes for 1-6. thanks

Submit the sal 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 CatalogPage is null 6. Write a SQL query to display all columns from catalog_sku 2015 table where the Catalog Page is not null

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!