Azure and AWS Technical Fit | Dataford Interview Questions

Your question is Azure and AWS Technical Fit. Start with the requirements and the three tables on the right.

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

Problem

Tell me about how you approach technical questions involving Azure and AWS in a customer conversation.

For this SQL exercise, use the provided tables to identify customer conversations that include technical questions about both platforms. Return the requested conversation-level results.

Output

One row per conversation that includes questions about both Azure and AWS.
Columns: conversation_id, customer_name, conversation_date, question_count, unresolved_question_count, and latest_question_at.
Count only Azure and AWS questions. Treat resolved = false or resolved IS NULL as unresolved.
Order by conversation_date descending, then conversation_id ascending.

Schema

customer_conversations

Column	Type	Description
conversation_idPK	INT	Unique customer conversation identifier
customer_name	VARCHAR(100)	Customer name
conversation_date	DATE	Date the customer conversation occurred

technical_questions

Column	Type	Description
question_idPK	INT	Unique technical question identifier
conversation_id	INT	Conversation containing the question
platform_id	INT	Referenced cloud platform
asked_at	TIMESTAMP	Timestamp when the question was asked
resolved	BOOLEAN	Whether the question was resolved

cloud_platforms

Column	Type	Description
platform_idPK	INT	Unique cloud platform identifier
platform_name	VARCHAR(50)	Cloud platform name