some short examples what you can do with your own harvested data
count the distinct number of aircrafts you got messages from:
select count(distinct hex) from aircrafts;
count how many messages you received per aircrafts:
SELECT hex, COUNT(hex) number FROM aircrafts GROUP BY hex
combine your data with e.g. basestation.sqb - see output below sql sample:
select * from aircrafts inner join basestation on aircrafts.hex = basestation.ModeS
sample output:
id date now hex flight altitude lat lon track speed vert_rate seen_pos seen rssi messages category squawk nucp mlat tisb AircraftID ModeS ModeSCountry Country Registration Status Manufacturer ICAOTypeCode Type SerialNo RegisteredOwners OperatorFlagCode
252186 2017-09-08 21:01:56 Friday 1504897316.1 a6bd32 EJM533 31000 47.801234 9.799171 144 510 -64 0.2 0.1 -3.8 13107 A2 0356 7 42480 A6BD32 United States N N533SR A Gulfstream Aerospace G450 G450 4253 Executive Jet Management EJM