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:
Task
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 theprice
column in theSELECT
section; you only use it in theWHERE
section.
Good luck!
Thanks 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:
Task
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 theprice
column in theSELECT
section; you only use it in theWHERE
section.
Good luck!
Thanks 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:
Task
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 theprice
column in theSELECT
section; you only use it in theWHERE
section.
Good luck!
Thanks for your feedback!
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:
Task
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 theprice
column in theSELECT
section; you only use it in theWHERE
section.
Good luck!