SQL and Python String Handling | Dataford Interview Questions

Tell me about a time you solved SQL and Python string-handling problems, including an anagram-style program.

For the SQL portion, prepare ready string pairs for comparison by standardizing case and removing non-alphanumeric characters. Exclude incomplete or empty pairs.

Output

One row per eligible pair from string_pairs
Columns: pair_id, left_cleaned, right_cleaned, left_length, right_length, and same_normalized_text
Include only rows with status = 'ready', non-null inputs, and non-empty cleaned values
Order by pair_id ascending

Schema

string_pairs

Column	Type	Description
pair_idPK	INT	Unique identifier for the string pair
left_text	VARCHAR(255)	First input string
right_text	VARCHAR(255)	Second input string
status	VARCHAR(20)	Processing status of the pair

Your question is SQL and Python String Handling. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem