DataDriven
LearnPracticeInterviewDiscussDailyJobs

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.

Related

  • All Practice Problems
  • Mock Interview Mode
  • Python Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons