Course Content
Intermediate SQL
Intermediate SQL
Get Category By Product Price
Great, we have obtained the quantity of products in each category. Now we need to retrieve the categories where the products cost more than a certain amount of money.
Just a reminder that we are working with two tables.
product:
category:
And now, let's move to the task:
Swipe to show code editor
Your task is to retrieve the unique category names that have products with a price higher than 450. Use the WHERE clause for this, where you compare 450 with the value of the price column.
Note
Please note that there should be only one column in the output -
category.name. You do not include thepricecolumn in theSELECTsection; you only use it in theWHEREsection.
Good luck!
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Get Category By Product Price
Great, we have obtained the quantity of products in each category. Now we need to retrieve the categories where the products cost more than a certain amount of money.
Just a reminder that we are working with two tables.
product:
category:
And now, let's move to the task:
Swipe to show code editor
Your task is to retrieve the unique category names that have products with a price higher than 450. Use the WHERE clause for this, where you compare 450 with the value of the price column.
Note
Please note that there should be only one column in the output -
category.name. You do not include thepricecolumn in theSELECTsection; you only use it in theWHEREsection.
Good luck!
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Switch to desktop for real-world practiceContinue from where you are using one of the options below