SQL lesson problem

Question

on the problem of zoo i can't pass that any one can help me by sending the solution

Answer 1

How to solve lesson 19.2

Answer 2

SELECT products.productname,products.price,categories.categoryname
FROM categories
INNER JOIN products
on categories.id=products.categoryid
ORDER by products.id ASC ;

Answer 3

This queries failed
Help me

Answer 4

What's the question dude....
I have no clue about where the question is?..

Answer 5

Vishnuvasan Srinivasan The Code Coach exercise is found here https://www.sololearn.com/coach/1059?ref=app.

Walelign Balew the solution requires two SQL statements, an INSERT statement and a SELECT query, separated by a semi-colon. The SELECT query should use a JOIN clause to join tables by key fields and an ORDER BY clause to sort.

The problem is categorized as Hard. It may require some review of the lesson and examples. If you need further help then please show what you tried and explain what is going wrong.

Answer 6

I found the solution,
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
ORDER BY countries DESC