10.11.22 2nd Project in MySQL
The next step is to discuss 4 to 6 new MySQL queries that deliver more detailed information or are more complex in their design. Consider what we learned from the first assignment.
. Get more precise and detailed results.
. Do not limit your search to the Dewey classification as most items in the database are not Dewey, and it may be interesting to see why some are classified in Dewey and others not.
. Make sure that the results are true to your search, so that there is no ambiguous information, for instance Shaokang's "Headphones" referred to both a musical cd but also people checking out headphones in the library.
. Share the sequence of rewrites Its interesting for the class to share how you evolved your query from a less efficient to a more efficient version.
. Check the Library's online search tool to see if something you got is actually what it is: https://seattle.bibliocommons.com/v2/se ... New+Titles
. A database is an evolving thing. Our negotiations with the library resulted in getting data starting in 2006, and since then classifications, categories of things, or for instance, Itemtypes: https://www.mat.ucsb.edu/~g.legrady/aca ... mTypes.pdf have been added or been reduced. For instance, checkout of cdroms, VHS tapes, are rarely checked out today, but maybe they continue to be looked at.
wk3 - 10.11 .22 2nd Project in MySQL
wk3 - 10.11 .22 2nd Project in MySQL
George Legrady
legrady@mat.ucsb.edu
legrady@mat.ucsb.edu
Re: wk3 - 10.06 .22 MySQL queries studies
A report focused on two topics: SPL hotspot devices and 2019 No Late Fee Policy
Thinking on adding one topic more: about the legacy items.
Here's the of the report:
(Revised as of 10.17) Topic 01 results: Topic 02 results:
Thinking on adding one topic more: about the legacy items.
Here's the of the report:
(Revised as of 10.17) Topic 01 results: Topic 02 results:
Last edited by shaokang on Sun Oct 16, 2022 11:14 pm, edited 5 times in total.
-
- Posts: 11
- Joined: Fri Sep 23, 2022 10:04 am
Re: wk3 - 10.06 .22 MySQL queries studies
Here is my Week 3 Assignment write up that contains the SQL code:
For this week’s assignment, I explored three different topics. With each, I practiced and refined my SQL skills while querying a wide array of columns from the Seattle Public Library database. I was able to get a good understanding of the different metrics inside of the database and how they are all connected to each other.
Along with the CSV output files located here:
(they are all compiled into one numbers document on my Mac, but I am unable to upload this onto this forum) [*](updated 10/13 to include new CSV file names and descriptions of what the queries explore per email on 10/11)
Please describe in a short paragraph what your queries and results explore:For this week’s assignment, I explored three different topics. With each, I practiced and refined my SQL skills while querying a wide array of columns from the Seattle Public Library database. I was able to get a good understanding of the different metrics inside of the database and how they are all connected to each other.
- Topic 1: Books on War
- Topic 2: Items other than Books checkout out at the library
- Topic 3: Biographies on Athletes grouped by their sports
Along with the CSV output files located here:
(they are all compiled into one numbers document on my Mac, but I am unable to upload this onto this forum) [*](updated 10/13 to include new CSV file names and descriptions of what the queries explore per email on 10/11)
Last edited by briannagriffin on Thu Oct 13, 2022 11:10 am, edited 1 time in total.
-
- Posts: 8
- Joined: Tue Oct 04, 2022 10:24 am
Re: wk3 - 10.06 .22 MySQL queries studies
For this assignment, I analyzed several other (disconnected) questions. Specifically: (1) the aftermath of J.K. Rowling’s Twitter scandal; (2) items that were not returned to the library and associated check-in issues; and (3) general information regarding the busiest day in the SPL to date.
- Attachments
-
- jkrowling_by_date.csv
- (469 Bytes) Downloaded 76 times
-
- checkin_before_checkout_top5_difference.csv
- (54 Bytes) Downloaded 80 times
-
- checkin_before_checkout_monthly_2018.csv
- (136 Bytes) Downloaded 88 times
-
- checkin_before_checkout_10.csv
- (533 Bytes) Downloaded 84 times
-
- busiest_days.csv
- (184 Bytes) Downloaded 79 times
-
- busiest_day_top10_items.csv
- (235 Bytes) Downloaded 77 times
-
- busiest_day_details.csv
- (166 Bytes) Downloaded 82 times
-
- Assignment 2 Nikiforov.pdf
- (165.28 KiB) Downloaded 97 times
Last edited by ilianikiforov on Mon Oct 17, 2022 2:06 pm, edited 1 time in total.
-
- Posts: 15
- Joined: Tue Mar 29, 2022 3:30 pm
Re: wk3 - 10.06 .22 MySQL queries studies
The following is a link to my document where I have all my queries and explanations:
https://docs.google.com/document/d/1CK7 ... sp=sharing
Attached are the corresponding cvs files:
*The order below follows the order in the document*
https://docs.google.com/document/d/1CK7 ... sp=sharing
Attached are the corresponding cvs files:
*The order below follows the order in the document*
- Attachments
-
- Vinyl_Popularity.csv
- (3.31 KiB) Downloaded 91 times
-
- Stephen_King_All_Quarters.csv
- (1.16 KiB) Downloaded 77 times
-
- Stephen_King_4th_Quarter.csv
- (338 Bytes) Downloaded 78 times
-
- Carrie_Yearly_Checkouts.csv
- (168 Bytes) Downloaded 78 times
-
- PetSematary_Yearly_Checkouts.csv
- (150 Bytes) Downloaded 80 times
-
- TheShining_Yearly_Checkouts.csv
- (149 Bytes) Downloaded 76 times
-
- It_Yearly_Checkouts.csv
- (143 Bytes) Downloaded 81 times