Left Join: All Orders with User Info

Easy
Joins
Left Join
Uber
Airbnb

Left Join: All Orders with User Info

Left join orders to users on user_id so every order is kept, with NULL name/city when the user is missing. Return order_id, name, amount sorted by order_id.

Browser Engine: Evaluates PySpark DataFrame & SQL logic locally in Pyodide WebAssembly.

Input data

0 DataFrames

These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].

Browser engine
Loading Python editor…
Click Run to try the sample cases, or Submit to check the hidden cases. First run caches the browser Python engine (~8–15s once); all code stays on your device.