1
00:00:00,090 --> 00:00:02,050
All right, so it's your turn here.

2
00:00:02,070 --> 00:00:04,230
We're going to get some practice with delete.

3
00:00:04,410 --> 00:00:06,750
So we have three different things I'd like you to do.

4
00:00:07,200 --> 00:00:10,950
The first one is to delete all cats that are four years old.

5
00:00:11,310 --> 00:00:15,780
So if we look at our data, there's only one right now because we got rid of egg.

6
00:00:15,870 --> 00:00:22,140
But I would like you so don't just say delete Ringo or where breed is British short hair or ideas one

7
00:00:22,140 --> 00:00:30,150
but use age then the next is to delete cats whose age is the same as their cat ID.

8
00:00:30,360 --> 00:00:34,170
Now I had you do something similar to this with these select exercises.

9
00:00:34,440 --> 00:00:37,230
Now you'll need to put that together with delete.

10
00:00:37,770 --> 00:00:40,980
So in our case, it's only Jack at this point.

11
00:00:40,980 --> 00:00:46,380
So Jack has an ID of seven and age of seven, but once again, no cheating.

12
00:00:46,380 --> 00:00:49,020
Don't just select based off of name or breed.

13
00:00:49,020 --> 00:00:51,000
Do it the way I specified, please.

14
00:00:51,480 --> 00:00:59,040
I mean, it's up to you, but the way I recommend next up is to oh my gosh, delete all cats.

15
00:00:59,040 --> 00:01:03,570
So that thing that I said I wasn't going to do because I didn't want to delete all of our data, well,

16
00:01:03,570 --> 00:01:04,680
you're going to do it.

17
00:01:04,680 --> 00:01:08,790
And then we'll be starting with a whole bunch of new data in the next exercise.

18
00:01:09,180 --> 00:01:10,800
All right, give it a shot.