06.Use Table Aliases

The editor holds a join that fails. Run it and read the error.

Fix the query. The result needs the order's id, the customer's name, then the order_date. Give each table an alias.
Every product with its category and price. Name the three result columns product, category and price, in that order.
Employees who work in a department in Toronto: the employee's name, then the department's name.
Run SELECT orders.id FROM orders o;. Which alias does the HINT line suggest?

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT id, name, order_date
FROM orders
JOIN customers ON customer_id = customers.id;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 40/4 done

Fix the ambiguous query
Order id, customer name, order date. One row for each order.