- 6

What is answer of project 28 in SQL

28 project

3rd Dec 2021, 11:56 AM
Muzaffar Munshi
Muzaffar Munshi - avatar
3 Answers
+ 2
`country_id` column probably contains numeric value, so there's no need to put quotes around its value. INSERT INTO Animals (name, type, country_id) VALUES ('Slim', 'Giraffe', 1); SELECT Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY Countries.country;
3rd Dec 2021, 1:15 PM
Ipang
+ 1
INSERT INTO Animals (name,type,country_id) VALUES ('Slim', 'Giraffe','1'); Select Animals.name, Animals.type, Countries.country From Animals INNER JOIN Countries ON Animals.country_id = Countries.id Order by Countries.country;
25th Jul 2022, 4:35 AM
Alexander Le
Alexander Le - avatar
0
INSERT INTO Animals (name, type, country_id) VALUES ('Slim', 'Giraffe', '1'); SELECT Animals.name, animals.type, countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY Countries.country;
3rd Dec 2021, 11:57 AM
Muzaffar Munshi
Muzaffar Munshi - avatar