Retrieve Accounts based on Billing State and Annual Revenue
Not Started

Challenge

Write a solution that finds the Id, BillingState, and AnnualRevenue of all Accounts where the BillingState is either 'California' or 'Texas' and the AnnualRevenue exceeds 250,000.

Return the results sorted by AnnualRevenue in ascending order.

The result format is in the following example:

IdBillingStateAnnualRevenue
0014x00000SESBfAAPCalifornia251000.16
0014x00000SESCLAA5Texas480000.39
0014x00000SESCNAA5California507617.22
0014x00000SESCNAA5California1250000.25