Sql zoo

Question

/* name - "Slim", type - "Giraffe", country_id - 1 */INSERT INTO Animals(name,type,
country_id )
VALUES ('slim','Giraffe ',1);

SELECT Animals.name,Animals.type,
Countries.country FROM Animals ,countries
WHERE Animals.country_id =countries.id
ORDER BY Animals.country_id desc

Is it right

Answer 1

Garima
Try this one :

/* name - "Slim", type - "Giraffe", country_id - 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;

Happy Coding 👍

Answer 2

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

SELECT Animals.name, Animals.type, Countries.country
FROM Countries
INNER JOIN Animals ON Countries.id=Animals.country_id
order by country asc ;

Answer 3

Garima

No there should be s caps in slim

2nd you have to use INNER JOIN

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 Animals.country_id DESC;

Answer 4

This zoo project is making me bored
It really made me feel bad for solo learn I have tried all my plans yet nothing is happening I have got the required output
I think solo learn should check against the output not the code cause coding is an art

Answer 5

/* This lines is to insert data into the three columns in the animals table*/
INSERT INTO animals
VALUES ('Slim', 'Giraffe', 1);

/* This lines is to select the columns we wish to JOIN*/
SELECT animals.name, animals.type, countries.country
FROM countries

/* This lines is to match the data types we are JOINING*/
INNER JOIN animals ON animals.country_id = countries.id

/*This line is to order our table by the name of the countries*/
ORDER BY countries.country;

Answer 6

Hey can any one provide correct answer for this zoo project kindly message me . I have tried all queries but not work getting same answer with non capital letters.

Answer 7

/* name - "Slim", type - "Giraffe", country_id - 1 */
here we are inserting info into tables :

=> insert into Animals (name,type,country_id) values ('Slim','Giraffe',1);

for result we use select & unner join to take from Countries table country and use it in animals table :

=> SELECT Animals.name,Animals.type,Countries.country
FROM Animals INNER JOIN Countries
ON Animals.country_id=Countries.id order by Countries.country;

Answer 8

it is 'Slim' not 'slim'