Proj1 - SQL Query Assignment

glegrady
Posts: 160
Joined: Wed Sep 22, 2010 12:26 pm

Proj1 - SQL Query Assignment

Post by glegrady » 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
Attachments
13w259_Intro.pdf
M259 Visualizing Information
(6.98 MiB) Downloaded 221 times
George Legrady
legrady@mat.ucsb.edu


anastasiya
Posts: 6
Joined: Fri Jan 11, 2013 10:32 am

Re: Wk1- SQL Query Assignment

Post by anastasiya » Fri Jan 11, 2013 11:13 pm

Here is the google doc link to my HW 1.

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

Thanks!

Anastasiya Lazareva

bkang
Posts: 5
Joined: Fri Jan 11, 2013 10:32 am

Re: Proj1 - SQL Query Assignment

Post by bkang » Wed Jan 16, 2013 6:20 pm

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

giovanni
Posts: 24
Joined: Fri Oct 12, 2012 9:27 am

Re: Proj1 - SQL Query Assignment

Post by giovanni » Wed Jan 16, 2013 6:36 pm

Last edited by giovanni on Mon Jan 21, 2013 3:38 pm, edited 1 time in total.

danasolomon
Posts: 2
Joined: Fri Jan 11, 2013 10:35 am

Re: Proj1 - SQL Query Assignment

Post by danasolomon » Wed Jan 16, 2013 6:37 pm

Here is the link to my Query Assignment:

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

Best,
Dana

gstocking
Posts: 3
Joined: Fri Jan 11, 2013 10:36 am

Re: Proj1 - SQL Query Assignment

Post by gstocking » Wed Jan 16, 2013 8:50 pm


saeedm
Posts: 6
Joined: Tue Jan 15, 2013 1:21 pm

Re: Proj1 - SQL Query Assignment

Post by saeedm » Wed Jan 16, 2013 11:24 pm

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

ramon.rovirosa
Posts: 5
Joined: Tue Jan 15, 2013 1:22 pm

Re: Proj1 - SQL Query Assignment

Post by ramon.rovirosa » Thu Jan 17, 2013 12:21 am

Project 1
Ramon Rovirosa

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

ytang
Posts: 5
Joined: Fri Jan 11, 2013 10:37 am

Re: Proj1 - SQL Query Assignment

Post by ytang » Thu Jan 17, 2013 1:27 am

This is my Proj1 - SQL Query Assignment link

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


Yeu-Shuan Tang
Last edited by ytang on Tue Jan 22, 2013 12:35 pm, edited 4 times in total.

Post Reply