Where am I going wrong?? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Where am I going wrong??

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. 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

4th Aug 2022, 9:59 PM
Shiva Shankari Rajaram
1 Answer
+ 1
This SQL engine requires single quotes to delimit strings, not double quotes. Beware that some other SQL engines may use double quotes. So it is not wrong to use double quotes; just incompatible in this case.
4th Aug 2022, 10:13 PM
Brian
Brian - avatar