We're going to deviate just a bit from the CS50 coursework to delve into the world of data in local style.

Tag your most recent commit and put your new changes on a branch :-)

Steps:

1. Fork the following repository: https://github.com/MoMenne/metrolink-stl-data

2. Watch the following video on the basics how to work with an SQLite database

3. Brush up on your SQL. For this assignment you need to know about SELECTs and JOINs

4. We're going to ask some questions of the Metrolink transit data (hint: you can use the GTFS Documentation for meaning of all the fields)

   -> Question 1: Write a query to list all of the Metrolink stations (hint: all of the metrolink stations contain the words 'METROLINK STATION')

   -> Question 2: Write a query to list the total number of Metrolink stations (hint: all of the metrolink stations contain the words 'METROLINK STATION')

   -> Question 3: Write a query to list of all of the arrival times at the Shrewsbury Metrolink Stations.

5. Great now create a maven, unit-testable, Spring-enabled project (Feel free to reuse the (Greedy template)[https://github.com/MoMenne/launchcode-greedy-template])

6. Write a command line Java app that does the following things:

   1. Lists all of the Metrolink Stations
   2. Asks the user what station they are currently at
   3. Displays the amount time until the next arrives (aka 'The next train is arriving in {x} minutes')

7. After watching the following video use JDBC to query the metrolink.db database for the information you need to complete the application

Email me when you're done. Happy Coding!