The vet wants to give the two oldest cats a check-up. From the pets table, look only at rows whose kind is 'cat', pick name and age, order by age from oldest to youngest, and keep the first 2 rows.
The tables
owners
id
name
city
phone
1
Lena
Oslo
555-0101
2
Marco
Rome
NULL
3
Priya
Oslo
555-0103
4
Omar
Cairo
NULL
5
Sofia
Rome
555-0105
5 rows
pets
id
name
kind
age
weight
owner_id
1
Biscuit
dog
3
12
1
2
Mochi
cat
5
4
1
3
Pepper
dog
8
20
2
4
Nemo
fish
1
NULL
3
5
Luna
cat
2
3
3
6
Rex
dog
11
30
NULL
7
Kiwi
bird
4
NULL
5
8
Tofu
cat
7
5
NULL
8 rows
owners
id
name
city
phone
1
Lena
Oslo
555-0101
2
Marco
Rome
NULL
3
Priya
Oslo
555-0103
4
Omar
Cairo
NULL
5
Sofia
Rome
555-0105
5 rows
pets
id
name
kind
age
weight
owner_id
1
Biscuit
dog
3
12
1
2
Mochi
cat
5
4
1
3
Pepper
dog
8
20
2
4
Nemo
fish
1
NULL
3
5
Luna
cat
2
3
3
6
Rex
dog
11
30
NULL
7
Kiwi
bird
4
NULL
5
8
Tofu
cat
7
5
NULL
8 rows
query.sql
-- your code here: WHERE to keep the cats, order by age biggest first, then only 2 rows
SELECT name, age
FROM pets;
Ctrl + Enter runs too
Result
Run shows what your query gives. When it looks right, Submit.