Remove Rows with DELETE in C#

DELETE FROM removes rows from a table. It always removes whole rows: to change one value in a row that stays, you use UPDATE instead.

WHERE picks the rows to remove, just like in a SELECT. For example, this removes the products that cost more than 40, which is only the gift card:

DELETE FROM products
WHERE price > 40;

Without a WHERE, DELETE removes every row: the table is still there, but it is empty. A safe habit: before a DELETE, run a SELECT with the same WHERE to see which rows will go. The rows that stay keep their ids.

The check runs your statement, then prints the id, name and stock of every product left. It must print:

id | name | stock
1 | Mug | 10
3 | Lamp | 1
4 | Pen | 120
5 | Plant | 6
6 | Teapot | 4
7 | Stapler | 15
8 | Gift card | 999
(7 rows)

Your task: in query, remove the products that have no stock: the rows whose stock is 0. Every other product stays.

Assignment
Follow the Coding Tutorial to write the DELETE statement in query, one clause per line.

Hint
The WHERE compares the stock column with the number 0 using =; numbers need no quotes. The first line of query is a C# string that ends with a space and a +; the last line ends with the C# ;.