Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren0
Final SQL Project
Please can anyone assist me on the last project on SQL? I've been stuck on it for a while now.
3 Antworten
+ 3
Post the task and copy your code attempt into the code playground and attach it here.
+ 2
Attach = while editing the question description, tap "+" button, then "Code", and select the saved code.
+ 1
As others have said, you should post your task and the attempt at it. I assume you mean the "Zoo" Project on the SQL course, which is the following:
Given two tables, "Animals" and "Countries"...
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.
Hints/restatement of the problem:
1) You are to INSERT the Giraffe into the Animals table
2) You are to SELECT a query that JOINS the tables's data, sorted by (ORDER BY) countries.