Skip to content
A mini project, heavy on the SQL.
JavaScript CSS HTML
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Components
css
data
img
utils
App.js
README.md
_config.yml
arrrgs2.js
cREADME.md
ent.js
gold_medals.sqlite
index.html
index.js
ordMed.js
package-lock.json
package.json
server.js
sql.js
test2.txt
webpack.config.js

README.md

Real Results of the Olympics, Since 1896

My code

The file that I did all my work in is sql.js
You can look at the landing page but it is just a static GitPages page, not hooked up to a server right now.
My server at Digital Ocean can run it...when I get time to set it up.

Typical Functions

I appreciated working with such an interesting pile of data for this project. I learned a lot about the Summer and Winter Olympics!

These are the types of Select statements in this project:

  • createCountryTable
  • createGoldMedalTable
  • goldMedalNumber
  • mostSummerWins
  • mostWinterWins
  • bestDiscipline
  • bestSport
  • bestYear
  • bestEvent
  • numberMenMedalists
  • numberWomenMedalists
  • mostMedaledAthlete
  • orderedMedals
  • orderedSports
You can’t perform that action at this time.