The Table Thief

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

Domain

Python

Difficulty

medium

Seniority

L4

Problem

You're building a data-lineage tool that needs to know which tables each query reads. Given a SQL query string `sql`, pull the table names that follow its FROM and JOIN keywords, where a name may be trailed by an alias that isn't part of it.

Summary

Somewhere in that query, tables are hiding.

Practice This Problem

Solve this Python problem with real code execution. DataDriven runs your Python code in a real environment and grades it automatically.