SQL practice: Other JOINs: RIGHT, FULL, and CROSS

Chapter 14C · 3 questions · included in full access

  1. Question 1 · easy

    Write 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.

    Solve it in your browser
  2. Question 2 · easy

    We 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.

    Solve it in your browser
  3. Question 3 · hard

    Show 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.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing