wk2 - 09.29.22 1st Project in MySQL

Post Reply
glegrady
Posts: 203
Joined: Wed Sep 22, 2010 12:26 pm

wk2 - 09.29.22 1st Project in MySQL

Post by glegrady » Fri Sep 16, 2022 7:47 am

9.29.22 1st Project in MySQL

Post 4 to 6 MySQL queries with the data in csv format and a description of why you chose these queries
George Legrady
legrady@mat.ucsb.edu

shaokang
Posts: 8
Joined: Fri Sep 23, 2022 10:07 am

Re: wk2 - 09.29.22 MySQL queries studies

Post by shaokang » Mon Oct 03, 2022 1:57 pm

Codes and analysis are in this PDF
Assignment 01 Shaokang.pdf
(440.03 KiB) Downloaded 54 times
1.Find the single longest and shortest borrow time
2.What’s the number of books of different dewey classes (Items of same bibNumber count once) ?
3.What’s the number of items of different dewey classes (Items of same bibNumber count multiple times according to their number of copies)?
4.Which book have the most number of copies? (Top 10)

Queries Files: https://drive.google.com/file/d/1OPdsjA ... sp=sharing

Q1 results:
longestBorrowDate (contaminated).csv
(425 Bytes) Downloaded 39 times
longestBorrowDate.csv
(1.07 KiB) Downloaded 36 times
shortestBorrowDate.csv
(714 Bytes) Downloaded 39 times
Q2 result:
mostPopularClassByBookNumber.csv
(927 Bytes) Downloaded 38 times
Q3 results:
mostPopularClassByItemNumber.csv
(937 Bytes) Downloaded 32 times
leastPopularClassByItemNumber.csv
(618 Bytes) Downloaded 38 times
leastPopularBigClassByItemNumber.csv
(104 Bytes) Downloaded 44 times
Q4 results:
booksWithMostCopies.csv
(128 Bytes) Downloaded 47 times
Attachments
Queries.pdf
(43.18 KiB) Downloaded 43 times
Last edited by shaokang on Mon Oct 10, 2022 9:17 pm, edited 2 times in total.

nataliadubon
Posts: 15
Joined: Tue Mar 29, 2022 3:30 pm

Re: wk2 - 09.29.22 MySQL queries studies

Post by nataliadubon » Mon Oct 03, 2022 11:38 pm

Link to document displaying my code and results:
** Copyable queries are located at the BOTTOM/END of the document**
https://docs.google.com/document/d/1854 ... sp=sharing

I decided to base all of my queries this week on October and horror tagged mediums.


CVS files attached:
Attachments
MAT265_ Week 2 (1).pdf
(444.64 KiB) Downloaded 40 times
Question6.csv
(235 Bytes) Downloaded 41 times
Question5.csv
(210 Bytes) Downloaded 31 times
Question4.csv
(57.86 KiB) Downloaded 45 times
Question3.csv
(364 Bytes) Downloaded 42 times
Question2.csv
(12.63 KiB) Downloaded 33 times
Question1.csv
(1.48 KiB) Downloaded 42 times
Last edited by nataliadubon on Thu Dec 01, 2022 7:52 pm, edited 2 times in total.

ilianikiforov
Posts: 8
Joined: Tue Oct 04, 2022 10:24 am

Re: wk2 - 09.29.22 MySQL queries studies

Post by ilianikiforov » Tue Oct 04, 2022 11:22 am

Just a few exploratory queries out of general interest:
1. Interest in data science books over time
2. Interest in math books over time
3. Did people boycott J.K. Rowling's books following her Twitter scandal?
4. Does interest in political science books rise during election years?
Attachments
polisci_by_year.csv
(259 Bytes) Downloaded 47 times
math_by_year.csv
(250 Bytes) Downloaded 35 times
jk_rowling_scandal.csv
(634 Bytes) Downloaded 34 times
ds_by_year.csv
(93 Bytes) Downloaded 47 times
Assignment 1_Nikiforov.pdf
(191.64 KiB) Downloaded 44 times

briannagriffin
Posts: 11
Joined: Fri Sep 23, 2022 10:04 am

Re: wk2 - 09.29.22 MySQL queries studies

Post by briannagriffin » Tue Oct 04, 2022 11:37 am

My reasoning and SQL code are located on the below PDF:
Week 2 Assignment - SQL Queries.pdf
(57.31 KiB) Downloaded 54 times
Here are the CSV output files:
Query1.csv
(244 Bytes) Downloaded 39 times
Query2.csv
(243 Bytes) Downloaded 35 times
Query3A.csv
(1.46 KiB) Downloaded 38 times
Query3B.csv
(1.46 KiB) Downloaded 42 times
Query4.csv
(1.37 KiB) Downloaded 46 times

Post Reply