Page 1 of 1
wk2 - 09.29.22 1st Project in MySQL
Posted: Fri Sep 16, 2022 7:47 am
by glegrady
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
Re: wk2 - 09.29.22 MySQL queries studies
Posted: Mon Oct 03, 2022 1:57 pm
by shaokang
Codes and analysis are in this PDF
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:
Q2 result:
Q3 results:
Q4 results:
Re: wk2 - 09.29.22 MySQL queries studies
Posted: Mon Oct 03, 2022 11:38 pm
by nataliadubon
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:
Re: wk2 - 09.29.22 MySQL queries studies
Posted: Tue Oct 04, 2022 11:22 am
by ilianikiforov
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?
Re: wk2 - 09.29.22 MySQL queries studies
Posted: Tue Oct 04, 2022 11:37 am
by briannagriffin
My reasoning and SQL code are located on the below PDF:
Here are the CSV output files: