10.Right and Full Joins

Every category with its products. Use RIGHT JOIN, with products as the left table. The product name, then the category name.
Think before you run it: how many rows does products p FULL JOIN categories c ON p.category_id = c.id return?
Run that FULL JOIN: the product name, then the category name.
Every employee and every department: the employee's name, then the department's name. Keep the rows without a partner from both tables.
Which employee has no department?

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT p.name, c.name
FROM products p
JOIN categories c ON p.category_id = c.id;

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

Objective 1 of 50/5 done