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

Domain

SQL

Difficulty

medium

Problem

Operations is auditing data completeness for fulfillment. An order is fulfillable when it can be matched to a customer record that has a country on file. Treat the order ID and customer ID as the join key (same value, different column name). Out of every order, what percentage are fulfillable? Return a single percentage.

Summary

What percentage of orders can be fulfilled?

Practice This Problem

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