SQL practice: Other JOINs: RIGHT, FULL, and CROSS
Chapter 14C · 3 questions · included in full access
Question 1 · easy
Solve it in your browserWrite a query that creates a complete grid of every possible combination of customer and product. Return customer_name and product_name using a CROSS JOIN.
Question 2 · easy
Solve it in your browserWe want a list of ALL customers and ALL orders, regardless of whether they match. Use FULL OUTER JOIN to return customer_name, order_id, and order_date.
Question 3 · hard
Solve it in your browserShow employee_name and branch_name for all branches, including any branches that have no employees assigned, using a RIGHT JOIN between employees and branches on branch_id.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing