DELETE with an IN Subquery — Exercise

Create a DELETE statement using a subquery

Objective: Practice creating a DELETE statement using a subquery.

Exercise scoring

This is a 5-point self-assessment. Compare your SQL with the model answer and rubric after submitting. The website does not execute SQL or automatically grade your response.

Instructions

Practice environment: Write SQL for the sample tables in the dbo schema. Submitting displays your text and a model answer; it does not run database commands. If you test independently, use a disposable practice database.

Assume Tasks.TaskID is a primary key, Timesheets.TaskID references it, WeekEndingDate has the date type, and Hours is numeric. The five displayed timesheet rows form the complete sample. For the UPDATE exercise, the listed employee/task/date combination identifies one row.

To test your understanding of the relationship between subqueries and joins, use the same instructions as the prior exercise, but construct a subquery instead of selecting values from another table. To review the instructions, use the course project as an example. Remember the Timesheets table looks like this:

EmployeeID	ClientID	TaskID	WeekEndingDate	Hours
1	17	101	2026-06-01	30
1	17	102	2026-06-08	50
2	3	101	2026-06-15	40
3	32	103	2026-06-01	45
3	32	103	2026-06-08	35

The Tasks table looks like this:

TaskID	Description	Chargeable
101	Vacation	0
102	General	1
103	Programming	1

The task is to delete all timesheet rows for tasks that are not chargeable, as listed in the Tasks table. Construct a DELETE statement that uses a subquery from the Tasks table to retrieve the values to be deleted. Do not use a join.
Hint: Use the IN predicate in the WHERE clause.

Self-assessment rubric
Points	Criterion
2	Select non-chargeable TaskID values from Tasks using Chargeable = 0.
2	Use IN in the outer WHERE clause to match Timesheets.TaskID.
1	Delete from Timesheets only, using a valid complete statement.

Submitting the exercise

Type or paste your Transact-SQL statement into the text box below, then click Submit to submit the answer and view a results page.

Your Transact-SQL statement