Placeholder intro: build the three-line placeholder query one step at a time. Each round sets one task — choose a code fragment to insert it into the console, review the result it returns, then move to the next round. No typing is needed.
Round 1 of 4
FETCH placeholder_rows FROM fragment one
FILTER WHERE fragment two
GROUP BY fragment three SORT BY fragment four
Placeholder task one: choose the fragment that names the data source for line one.
| label | value_one | value_two |
|---|---|---|
| placeholder_a | 101 | alpha |
| placeholder_b | 102 | beta |
| placeholder_c | 103 | gamma |
Placeholder explanation one: the fragment you chose names the source the first line reads from.
Placeholder task two: choose the fragment that filters the rows on line two.
| label | value_one | value_two |
|---|---|---|
| placeholder_a | 101 | alpha |
| placeholder_c | 103 | gamma |
| placeholder_d | 104 | delta |
Placeholder explanation two: the filter fragment decides which rows survive to the next step.
Placeholder task three: choose the fragment that groups the rows on line three.
| group | row_count | total |
|---|---|---|
| placeholder_group_1 | 4 | 410 |
| placeholder_group_2 | 2 | 205 |
| placeholder_group_3 | 3 | 309 |
Placeholder explanation three: the grouping fragment collapses matching rows into one summary row each.
Placeholder task four: choose the fragment that orders the grouped results.
| group | row_count | total |
|---|---|---|
| placeholder_group_1 | 4 | 410 |
| placeholder_group_3 | 3 | 309 |
| placeholder_group_2 | 2 | 205 |
Placeholder explanation four: the ordering fragment sets which summary row appears first.
Placeholder completion line: you built the full three-line query across four rounds.