0
Pls I need assistance on this zoo challenge, I am not getting it. Will the query for both questions be written together?
2 Answers
+ 2
Thanks pandeyâ€ïžđ
+ 1
/* name - "Slim", type - "Giraffe", country_id - 1 */
INSERT INTO Animals
VALUES ( INITCAP('Slim'), INITCAP('Giraffe'), 1 );
/* As long as the values are in order and are given for all columns,
it's okay to omit column names after table name */
SELECT Animals.name, Animals.type, Countries.country
FROM Animals
INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY Countries.country;