Media Arts and Technology

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

Here is the google doc link to my HW 1.

https://docs.google.com/file/d/0B0pO4Q- ... JnWkE/edit

Thanks!

Anastasiya Lazareva

Here's the link to my assignment 1.
I'll polish this up by the deadline.

https://docs.google.com/document/d/1vRK ... D9LvE/edit

Thanks,

Jay(Byungkyu) Kang

Link to my homework 1...

https://docs.google.com/document/d/1nJE ... pcv9w/edit

Here is the link to my Query Assignment:

https://docs.google.com/document/d/11Mg ... Rx30w/edit

Best,
Dana

Here is my summary.

https://docs.google.com/document/d/1Sdn ... 0swC8/edit

My project 1 writeup:
https://docs.google.com/document/d/18yV ... 97oMo/edit
-Saeed Mahani

Project 1
Ramon Rovirosa

Google Drive Link:
https://docs.google.com/document/d/1oII ... zoxms/edit

This is my Proj1 - SQL Query Assignment link

https://docs.google.com/file/d/0BxTPhw- ... 5vdmM/edit


Yeu-Shuan Tang