Challenge
Write a query that retrieves contacts from the Legal Department whose Accounts have over 50 employees. For each contact, retrieve the Id, Department, and Email, along with the Name and NumberOfEmployees of their associated
Accounts.
Return the results in any order
The result format is in the following example:
| Id | Department | Account Name | Account NumberOfEmployees | |
|---|---|---|---|---|
| 0038b000034AzkeAAC | jtemlett0@narod.eu | Legal | Stroman-Durgan LLC | 13 |
| 0038b000034AzkjAAC | jbaillie1@si.edu | Legal | Tremblay-Langworth Corp | 26 |