Guys plz help me out solving my 3rd project in sql.I have got the expected output but still its showing no input.help me out plz

Answer 1

K Sanjana Satya Narayana Show your attempts.

Answer 2

K Sanjana Satya Narayana

country_id is a Number so don't insert like as String just write 1 not '1'.

There is no IN, there is ON when you join 2 tables.

ON animals.countrt_id = countries.id

Answer 3

INSERT INTO animals (name,type,country_id) VALUES( 'slim', 'Giraffe', '1');
SELECT animals.name, animals.type, countries.country from animals INNER JOIN countries in animals.country_id = countries.id
ORDER BY country_id DESC;

Answer 4

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

Answer 5

I have corrected it but still I'm getting expected output....but it shows no input😔