Pls I need assistance on this zoo challenge, I am not getting it. Will the query for both questions be written together? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Pls I need assistance on this zoo challenge, I am not getting it. Will the query for both questions be written together?

12th Sep 2022, 3:59 PM
Damilola Olusegun
Damilola Olusegun - avatar
2 Answers
+ 2
Thanks pandey❤️🌟
13th Sep 2022, 2:24 PM
Damilola Olusegun
Damilola Olusegun - avatar
+ 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;
12th Sep 2022, 4:16 PM
I am offline
I am offline - avatar