UPDATE celebs
SET twitter_handle = ‘@taylorswift13’
WHERE id = 4;
SELECT * FROM celebs;
DELETE FROM celebs WHERE twitter_handle IS NULL;
1 Like
Nothing wrong. They just want you to move the delete statement above the select statement so that you can see the result of the delete action
1 Like
sorry but i m getting your point can u explain me in steps,which is the delete statement
sorry i m not getting
sorry but i will get back to u tmrw ,please reply me the answer of query tmrw
It should look like this
UPDATE celebs
SET twitter_handle = ‘@taylorswift13’
WHERE id = 4;
DELETE FROM celebs WHERE twitter_handle IS NULL;
SELECT * FROM celebs;