- 6
What is answer of project 28 in SQL
28 project
3 ответов
+ 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;
+ 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;
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;