The vet's sign needs "pet name + owner name". The pets table only has owner_id; the owners' names are in the owners table. Join the two tables and pick the pet's name and the owner's name. Pets with no owner are left out.
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
SELECT pets.name, owners.name
FROM pets
-- your code here: JOIN owners, matching pets.owner_id = owners.id
;
Ctrl + Enter runs too
Result
Run shows what your query gives. When it looks right, Submit.