A placeholder practice pattern. Look at the two source tables, predict what the placeholder operation will return, then reveal the result to check your prediction.
| id | value_a |
|---|---|
| 1 | alpha |
| 2 | bravo |
| 3 | charlie |
| 4 | delta |
| id | value_b |
|---|---|
| 2 | echo |
| 3 | foxtrot |
| 4 | golf |
| 5 | hotel |
How many rows will the placeholder operation return?
| id | value |
|---|---|
| 1 | alpha |
| 2 | bravo |
| 3 | charlie |
| 4 | delta |
| 5 | hotel |
The placeholder operation keeps one row per distinct id across both tables — ids 2, 3 and 4 appear in both, so 8 input rows become 5 result rows.
0 of 1 completed