It's time to get some practice deleting using my SQL, using the cat's table.
The same cats, the same seven cats are in there.
I'd like you to delete all four year old cats.
Do that first and then delete the cats who is age is the same as their cat id, so a little trickier
if we go back to our cats.
At least two of them have the same age as their ID.
It might just be.
Actually, I think it's just one now because we update it earlier.
So it would be Jack has cat ID of seven age of seven but I don't want you to hardcoded that in and and
use the fact that his name is Jack or that his age is seven.
I want the query to be based off of the cat ID and age, no matter how many matches there are, I want
them all delete it.
But again, in this case I think it's just one and then finally delete all the cats.
But don't drop the table, just empty it out.
All right.
I'll be back with a solution in the next video.
I wish you luck, but you don't need it.