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
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
Get step-by-step solutions from verified subject matter experts
