Challenge Prereqs
Not Started

Welcome to SOQL Challenges. No lessons here; just roll up your sleeve and show off what you've got.

Before You Start

To get started, have Camp Apex auto upload the sample dataset available on this page. This data includes mock/sample records for Account, Contact, and Opportunity, which you will query in the challenges.

Test your Queries

Once the sample data is in your org, you can start working on the challenges. Feel free to use your preferred SOQL tool, such as Salesforce Inspector or Workbench, to execute and verify your queries within your own org.

Submit Challenges

When you're ready to submit your query, enter it in the code editor on the right-hand side and click "Run." Camp Apex will validate your query against its test cases. Don't add any semi-colons or other Apex syntax, just SOQL syntax.

Let's start with some easier challenges to get you familiar with the format before we increase the difficulty. Good luck!

Challenge

Write a solution that finds the Id, StageName, and Amount of all Opportunities.

Return the result table in any order.

The result format is in the following example:

IdStageNameAmount
0064x00000SESBfAAPClosed Won88008.6
0064x00000SESCLAA5Negotiation/Review261.69
0064x00000SESCNAA5Closed Won72867.98