@rdale
Rick Dale
-
Published Meta Report for COGS 127
For COGS 127 students: The following list of reports will help you decide on the basic ... -
Published COGS 127 - Example Replacement of Strings with Numbers
/* This looks trickier than it is... we are g...int) as whyAsNumber from orionwill.fakedata -
Published COGS 127 - Search for Commas to Count Items
/* What if you want to count how many items t...pped, morningenergy from orionwill.fakedata -
Published COGS 127 - Searching Strings and Casting into Numbers
/* This query searches for a string inside a ...fast, morningenergy from orionwill.fakedata -
Published COGS 127: Example Age Binning (Mood Data)
SELECT round(age/10)*10 as ageBin, avg...ple_mood_data GROUP BY ageBin ORDER BY ageBin -
Published COGS 127: SELECT, GROUP BY Mood Example
SELECT avg(age) as averageAge, avg(moo...merced.rdale_sample_mood_data GROUP BY gender -
Published COGS 127: Splicing out GPS coordinates
SELECT cast(substr(gps,1,(strpos(gps,','))...n, Jose, and Jansen for the sample data! */ -
Published COGS 127: The WHERE clause
select * from rdale.some_run_data where sub...ine search criteria in the "where clause." */ -
Published COGS 127: SUM with GROUP BY
select sum(miles) as total_distance, subt...un entry I have */ group by subtype LIMIT 100 -
Published COGS 127: AVG with GROUP BY
select avg(miles) as average_distance, su...bad '0' run entry I have */ group by subtype -
Published COGS 127: AVG and COUNT for a scatterplot
select count(subtype) as total_count, avg...' /* clear bad '0' entry */ group by subtype -
Published COGS 127: COUNT with GROUP BY
select count(subtype) as total_count, sub...' /* clear bad '0' entry */ group by subtype -
Published Sample Report from Run Data
A quick demonstration of some plotting and SQL features. -
Published Map Visualization of UCM Locations
Locations generated with crowdsourcing GPS app with students in COGS 127 -
Published LatLong Coordinates of COGS 127 UCM Locations
Students independently used a mapping tool to identify coordinates of interesting locat... -
Published Miles by Subtype
SELECT subtype,avg(miles) from rdale.some_run_data where subtype!='0' group by subtype -
Published Distribution of Consonant Inventories in Language Families
select family,f1_a,count(f1_a) as n_instances...having count(f1_a)>1 order by family,f1_a asc