Reality Mining Queries…

Time Analyzed: 2004-09-01 to 2004-11-30
Query to check the most active users within this time period:
mysql> select person_oid,count(distinct device_oid) as count from devicespan where device_oid in (select oid from device where person_oid>0) and (starttime > ‘2004-09-07 00:00:00′ and endtime < ‘2005-05-04 24::00′) group by person_oid order by count desc limit 10;
+————+——-+
| person_oid | count |
+————+——-+
| [...]