hello guys please help me out in solving the zoo project in SQL

Question

please suggest me the code that is working

Answer 1

Can you share your attempt?

Part of the solution is an insert statement like this:
insert into animals (name, type, country_id) values('Slim', 'Giraffe', 1);

The select query is the most tricky part. I solved it but it seems less fun and less educational to spoil the challenge by sharing my solution without seeing your attempt.