new_table.sql

SELECT * 
FROM owners                                   
INNER JOIN cats_owners                        
ON owners.id = cats_owners.owner_id           
INNER JOIN cats                               
ON cats_owners.cat_id = cats.id;

# returns
id          name        cat_id      owner_id    id          name        age         breed       net_worth
----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------
2           Sophie      3           2           3           Grumpy Cat  4           Persian     181600
3           Penny       3           3           3           Grumpy Cat  4           Persian     181600
2           Sophie      1           2           1           Maru        3           Scottish    1000000