My question to those who have completed SQL regarding that zoo challenge module project. Please share whoever has done that.

Question

SQL query

Answer 1

INSERT INTO Animals VALUES ('Slim','Giraffe',1);

SELECT Name,Type,Country FROM Animals INNER JOIN Countries ON Animals.country_id=Countries.id ORDER BY country;

This is working but the first letter of each record (except header) are not in uppercase why?? Need help 🥺

Answer 2

You're missing animals in your table names.

select animals.name, animals.country, animals.type

Answer 3

insert into animals(name,type,country_id)
values ("Slim","Giraffe",1);

select name,type,country from animals inner join countries on animals.country_id=countries.id order by country;

*This is the code I have tried but still so error please clear the bug