1
00:00:00,120 --> 00:00:04,770
It's time to get some practice deleting using my SQL, using the cat's table.

2
00:00:04,770 --> 00:00:07,160
The same cats, the same seven cats are in there.

3
00:00:07,170 --> 00:00:09,840
I'd like you to delete all four year old cats.

4
00:00:09,840 --> 00:00:18,510
Do that first and then delete the cats who is age is the same as their cat id, so a little trickier

5
00:00:18,510 --> 00:00:20,100
if we go back to our cats.

6
00:00:20,460 --> 00:00:23,280
At least two of them have the same age as their ID.

7
00:00:23,310 --> 00:00:23,910
It might just be.

8
00:00:23,910 --> 00:00:27,150
Actually, I think it's just one now because we update it earlier.

9
00:00:27,150 --> 00:00:34,800
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

10
00:00:34,800 --> 00:00:38,160
use the fact that his name is Jack or that his age is seven.

11
00:00:38,160 --> 00:00:44,220
I want the query to be based off of the cat ID and age, no matter how many matches there are, I want

12
00:00:44,220 --> 00:00:45,720
them all delete it.

13
00:00:45,870 --> 00:00:51,000
But again, in this case I think it's just one and then finally delete all the cats.

14
00:00:51,000 --> 00:00:53,490
But don't drop the table, just empty it out.

15
00:00:53,850 --> 00:00:54,270
All right.

16
00:00:54,270 --> 00:00:56,310
I'll be back with a solution in the next video.

17
00:00:56,310 --> 00:00:58,470
I wish you luck, but you don't need it.