Task - Using SELECT
The store owner wants to retrieve a list of all the products that are under 100
in terms of quantity so that they can order more stock in advance.
Your task is to retrieve and display all the products from the store
table where the quantity is less than 100. You have to retrieve all the columns from the selected products. You need to display each row in the following format:
{id}, {name}, {category}, {price}, {quantity}
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.22
Task - Using SELECT
Swipe to show menu
The store owner wants to retrieve a list of all the products that are under 100
in terms of quantity so that they can order more stock in advance.
Your task is to retrieve and display all the products from the store
table where the quantity is less than 100. You have to retrieve all the columns from the selected products. You need to display each row in the following format:
{id}, {name}, {category}, {price}, {quantity}
Thanks for your feedback!