Media Arts and Technology

Posted: **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

Posted: **Mon Oct 03, 2022 1:57 pm**

Codes and analysis are in this PDF

Assignment 01 Shaokang.pdf: (440.03 KiB) Downloaded 472 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 460 times

longestBorrowDate.csv: (1.07 KiB) Downloaded 419 times

shortestBorrowDate.csv: (714 Bytes) Downloaded 441 times

Q2 result:

mostPopularClassByBookNumber.csv: (927 Bytes) Downloaded 439 times

Q3 results:

mostPopularClassByItemNumber.csv: (937 Bytes) Downloaded 452 times

leastPopularClassByItemNumber.csv: (618 Bytes) Downloaded 454 times

leastPopularBigClassByItemNumber.csv: (104 Bytes) Downloaded 459 times

Q4 results:

booksWithMostCopies.csv: (128 Bytes) Downloaded 433 times

Posted: **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:

Posted: **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?

Posted: **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 469 times

Here are the CSV output files:

Query1.csv: (244 Bytes) Downloaded 438 times

Query2.csv: (243 Bytes) Downloaded 429 times

Query3A.csv: (1.46 KiB) Downloaded 456 times

Query3B.csv: (1.46 KiB) Downloaded 475 times

Query4.csv: (1.37 KiB) Downloaded 460 times

Media Arts and Technology

wk2 - 09.29.22 1st Project in MySQL

wk2 - 09.29.22 1st Project in MySQL

Re: wk2 - 09.29.22 MySQL queries studies

Re: wk2 - 09.29.22 MySQL queries studies

Re: wk2 - 09.29.22 MySQL queries studies

Re: wk2 - 09.29.22 MySQL queries studies