Question: a,b,c,d 2. Use the INVENTORY table to write SQL statements for the following queries. Make sure to include the screen capture of the SQL output

 a,b,c,d 2. Use the INVENTORY table to write SQL statements for

a,b,c,d

2. Use the INVENTORY table to write SQL statements for the following queries. Make sure to include the screen capture of the SQL output that you get after executing each of the query. a) Display unique SKU, SKU_Description for all products having a description starting with Half-Dome'. (4 points) Display unique SKU, SKU_Description for all products having a description containing the word Climb. (4 points) c) Display unique SKU, SKU_Description for all products having a 'd' in the third position from the left in the SKU_Description. (5 points) d) Write an SQL statement that uses all of the SQL built-in functions (COUNT, SUM, AVG, (5 points)

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!