SQL ZOO

Question

Hi, can you please help me with this query? Thank you

1) A new animal has come in, with the following details:
name - "Slim", type - "Giraffe", country_id - 1
Add him to the Animals table.
2) You want to make a complete list of the animals for the zoo’s visitors. Write a query to output a new table with each animal's name, type and country fields, sorted by countries.

Answer 1

Thank you HBhZ_C I thought that I have to do it one by one.
So solution for it is:

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

Answer 2

How do I get the output to uppercase the first letter of each output?

Answer 3

But your code is not complete you have to use inner join to display the table as they give in the test cases order by country ....

Answer 4

yes, but it is the last task and I cant find anything wrong with my query

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

that is for the task 1) and I cant see the mistake

Answer 5

I can't get It to work also, i even tried a simple select * from Animals, but It says no output, it's driving me crazy

Answer 6

Also getting the output in lowercase while the intended output is supposed to be in capital letters for all the columns except the titles.
The code:

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

SELECT name, type, country
from Animals
inner join Countries
on Animals.country_id = Countries.id
order by country;

Answer 7

Same problems with lowercase/uppercase!((

Answer 8

Muthu kumar.V
Welcome

Answer 9

I followed the instruction and used INSERT and INNER JOIN. I only had to order the by country id.

/* First insert the new animal into Animals Table*/
INSERT INTO Animals(name,type,country_id)
VALUES ('Slim', 'Giraffe', 1 );

/* Join the table Animals and Countries and order by country_id*/
SELECT animals.name, animals.type, countries.country
From Animals INNER JOIN Countries
ON country_id = id order by country_id desc;

Hope this helps :)

Answer 10

How I was taught and get the same answer(The way SoloLearn teaches it is below this)

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

SELECT name, type, country FROM Animals
INNER JOIN Countries
ON country_id = id
ORDER BY country;

This is another "correct answer" but to me it is wrong compared to what the question asked. Also you do not have to do tableA.colmn_name if the column name is in one table. (SoloLEarn taught two different ways, I DO NOT like this way)

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

Answer 11

Hunter Johnson does the code works !

Answer 12

insert into Animals values ('Slim', 'Giraffe', 1);
select name, type, country from Animals inner join Countries on Animals.country_id = Countries.id order by country

Answer 13

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

Answer 14

Glad to see that you found the solution by your single effort and gain SQL certif.congrat.

Answer 15

it seems you must write all the queries for both parts first.

Answer 16

insert into Animals
values ('Slim', 'Giraffe', 1);

select name, type, country
from Animals
join Countries
on Animals.country_id = Countries.id
order by country;

Answer 17

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

SELECT Animals.name , Animals.type , Countries.country
FROM Animals INNER JOIN Countries
on Animals.country_id=Countries.id
ORDER BY country;

Answer 18

select animals.name, animals.type, countries.country
from animals inner join countries
on animals.country_id=countries.id
order by countries.country;

Answer 19

INSERT INTO Animals VALUES ('Slim','Giraffe',1);
SELECT Animals.name,Animals.type,Countries.country FROM Animals,Countries INNER JOIN Countries ON Animals.country_id=Countries.id ORDER BY Countries.country;

Not working.

Answer 20

remove ...FROM Animals,Countries... table Countries cuz you joining it to Animals. Rest of query is correct