SQL SELECT name not working

SQL
1

In the third section

Retrieving Data From Multiple Tables (01:02)

First Inner Joins video, in the end exercise, it asks to show the product_id, name, quantity etc.

But when I type out SELECT name, the name is highlighted in blue and is throwing an error.

How to show the name???

2

please provide more context .

3

SELECT
o.order_id,
o.order_date,
c.first_name,
c.last_name,
os.name
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id
INNER JOIN order_statuses os ON o.status = os.order_status_id

Let me know wether you were asking query on Exercise…I will revert that too.