Align Technology interview question

Technical questions around SQL, in a specific use case, how would you approach coding out an answer