text: data = [{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:05:32 PM","query":"SELECT app_id, ([2013-08-25-2013-08-31] - [2013-07-28-2013-08-03]) AS diff_download FROM [rlop2@pdx.edu].[android_app_weekly_downloads] ORDER BY diff_download DESC","id":"31728"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:06:17 PM","query":"SELECT app_id, ([2013-08-25-2013-08-31] - [2013-07-28-2013-08-03]) AS diff_download    FROM [rlop2@pdx.edu].[android_app_weekly_downloads]    ORDER BY diff_download DESC","id":"31730"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:06:57 AM","query":"select * from [rlop2@pdx.edu].[table_android_app_ranking.csv]","id":"253754"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:11:02 PM","query":"select app_id, ([2013-08-25-2013-08-31] - [2013-07-28-2013-08-03]) as diff_download    from [rlop2@pdx.edu].[android_app_weekly_downloads]","id":"250548"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:30:06 PM","query":"SELECT A.app_id, B.[DALVIK\/NDK(ARM)\/NDK(x86)] FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_apk_info.csv] B   WHERE A.app_name = B.APP_NAME AND A.rank <= 100","id":"31741"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:32:29 PM","query":"SELECT A.Period, A.app_id, B.[DALVIK\/NDK(ARM)\/NDK(x86)] FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_apk_info.csv] B   WHERE A.app_name = B.APP_NAME AND A.rank <= 100   AND A.Period = (SELECT MAX(Period) FROM [rlop2@pdx.edu].[android_app_ranking.csv])","id":"31745"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:35:05 PM","query":"SELECT COUNT(*) FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_apk_info.csv] B   WHERE A.app_name = B.APP_NAME AND A.rank <= 100   AND A.Period = (SELECT MAX(Period) FROM [rlop2@pdx.edu].[android_app_ranking.csv])","id":"31749"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:36:27 PM","query":"SELECT Period, COUNT(*) x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_apk_info.csv] B   WHERE A.app_name = B.APP_NAME AND A.rank <= 100   GROUP BY Period","id":"31751"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:36:43 PM","query":"SELECT Period, COUNT(*) AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_apk_info.csv] B   WHERE A.app_name = B.APP_NAME AND A.rank <= 100   GROUP BY Period","id":"31752"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:47:43 PM","query":"select * from [rlop2@pdx.edu].[table_android_app_lib.csv]","id":"251975"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:49:25 PM","query":"SELECT Period, COUNT(*) AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_app_lib.csv] B   WHERE A.app_id = B.packagename AND A.rank <= 100   GROUP BY Period","id":"31798"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:50:00 PM","query":"SELECT Period, COUNT(*)\/1000 AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_app_lib.csv] B   WHERE A.app_id = B.packagename   GROUP BY Period","id":"31799"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:50:21 PM","query":"SELECT Period, (COUNT(*) * 100 )\/1000 AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_app_lib.csv] B   WHERE A.app_id = B.packagename   GROUP BY Period","id":"31800"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:50:46 PM","query":"SELECT Period, ((COUNT(*)*100)\/1000) AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_app_lib.csv] B   WHERE A.app_id = B.packagename   GROUP BY Period","id":"31801"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:54:26 PM","query":"SELECT Period, ((COUNT(*)*100.00)\/1000.00) AS x86_percent FROM [rlop2@pdx.edu].[android_app_ranking.csv] A, [rlop2@pdx.edu].[android_app_lib.csv] B   WHERE A.app_id = B.packagename   GROUP BY Period","id":"31808"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 10:55:34 PM","query":"select period, ((count(*)*100.00)\/1000.00) as x86_percent from [rlop2@pdx.edu].[android_app_ranking.csv] a, [rlop2@pdx.edu].[android_app_lib.csv] b   where a.app_id = b.packagename   group by period","id":"252139"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 4:35:00 AM","query":"SELECT row_number() over (order by [Total Fat] DESC) as row      , *   FROM [billhowe].[categorized_fat_with_calories]","id":"31012"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 4:38:58 AM","query":"SELECT * FROM  (   SELECT row_number() over (order by [Total Fat] DESC) as row      , *   FROM [billhowe].[categorized_fat_with_calories] c  ) x  WHERE x.row = 3","id":"31013"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:14:45 PM","query":"SELECT row_number() over (order by [Period] ASC) as WW, Period FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31485"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:21:25 PM","query":"SELECT distinct(Period) FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31496"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:23:55 PM","query":"SELECT row_number() over (order by [Period] ASC) FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31501"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:25:36 PM","query":"SELECT distinct(Period), row_number() over (order by [Period] ASC) FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31504"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:33:04 PM","query":"SELECT distinct(Period) as range FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31506"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:42:56 PM","query":"SELECT period, app_category, count(*) FROM [rlop2@pdx.edu].[android_app_ranking.csv] group by period, app_category","id":"31510"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:46:19 PM","query":"SELECT period, app_category, count(*) FROM [rlop2@pdx.edu].[android_app_ranking.csv] where rank <= 100 group by period, app_category order by period, app_category","id":"31513"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:47:12 PM","query":"SELECT period, app_category, count(*) as top_ranks FROM [rlop2@pdx.edu].[android_app_ranking.csv] where rank <= 100 group by period, app_category order by period, top_ranks","id":"31515"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 7:47:37 PM","query":"SELECT period, app_category, count(*) as top_ranks FROM [rlop2@pdx.edu].[android_app_ranking.csv] where rank <= 100 group by period, app_category order by period asc, top_ranks desc","id":"31518"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:01:02 PM","query":"SELECT app_category, count(*) as top_category FROM [rlop2@pdx.edu].[android_app_ranking.csv] group by app_category order by top_category desc","id":"31526"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:06:47 PM","query":"SELECT app_category, count(*) as app_count FROM [rlop2@pdx.edu].[android_app_ranking.csv] group by app_category order by app_count desc","id":"31530"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:07:30 PM","query":"SELECT app_category, count(*) as app_count    FROM [rlop2@pdx.edu].[android_app_ranking.csv]    GROUP BY app_category ORDER BY app_count DESC","id":"31531"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:22:01 PM","query":"select app_category, count(*) * 100.0 \/ sum(count(*)) over() from [rlop2@pdx.edu].[android_app_ranking.csv]  group by app_category","id":"31543"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:22:37 PM","query":"select app_category, (count(*) * 100.0 \/ sum(count(*)) over()) as app_percent from [rlop2@pdx.edu].[android_app_ranking.csv]  group by app_category","id":"31544"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:22:53 PM","query":"select app_category, (count(*) * 100.0 \/ sum(count(*)) over()) as app_percent from [rlop2@pdx.edu].[android_app_ranking.csv]  group by app_category ORDER BY app_percent","id":"31545"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:23:05 PM","query":"select app_category, (count(*) * 100.0 \/ sum(count(*)) over()) as app_percent from [rlop2@pdx.edu].[android_app_ranking.csv]  group by app_category ORDER BY app_percent desc","id":"31546"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:40:22 PM","query":"SELECT app_category, (COUNT(*) * 100.0 \/ SUM(COUNT(*)) over()) AS app_percent    FROM [rlop2@pdx.edu].[android_app_ranking.csv]    GROUP BY app_category ORDER BY app_percent DESC","id":"31586"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:43:42 PM","query":"SELECT app_category, (COUNT(*) * 100.0 \/ SUM(COUNT(*)) over()) AS app_percent  FROM [rlop2@pdx.edu].[table_android_app_ranking.csv]    GROUP BY app_category ORDER BY app_percent DESC","id":"31590"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:48:02 PM","query":"SELECT distinct(app_category) FROM [rlop2@pdx.edu].[table_android_app_ranking.csv]","id":"31591"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:49:19 PM","query":"SELECT app_category, (COUNT(*) * 100.0 \/ SUM(COUNT(*)) over()) AS app_percent  FROM [rlop2@pdx.edu].[android_app_ranking.csv]  GROUP BY app_category ORDER BY app_percent DESC","id":"31592"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:52:21 PM","query":"SELECT app_category, COUNT(*) AS app_count  FROM [rlop2@pdx.edu].[android_app_ranking.csv]  GROUP BY app_category ORDER BY app_count DESC","id":"31594"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 8:52:37 PM","query":"select app_category, count(*) as app_count    from [rlop2@pdx.edu].[android_app_ranking.csv]    group by app_category","id":"255561"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:25:44 PM","query":"SELECT distinct(Period) FROM [rlop2@pdx.edu].[android_app_ranking.csv] order by period asc","id":"31649"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:30:25 PM","query":"SELECT app_id, app_category FROM [rlop2@pdx.edu].[android_app_ranking.csv]  PIVOT (MAX (downloads) FOR period IN (\"2013-07-28-2013-08-03\", \"2013-08-04-2013-08-10\", \"2013-08-11-2013-08-17\", \"2013-08-18-2013-08-24\", \"2013-08-25-2013-08-31\")) AS downloads;","id":"31661"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:31:10 PM","query":"SELECT * FROM [rlop2@pdx.edu].[android_app_ranking.csv]  PIVOT (MAX (downloads) FOR period IN (\"2013-07-28-2013-08-03\", \"2013-08-04-2013-08-10\", \"2013-08-11-2013-08-17\", \"2013-08-18-2013-08-24\", \"2013-08-25-2013-08-31\")) AS downloads;","id":"31666"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:36:24 PM","query":"SELECT period, app_id, downloads FROM [rlop2@pdx.edu].[android_app_ranking.csv]","id":"31673"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:37:55 PM","query":"select period, app_id, downloads from [rlop2@pdx.edu].[android_app_ranking.csv]","id":"250100"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:38:46 PM","query":"SELECT * FROM [rlop2@pdx.edu].[android_app_downloads]  PIVOT (MAX (downloads) FOR period IN (\"2013-07-28-2013-08-03\", \"2013-08-04-2013-08-10\", \"2013-08-11-2013-08-17\", \"2013-08-18-2013-08-24\", \"2013-08-25-2013-08-31\")) AS downloads;","id":"31683"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:41:22 PM","query":"select *    from [rlop2@pdx.edu].[android_app_downloads]    pivot (max (downloads) for period      in (\"2013-07-28-2013-08-03\", \"2013-08-04-2013-08-10\", \"2013-08-11-2013-08-17\", \"2013-08-18-2013-08-24\", \"2013-08-25-2013-08-31\"))    as downloads;","id":"250202"},{"owner":"rlop2@pdx.edu","date":"1\/22\/2014 9:45:45 PM","query":"SELECT *    FROM [rlop2@pdx.edu].[android_app_downloads]    PIVOT (MAX (downloads) FOR period      IN (\"2013-07-28-2013-08-03\", \"2013-08-04-2013-08-10\", \"2013-08-11-2013-08-17\", \"2013-08-18-2013-08-24\", \"2013-08-25-2013-08-31\"))    AS downloads;","id":"31696"},{"owner":"rlop2@pdx.edu","date":"1\/26\/2014 2:00:07 AM","query":"select * from [rlop2@pdx.edu].[table_freeway_detectors_1.csv]","id":"251137"},{"owner":"rlop2@pdx.edu","date":"1\/26\/2014 2:00:38 AM","query":"select * from [rlop2@pdx.edu].[table_freeway_stations.csv]","id":"251291"},{"owner":"rlop2@pdx.edu","date":"1\/26\/2014 2:01:22 AM","query":"select * from [rlop2@pdx.edu].[table_highways.csv]","id":"251399"},{"owner":"rlop2@pdx.edu","date":"1\/26\/2014 2:37:33 AM","query":"select * from [rlop2@pdx.edu].[table_freeway_loopdata.csv]","id":"251512"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:04:38 AM","query":"select * from highways","id":"33539"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:06:55 AM","query":"select * from freeway_detectors","id":"33540"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:08:17 AM","query":"select distinct(highwayid) from freeway_detectors","id":"33541"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:09:49 AM","query":"select * from freeway_loopdata","id":"33545"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:10:49 AM","query":"select * from freeway_detectors","id":"33547"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:12:14 AM","query":"select * from freeway_detectors where highwayid = '3'","id":"33548"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:19:08 AM","query":"select * from freeway_detectors where highwayid = '3';  select * from freeway_stations;","id":"33549"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:19:45 AM","query":"select * from freeway_stations;","id":"33550"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:22:43 AM","query":"select * from freeway_loopdata","id":"33551"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:24:40 AM","query":"select * from freeway_loopdata where detectorid in (select detectorid from freeway_detectors)","id":"33552"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:25:16 AM","query":"select * from freeway_detectors","id":"33553"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:27:27 AM","query":"select * from freeway_loopdata where detectorid in (select detectorid from freeway_detectors where highwayid = '3')","id":"33556"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:33:05 AM","query":"select * from highways","id":"33557"},{"owner":"rlop2@pdx.edu","date":"1\/28\/2014 1:33:47 AM","query":"select * from freeway_loopdata where detectorid in (select detectorid from freeway_detectors a, highways b where a.highwayid = b.highwayid and b.shortdirection = 'N')","id":"33558"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:19:03 PM","query":"select * from freeway_stations","id":"33726"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:24:44 PM","query":"select * from freeway_loopdata","id":"33728"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:27:35 PM","query":"select c.stationid, c.length_mid, a.detectorid, a.starttime, a.speed from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22 08%'","id":"33729"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:30:32 PM","query":"select * from freeway_stations where highwayid = '3'","id":"33730"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:30:46 PM","query":"select * from freeway_stations where highwayid = '3' order by locationtext","id":"33731"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:32:05 PM","query":"select * from freeway_stations where highwayid = '3' and stationid < 5000 order by locationtext","id":"33733"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:38:23 PM","query":"select * from freeway_stations where highwayid = '3' and stationid < 5000 order by locationtext","id":"33734"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:38:50 PM","query":"select * from freeway_stations where highwayid = '3' and stationid < 5000 order by locationtext, stationid","id":"33735"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:39:48 PM","query":"select * from freeway_loopdata","id":"33737"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:41:14 PM","query":"select b.stationid, b.length_mid, a.starttime, a.detectorid, a.speed from freeway_loopdata a, freeway_stations b    where b.stationid >= 1140 and b.stationid <= 1048   order by a.starttime","id":"33740"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:41:48 PM","query":"select b.stationid, b.length_mid, a.starttime, a.detectorid, a.speed from freeway_loopdata a, freeway_stations b    where b.stationid >= 1048 and b.stationid <= 1140   order by a.starttime","id":"33741"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:44:17 PM","query":"select b.stationid, b.length_mid, a.starttime, a.detectorid, a.speed from freeway_loopdata a, freeway_stations b    where b.stationid >= 1048 and b.stationid <= 1140   and a.starttime like '2011-09-22 08%'   order by a.starttime","id":"33743"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 11:46:30 PM","query":"select * from freeway_stations where highwayid = '3' and stationid < 5000 order by locationtext, stationid","id":"33744"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:36:03 AM","query":"select * from freeway_loopdata","id":"33673"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:41:17 AM","query":"select * from highways","id":"33674"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:41:35 AM","query":"select * from highways where shortdirection = 'N'","id":"33675"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:43:04 AM","query":"select * from freeway_stations where highwayid = '3'","id":"33676"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:45:25 AM","query":"select * from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3' and c.stationid = b.stationid and b.detectorid = a.detectorid","id":"33677"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:50:11 AM","query":"select * from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3' and c.stationid = b.stationid and b.detectorid = a.detectorid and a.starttime like '2011-09-22%'","id":"33683"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:52:45 AM","query":"select * from freeway_stations","id":"33684"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:56:07 AM","query":"select c.stationid, SUM(c.length_mid)\/AVG(a.speed) as travel_time  from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   group by c.stationid","id":"33686"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:57:15 AM","query":"select c.stationid, AVG(a.speed) as travel_time  from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   group by c.stationid","id":"33687"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 4:58:47 AM","query":"select c.stationid, AVG(a.speed)    from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   group by c.stationid","id":"33688"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 5:02:27 AM","query":"select c.stationid, c.length_mid, a.detectorid, a.starttime, a.speed from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'","id":"33690"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 5:50:47 AM","query":"select * from highways","id":"33691"},{"owner":"rlop2@pdx.edu","date":"1\/29\/2014 8:50:20 AM","query":"select min(starttime), max(starttime) from freeway_loopdata","id":"33697"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 12:28:10 PM","query":"SELECT count(*) FROM [rlop2@pdx.edu].[table_freeway_loopdata.csv]","id":"38273"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 12:33:05 PM","query":"SELECT count(*) FROM [rlop2@pdx.edu].[table_freeway_stations.csv]","id":"38274"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 12:35:46 PM","query":"SELECT count(*) FROM [rlop2@pdx.edu].[table_freeway_detectors_1.csv]","id":"38275"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 12:40:10 PM","query":"SELECT distinct(starttime) FROM [rlop2@pdx.edu].[table_freeway_loopdata.csv]","id":"38276"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 12:40:35 PM","query":"SELECT count(distinct(starttime)) FROM [rlop2@pdx.edu].[table_freeway_loopdata.csv]","id":"38277"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 1:03:06 PM","query":"SELECT * FROM [rlop2@pdx.edu].[table_freeway_stations.csv] where stationid < 5000 order by locationtext","id":"38278"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 2:27:26 PM","query":"SELECT * FROM [rlop2@pdx.edu].[table_freeway_stations.csv] where stationid < 5000 and highwayid = '4' order by locationtext","id":"38279"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 2:27:33 PM","query":"SELECT * FROM [rlop2@pdx.edu].[table_freeway_stations.csv] where stationid < 5000 and highwayid = '3' order by locationtext","id":"38280"},{"owner":"rlop2@pdx.edu","date":"2\/26\/2014 2:45:14 PM","query":"SELECT * FROM [rlop2@pdx.edu].[table_freeway_stations.csv] where stationid < 5000 and highwayid = '3' order by stationid","id":"38281"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:28:03 PM","query":"select * from highways where direction = 'NORTH' and highwayname = 'I-205'","id":"39677"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:37:04 PM","query":"select top 10 * from freeway_loopdata","id":"39678"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:41:15 PM","query":"select count(*) from freeway_loopdata where starttime like '2011-09-22%'","id":"39680"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:47:14 PM","query":"select * from freeway_loopdata where starttime like '2011-09-22%'","id":"39681"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:56:41 PM","query":"select c.stationid, c.length_mid, a.detectorid, a.starttime, a.speed from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'","id":"39683"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 8:57:28 PM","query":"select c.stationid, c.length_mid, a.detectorid, a.starttime, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'","id":"39684"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 9:04:29 PM","query":"select c.stationid, c.length_mid, a.detectorid, a.starttime, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c    where c.highwayid = '3'    and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'    order by a.starttime, a.detectorid","id":"39685"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 9:10:09 PM","query":"select a.starttime, a.detectorid, c.stationid, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'    order by a.starttime, a.detectorid","id":"39689"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 9:11:31 PM","query":"select a.starttime, a.detectorid, c.stationid, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'    order by a.starttime, a.detectorid;","id":"39693"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 9:26:25 PM","query":"select c.stationid, a.starttime, a.detectorid, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'    order by c.stationid, a.starttime;","id":"39719"},{"owner":"rlop2@pdx.edu","date":"3\/13\/2014 9:47:43 PM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'    order by c.stationid, a.starttime;","id":"39741"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:25:38 AM","query":"select top 10 starttime from Question1","id":"40814"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:45:35 AM","query":"select * from Question1 where speed is null","id":"40815"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:45:49 AM","query":"select * from Question1 where speed is not null","id":"40816"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:46:01 AM","query":"select * from Question1 where speed = 0","id":"40817"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:47:02 AM","query":"select * from Question1 where speed = 0 and speed is not null","id":"40818"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:47:18 AM","query":"select * from Question1 where speed <> 0 and speed is not null","id":"40819"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:50:42 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   and a.speed <> 0    and a.speed is not null   order by c.stationid, a.starttime;","id":"40820"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:53:00 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   and a.speed <> 0    and a.speed is not null   order by a.starttime;","id":"40821"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:53:15 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid   and a.speed <> 0    and a.speed is not null   order by a.starttime;","id":"40822"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:54:40 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'N'   and d.highwayname = 'I-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid   and a.speed <> 0    and a.speed is not null   order by c.stationid, a.starttime;","id":"40823"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:55:18 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'n'   and d.highwayname = 'i-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid   and a.speed <> 0    and a.speed is not null   ;","id":"251203"},{"owner":"rlop2@pdx.edu","date":"3\/14\/2014 5:57:25 AM","query":"select c.stationid, a.starttime, a.detectorid, c.upstream, c.downstream, c.length_mid, a.speed    from freeway_loopdata a, freeway_detectors b, freeway_stations c, highways d    where d.shortdirection = 'n'   and d.highwayname = 'i-205'   and c.highwayid = d.highwayid   and c.stationid = b.stationid    and b.detectorid = a.detectorid    and a.starttime like '2011-09-22%'   and a.speed <> 0    and a.speed is not null   ;","id":"251253"}];
  