Question: Complete the two blanks in the following SQL query to retrieve the productID , productName and salePrice of products that belong to the categories pants

Complete the two blanks in the following SQL query to retrieve the productID, productName and salePrice of products that belong to the categories pants or shirts. The salePrice of each product is not stored as an attribute, but is instead calculated by adding 10 percent to the preTaxPrice. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces.

Complete the two blanks in the following SQL query to retrieve the

SELECT productID, productName, FROM Products WHERE category = 'Pants' AS salePrice category = 'Shirts

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!