Practical Hands-on SOQL Challenges
| # | Name | Description | Status |
|---|---|---|---|
| 1 | Challenge Prereqs | Read this before you start | Not Started |
| 2 | Retrieve Accounts based on Billing Country | Easy | Not Started |
| 3 | Retrieve Accounts based on Billing Countries | Easy | Not Started |
| 4 | Retrieve and Sort Accounts based on Type and Rating | Easy | Not Started |
| 5 | Retrieve Accounts based on Name | Easy | Not Started |
| 6 | Retrieve Contact based on Created Date | Easy | Not Started |
| 7 | Retrieve Accounts based on Billing State and Annual Revenue | Medium | Not Started |
| 8 | The newest Non-North American Account | Medium | Not Started |
| 9 | Retrieve Contact and Account information | Medium | Not Started |
| 10 | Count the number of Contacts per Account | Medium | Not Started |
| 11 | Average Amount of Opportunity | Hard | Not Started |
| 12 | The Sum of Closed Won Opportunity Amount per Account | Hard | Not Started |
| 13 | Find Accounts with more than one Opportunity | Hard | Not Started |