Gaps and Islands

The Pattern The Query Gaps vs. Islands Both use the same subtraction trick. Islands group consecutive rows. Gaps find the spaces between them. How to Spot It Follow-Ups