It's time for some rapid fire exercises.
These will be quick.
There's a series of outputs that I've generated, so I ran some query to get this or to get this, and
I want you to write those queries.
They all are with the cat's table.
So the same data that we've already been working with, Ringo, Cindy, Dumbledore and so on.
Okay.
So this first one I'd like you to do is write the query that selects the following cat ID for all the
rows.
So the second one, I'm going to have a solution video after this, by the way.
The second one is to write the SQL that selects this name and breed for all the rows.
And then next up, a little trickier.
These are both tabby cats.
So remember that every cat has a breed and there's two of them that have that breed of tabby.
So select those two cats.
But I only want to see name and age, output or outputted printed out.
And then an even trickier one.
I didn't show you how to do this.
These are the two rows in our table that have a cat ID that is the same as their age.
So you'll write a query that generates this output for these cats egg right has an idea for and an age
of four.
But I don't care about the name and the breed.
I only want cat ID and age.
Print it out so there's four pieces in the next video.
I'll do this myself.
I'll see you then.