Proj1 - SQL Query Assignment
Posted: Thu Jan 10, 2013 1:23 pm
Review previous student query projects for the format of how to ask an interesting query. Once you have one, please post by replying to this post. Your query should include:
Data Mining Question
The Sql Query
Explanation of the query
Processing Time
Comment & Analysis
Previous examples use an older, less efficient tables (transactional, etc.). Your query should be in "spl0" table and looking into "inraw"
Christo de Clerck https://docs.google.com/document/d/1fK4 ... n_US&pli=1
Matthew Willse https://docs.google.com/document/d/1Hpe ... n_US&pli=1
Following their model, post an interesting query with the following segments:
Last year examples: http://www.mat.ucsb.edu/forum/viewtopic.php?f=56&t=160
Data Mining Question
The Sql Query
Explanation of the query
Processing Time
Comment & Analysis
Previous examples use an older, less efficient tables (transactional, etc.). Your query should be in "spl0" table and looking into "inraw"
Christo de Clerck https://docs.google.com/document/d/1fK4 ... n_US&pli=1
Matthew Willse https://docs.google.com/document/d/1Hpe ... n_US&pli=1
Following their model, post an interesting query with the following segments:
Last year examples: http://www.mat.ucsb.edu/forum/viewtopic.php?f=56&t=160