Sales leadership wants a list of their biggest Technology customers.
Write a SOQL query that returns the Name and AnnualRevenue of every Account whose Industry is 'Technology' and whose AnnualRevenue is greater than 500,000.
Sort the results by AnnualRevenue, highest first. Break ties by Name ascending.
| Name | AnnualRevenue |
|---|---|
| Acme Cloud 42 | 4,200,000 |
| Acme Cloud 41 | 4,100,000 |
Name and AnnualRevenue.AnnualRevenue must not appear.9 row(s), order checked
| # | Name | AnnualRevenue |
|---|---|---|
| 1 | Acme Cloud 55 | 5500000 |
| 2 | Acme Cloud 49 | 4900000 |
| 3 | Acme Cloud 43 | 4300000 |
| 4 | Acme Cloud 37 | 3700000 |
| 5 | Acme Cloud 31 | 3100000 |
| 6 | Acme Cloud 25 | 2500000 |
| 7 | Acme Cloud 19 | 1900000 |
| 8 | Acme Cloud 13 | 1300000 |
| 9 | Acme Cloud 7 | 700000 |