SOQL queries and bulk-safe Apex triggers, judged against seeded mock orgs.
| Status | Title | Type | Topics | Created | Acceptance | Difficulty |
|---|---|---|---|---|---|---|
| Accounts With High-Priority Open Cases | SOQL | Semi-JoinSubqueryCase | Oct 5, 2026 | 100.0% | Easy | |
| Contacts at Banking Accounts | SOQL | RelationshipsChild-to-Parent | Oct 2, 2026 | 100.0% | Easy | |
| High-Value Tech Accounts | SOQL | WHEREORDER BY | Oct 2, 2026 | 66.7% | Easy | |
| Accounts Without Opportunities | SOQL | Semi-joinAnti-join | Oct 2, 2026 | 100.0% | Medium | |
| Big Deals Closing This Quarter | SOQL | Date literalsORDER BY | Oct 2, 2026 | — | Medium | |
| Open Cases by Priority | SOQL | GROUP BYAggregates | Oct 2, 2026 | — | Medium | |
| Accounts and Their Open Opportunities | SOQL | Parent-to-ChildNested SubquerySemi-Join | Oct 9, 2026 | — | Hard | |
| Accounts With More Than Five Contacts | SOQL | GROUP BYHAVINGCOUNT | Oct 7, 2026 | — | Hard | |
| Accounts With Only Lost Deals | SOQL | Semi-JoinAnti-JoinClosed Lost | Oct 9, 2026 | — | Hard | |
| Contacts at Pipeline-Only Accounts | SOQL | Semi-JoinAnti-JoinRelationship Query | Oct 9, 2026 | — | Hard | |
| Dormant Accounts | SOQL | Anti-JoinDate LiteralsSemi-Join | Oct 9, 2026 | — | Hard | |
| Duplicate Contact Emails | SOQL | GROUP BYHAVINGCOUNT | Oct 7, 2026 | — | Hard | |
| High-Value Tech Contacts with Account Owner | SOQL | Parent RelationshipsMulti-Level TraversalNULLS LAST | Oct 9, 2026 | — | Hard | |
| Hot Accounts with Their Contacts | SOQL | RelationshipsParent-to-ChildSubquery | Oct 2, 2026 | — | Hard | |
| Large-Deal Lead Source Analysis | SOQL | COUNT_DISTINCTAVGHAVING | Oct 9, 2026 | — | Hard | |
| Largest Opportunity per Account | SOQL | Nested SubqueryLIMITSemi-Join | Oct 9, 2026 | — | Hard | |
| Lead Conversion by Source and Year | SOQL | GROUP BYDate FunctionsHAVING | Oct 9, 2026 | — | Hard | |
| Monthly Pipeline Created by Stage | SOQL | Date FunctionsGROUP BYHAVING | Oct 9, 2026 | — | Hard | |
| Open Pipeline Rollup by Owner and Stage | SOQL | GROUP BY ROLLUPAggregates | Oct 9, 2026 | — | Hard | |
| Quarterly Won Revenue | SOQL | Date FunctionsGROUP BYAggregates | Oct 9, 2026 | — | Hard | |
| Recent High-Priority Case Escalations | SOQL | Parent-to-ChildDate LiteralsSemi-Join | Oct 9, 2026 | — | Hard | |
| Top 3 Industries by Revenue | SOQL | GROUP BYHAVINGLIMIT | Oct 2, 2026 | — | Hard | |
| Top Industries by Won Revenue | SOQL | GROUP BYHAVINGParent Field Aggregate | Oct 9, 2026 | — | Hard | |
| Default Account Rating | Apex Trigger | before insertBulkification | Oct 2, 2026 | — | Easy | |
| Block Deleting Accounts with Open Deals | Apex Trigger | before deleteaddErrorBulkification | Oct 2, 2026 | — | Medium | |
| Closed Won Makes a Customer | Apex Trigger | after updateTrigger.oldMapBulkification | Oct 2, 2026 | — | Medium | |
| Maintain Account Contact and Opportunity Counts | Apex Trigger | Apex TriggerBulkificationAggregate SOQL | Oct 10, 2026 | — | Hard | |
| Roll Up Contact Count | Apex Trigger | after insertafter deleteAggregate SOQL | Oct 2, 2026 | — | Hard |