Fulfillable Order Percentage

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

Join orders to customers using orders.order_id = customers.customer_id (matching values treated as correspondence). Compute the percentage of orders where the matching customer row has a non-NULL country. Denominator is every orders row. Return a single percentage.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.