Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок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
5 ответов
+ 4
K Sanjana Satya Narayana Show your attempts.
+ 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
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;
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;
- 1
I have corrected it but still I'm getting expected output....but it shows no input😔