Question

Which delete statement would remove only the records that have a bit flag "is_removed" set to true and a date "removed_on" that is older than 30 days?

Question options:

	delete from games where is_removed = 1 or datediff(day, removed_on, getdate()) < 30;
	delete from games where is_removed = 1 and datediff(day, removed_on, getdate()) > 30;
	delete from games where is_removed = 1 and datediff(day, removed_on, getdate()) = 30;
	delete from games where is_removed = 1 or datediff(day, removed_on, getdate()) > 30;

Answer 1