Zendesk interview question

More about Sql transactions, nested queries.