idBIGINTGaia source_id — unique star identifier
bTINYINTBand: 0 = BP (blue photometer), 1 = RP (red photometer)
fFLOATFlux in electrons/sec — one observation per row
🚩 Goal: Find all stars whose flux (f) changed by more than 100% in either the BP (b=0) or RP (b=1) band over the Gaia observation period.
⚠️ Note: Some observations are invalid (f=0) due to detector noise — a star with even one bad reading will trivially look variable.
🗄️ Data: 5,668,090 rows total
🎯 Target Answer: 57,099 stars