Proj1 - SQL Query Assignment
Proj1 - SQL Query Assignment
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
- Attachments
-
- 13w259_Intro.pdf
- M259 Visualizing Information
- (6.98 MiB) Downloaded 313 times
George Legrady
legrady@mat.ucsb.edu
legrady@mat.ucsb.edu
-
- Posts: 9
- Joined: Tue Jan 17, 2012 4:40 pm
-
- Posts: 6
- Joined: Fri Jan 11, 2013 10:32 am
Re: Wk1- SQL Query Assignment
Here is the google doc link to my HW 1.
https://docs.google.com/file/d/0B0pO4Q- ... JnWkE/edit
Thanks!
Anastasiya Lazareva
https://docs.google.com/file/d/0B0pO4Q- ... JnWkE/edit
Thanks!
Anastasiya Lazareva
Re: Proj1 - SQL Query Assignment
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
I'll polish this up by the deadline.
https://docs.google.com/document/d/1vRK ... D9LvE/edit
Thanks,
Jay(Byungkyu) Kang
Re: Proj1 - SQL Query Assignment
Last edited by giovanni on Mon Jan 21, 2013 3:38 pm, edited 1 time in total.
-
- Posts: 2
- Joined: Fri Jan 11, 2013 10:35 am
Re: Proj1 - SQL Query Assignment
Here is the link to my Query Assignment:
https://docs.google.com/document/d/11Mg ... Rx30w/edit
Best,
Dana
https://docs.google.com/document/d/11Mg ... Rx30w/edit
Best,
Dana
-
- Posts: 5
- Joined: Tue Jan 15, 2013 1:22 pm
Re: Proj1 - SQL Query Assignment
This is my Proj1 - SQL Query Assignment link
https://docs.google.com/file/d/0BxTPhw- ... 5vdmM/edit
Yeu-Shuan Tang
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.