0

Solo learns SQL 28 why not?

/* name - "Slim", type - "Giraffe", country_id - 1 */ 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 GROUP BY name, type, country ORDER BY country

18th Mar 2022, 9:08 PM
Š’Š°Š»ŠµŃ€ŠøŠ¹
Š’Š°Š»ŠµŃ€ŠøŠ¹ - avatar
3 Answers
+ 1
The task just doesn't ask for it. The task is to list all animals, not groups of them.
18th Mar 2022, 10:01 PM
Simon Sauter
Simon Sauter - avatar
+ 1
Try without the GROUP BY clause.
18th Mar 2022, 9:54 PM
Simon Sauter
Simon Sauter - avatar
0
Thx. why is Group By not used? AVG
18th Mar 2022, 9:59 PM
Š’Š°Š»ŠµŃ€ŠøŠ¹
Š’Š°Š»ŠµŃ€ŠøŠ¹ - avatar