Anagram Check With SQL | Dataford Interview Questions

How would you write a query to check whether two given strings are anagrams of each other?

Assume comparisons are case-insensitive and ignore spaces and non-alphanumeric characters. Return false when either input is NULL.

Output

One row per string pair, with pair_id, left_string, right_string, and is_anagram
Include every pair, including pairs with NULL inputs
Order by pair_id ascending

strings

Column	Type	Description
string_idPK	INT	Identifier for an input string
input_string	VARCHAR(255)	String to compare

string_pairs

Column	Type	Description
pair_idPK	INT	Identifier for a string pair
left_string_id	INT	Reference to the first string
right_string_id	INT	Reference to the second string

Your question is Anagram Check With SQL. Start with the requirements and the two tables 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.