Menu
School Supply Store

Completed

Incomplete

Not Attended

Share

The School Supply Store provides various stationery items for students and teachers. You manage their inventory.

notAttendedQuestion - 1

List all items in the 'Writing' category.

notAttendedQuestion - 2

Find the total number of items in stock for each category.

notAttendedQuestion - 3

Update the stock of 'Markers' to 90 and display the updated stock.

notAttendedQuestion - 4

Calculate the total value of all items in stock.

notAttendedQuestion - 5

Remove the item 'Pens' from the database

Prev
View Questions
Next
Code Editor
Table Name: supplies
id item_name category price stock
1 Notebooks Stationery 50.00 100
2 Pens Writing 20.00 200
3 Markers Drawing 60.00 75

>>> Submit Your Query to validate