Every part, with its supplier (if assigned)
Some parts don't have a supplier assigned yet. Return every part's name and its supplier's name: parts without a supplier should still appear, with a NULL supplier name.
Return part_name and supplier_name.
Schema
▸suppliers
| id | INT |
| supplier_name | TEXT |
| country | TEXT |
▸parts
| id | INT |
| part_name | TEXT |
| supplier_id | INT |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime