Challenge
Write a solution that finds the Id, Name, NumberOfEmployees, Type, and Rating from all Accounts where the Type equals 'Customer - Direct' and the Rating is 'Cold' or blank.
Return the results sorted by NumberOfEmployees in ascending order
The result format is in the following example:
Id | Name | NumberOfEmployees | Type | Rating |
---|---|---|---|---|
0014x00000SESBfAAP | Lucia and Sons | 8 | Customer - Direct | Cold |
0014x00000SExyzAAB | DeAngelo Customs | 26 | Customer - Direct | |
0014x00000FYkloDDB | Perry's Custom Closets | 1997 | Customer - Direct | Cold |