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
wk2 - 09.29.22 1st Project in MySQL
wk2 - 09.29.22 1st Project in MySQL
George Legrady
legrady@mat.ucsb.edu
legrady@mat.ucsb.edu
Re: wk2 - 09.29.22 MySQL queries studies
Codes and analysis are in this PDF
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: Q2 result: Q3 results: Q4 results:
1.Find the single longest and shortest borrow time2.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: Q2 result: Q3 results: Q4 results:
- Attachments
-
- Queries.pdf
- (43.18 KiB) Downloaded 98 times
Last edited by shaokang on Mon Oct 10, 2022 9:17 pm, edited 2 times in total.
-
- Posts: 15
- Joined: Tue Mar 29, 2022 3:30 pm
Re: wk2 - 09.29.22 MySQL queries studies
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:
** 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 98 times
-
- Question6.csv
- (235 Bytes) Downloaded 91 times
-
- Question5.csv
- (210 Bytes) Downloaded 85 times
-
- Question4.csv
- (57.86 KiB) Downloaded 99 times
-
- Question3.csv
- (364 Bytes) Downloaded 90 times
-
- Question2.csv
- (12.63 KiB) Downloaded 95 times
-
- Question1.csv
- (1.48 KiB) Downloaded 94 times
Last edited by nataliadubon on Thu Dec 01, 2022 7:52 pm, edited 2 times in total.
-
- Posts: 8
- Joined: Tue Oct 04, 2022 10:24 am
Re: wk2 - 09.29.22 MySQL queries studies
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?
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 92 times
-
- math_by_year.csv
- (250 Bytes) Downloaded 80 times
-
- jk_rowling_scandal.csv
- (634 Bytes) Downloaded 81 times
-
- ds_by_year.csv
- (93 Bytes) Downloaded 94 times
-
- Assignment 1_Nikiforov.pdf
- (191.64 KiB) Downloaded 89 times
-
- Posts: 11
- Joined: Fri Sep 23, 2022 10:04 am
Re: wk2 - 09.29.22 MySQL queries studies
My reasoning and SQL code are located on the below PDF:
Here are the CSV output files: