0

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

17th Dec 2020, 8:15 AM
K Sanjana Satya Narayana
K Sanjana Satya Narayana - avatar
5 Antworten
+ 4
K Sanjana Satya Narayana Show your attempts.
17th Dec 2020, 8:18 AM
A͢J
A͢J - avatar
+ 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
17th Dec 2020, 11:57 AM
A͢J
A͢J - 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 in animals.country_id = countries.id ORDER BY country_id DESC;
17th Dec 2020, 11:55 AM
K Sanjana Satya Narayana
K Sanjana Satya Narayana - 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 country_id DESC;
17th Dec 2020, 12:14 PM
K Sanjana Satya Narayana
K Sanjana Satya Narayana - avatar
- 1
I have corrected it but still I'm getting expected output....but it shows no input😔
17th Dec 2020, 12:15 PM
K Sanjana Satya Narayana
K Sanjana Satya Narayana - avatar