Salesforce interview question

Datacenter/SQL question about joins and ordering