Final SQL Project

Question

Please can anyone assist me on the last project on SQL? I've been stuck on it for a while now.

Answer 1

Post the task and copy your code attempt into the code playground and attach it here.

Answer 2

Attach = while editing the question description, tap "+" button, then "Code", and select the saved code.

Answer 3

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.