1
00:00:00,120 --> 00:00:02,710
It's time for some rapid fire exercises.

2
00:00:02,730 --> 00:00:03,910
These will be quick.

3
00:00:03,930 --> 00:00:10,680
There's a series of outputs that I've generated, so I ran some query to get this or to get this, and

4
00:00:10,680 --> 00:00:12,780
I want you to write those queries.

5
00:00:12,810 --> 00:00:14,730
They all are with the cat's table.

6
00:00:14,730 --> 00:00:19,140
So the same data that we've already been working with, Ringo, Cindy, Dumbledore and so on.

7
00:00:19,730 --> 00:00:20,070
Okay.

8
00:00:20,070 --> 00:00:26,490
So this first one I'd like you to do is write the query that selects the following cat ID for all the

9
00:00:26,490 --> 00:00:27,060
rows.

10
00:00:27,690 --> 00:00:31,260
So the second one, I'm going to have a solution video after this, by the way.

11
00:00:31,290 --> 00:00:36,240
The second one is to write the SQL that selects this name and breed for all the rows.

12
00:00:36,840 --> 00:00:39,390
And then next up, a little trickier.

13
00:00:40,150 --> 00:00:42,280
These are both tabby cats.

14
00:00:42,280 --> 00:00:49,120
So remember that every cat has a breed and there's two of them that have that breed of tabby.

15
00:00:49,450 --> 00:00:51,160
So select those two cats.

16
00:00:51,160 --> 00:00:56,590
But I only want to see name and age, output or outputted printed out.

17
00:00:56,980 --> 00:00:58,660
And then an even trickier one.

18
00:00:58,660 --> 00:01:00,030
I didn't show you how to do this.

19
00:01:00,040 --> 00:01:06,190
These are the two rows in our table that have a cat ID that is the same as their age.

20
00:01:06,520 --> 00:01:15,160
So you'll write a query that generates this output for these cats egg right has an idea for and an age

21
00:01:15,160 --> 00:01:15,910
of four.

22
00:01:15,910 --> 00:01:17,740
But I don't care about the name and the breed.

23
00:01:17,740 --> 00:01:19,330
I only want cat ID and age.

24
00:01:19,330 --> 00:01:23,020
Print it out so there's four pieces in the next video.

25
00:01:23,020 --> 00:01:24,250
I'll do this myself.

26
00:01:24,250 --> 00:01:24,970
I'll see you then.