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