Question

The sale on decaf coffee didn't do too well, so the Midnight Coffee Roastery has decided to stop selling decaf. Write an SQL statement that will delete all decaf coffees from the coffee table.

Short answer

Question: Write an SQL statement that deletes all decaf coffees from a coffee table. Answer: `DELETE FROM coffee WHERE coffee_type = 'decaf';`

Step-by-step solution

Identify the SQL DELETE Statement

To delete specific rows from a table in SQL, the DELETE command with the FROM clause is used. This command is followed by the table name, and then a WHERE clause which specifies the conditions to filter out the target rows to be deleted.

Write the SQL DELETE Statement to Delete Decaf Coffees

Since we want to delete all decaf coffees from the coffee table, we have to set a condition for the 'coffee_type' column to be equal to 'decaf'. To achieve this, we will use the SQL DELETE command as follows: ``` DELETE FROM coffee WHERE coffee_type = 'decaf'; ``` This SQL statement will delete all rows in the coffee table where the value of 'coffee_type' is 'decaf'.