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
Given a SQL query string, extract all table names following FROM or JOIN clauses. Return a sorted list with no duplicates. Assume simple identifiers without schema prefixes; aliases may follow and should be stripped.
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.