Contenido del Curso
SQL Intermedio
SQL Intermedio
Obtener Cantidad de Producto por Categoría
Now the company has a new task for us.
A new supplier contacted us and said that they can supply goods from the categories Meat
or Grains
cheaply. We need to find out which products in these categories have less than 100 units left in stock.
Swipe to show code editor
Your task is to find the product names and their quantities
in stock. Join two tables: product
and category
.
Focus on products in the Meat
or Grains
categories. Use the OR
operator for these categories and ensure the product quantity is less than 100 using the AND
operator.
Sort the results by the name
column with the ORDER BY
clause.
Note
Wrap the
OR
condition in parentheses before applying theAND
operator. This follows the standard order of operations in discrete mathematics.
Your result should have 2 columns: product_name
and amount
. Remember to set appropriate aliases!
Brief Instructions
- Retrieve the
product.name
andproduct.amount
columns from theproduct
table. - Assign the alias
product_name
to the first column andamount
to the second. - Join the
category
table on the common columnproduct.category_id = category.id
. - Use a
WHERE
clause requiring thatcategory.name
equals'Meat'
or'Grains'
. - Use the logical operator
AND
to also require thatproduct.amount < 100
. - Sort the results by
product.name
.
Solución
¡Gracias por tus comentarios!
Obtener Cantidad de Producto por Categoría
Now the company has a new task for us.
A new supplier contacted us and said that they can supply goods from the categories Meat
or Grains
cheaply. We need to find out which products in these categories have less than 100 units left in stock.
Swipe to show code editor
Your task is to find the product names and their quantities
in stock. Join two tables: product
and category
.
Focus on products in the Meat
or Grains
categories. Use the OR
operator for these categories and ensure the product quantity is less than 100 using the AND
operator.
Sort the results by the name
column with the ORDER BY
clause.
Note
Wrap the
OR
condition in parentheses before applying theAND
operator. This follows the standard order of operations in discrete mathematics.
Your result should have 2 columns: product_name
and amount
. Remember to set appropriate aliases!
Brief Instructions
- Retrieve the
product.name
andproduct.amount
columns from theproduct
table. - Assign the alias
product_name
to the first column andamount
to the second. - Join the
category
table on the common columnproduct.category_id = category.id
. - Use a
WHERE
clause requiring thatcategory.name
equals'Meat'
or'Grains'
. - Use the logical operator
AND
to also require thatproduct.amount < 100
. - Sort the results by
product.name
.
Solución
¡Gracias por tus comentarios!