← The arcade

Data Wrangling · difficulty 2 of 3

Join two tables 🔗

Join orders to customers on an id. Report the matched rows, count the orphans whose customer is missing, rank the spenders, and name the customer who never ordered.

This one is part of Pro. Plenty of arcade challenges are free to play right now.

Skills: dicts, lists, files

Open the arcade