Forecast review! Return the Name, Amount and CloseDate of every open Opportunity (IsClosed = false) with an Amount of at least 50,000 that closes this quarter.
Order by CloseDate ascending, then Name ascending.
The sandbox org's date is fixed at 2026-06-15 so date literals are deterministic. Use SOQL date literals rather than hard-coded dates.
THIS_QUARTER date literal.18 row(s), order checked
| # | Name | Amount | CloseDate |
|---|---|---|---|
| 1 | Opp 4 | 50000 | 2026-04-04 |
| 2 | Opp 6 | 75000 | 2026-04-08 |
| 3 | Opp 7 | 87500 | 2026-04-10 |
| 4 | Opp 9 | 112500 | 2026-04-14 |
| 5 | Opp 15 | 62500 | 2026-04-26 |
| 6 | Opp 16 | 75000 | 2026-04-28 |
| 7 | Opp 18 | 100000 | 2026-05-02 |
| 8 | Opp 19 | 112500 | 2026-05-04 |
| 9 | Opp 24 | 50000 | 2026-05-14 |
| 10 | Opp 25 | 62500 | 2026-05-16 |
| 11 | Opp 27 | 87500 | 2026-05-20 |
| 12 | Opp 28 | 100000 | 2026-05-22 |
| 13 | Opp 34 | 50000 | 2026-06-03 |
| 14 | Opp 36 | 75000 | 2026-06-07 |
| 15 | Opp 37 | 87500 | 2026-06-09 |
| 16 | Opp 39 | 112500 | 2026-06-13 |
| 17 | Opp 45 | 62500 | 2026-06-25 |
| 18 | Opp 46 | 75000 | 2026-06-27 |