Group Anagrams and Frontend/Backend Tradeoffs | Dataford Interview Questions

Tell me about how you would group anagrams, and explain how you think about backend and frontend technologies for delivering the feature.

Use the supplied word-set and word-entry data. Return only anagram groups containing at least two distinct normalized words.

Output

One row per anagram group, with set_name, signature, anagram_count, and words.
Normalize words by trimming and comparing case-insensitively; ignore NULL or empty values.
Sort by set_name, then signature.

word_sets

Column	Type	Description
set_idPK	INT	Identifier for a word set
set_name	VARCHAR(100)	Display name of the word set

words

Column	Type	Description
word_idPK	INT	Identifier for a word entry
set_id	INT	Word set containing the entry
word_text	VARCHAR(100)	Original word text

Your question is Group Anagrams and Frontend/Backend Tradeoffs. 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.