Getting started

prerequisites

You need docker installed

instructions

• Run docker compose up in your terminal while in this repository. It takes a little while to import the data, so be patient.

• If everything is set up accordingly you should be able to access the database using the following credentials

host: localhost

port: 3306 (this can be changed in the docker-compose file)

username: sandbox-user

password: sandbox-password

database: sandbox

Questions

• What was the average call length on june 3rd 2016?
• Which dates did we enroll the most organisations?
• Users can be connected to more than one Organisation, find the name of the user that is connected to more than one organisation. Which countries are - those organisations in?
• Which customer have the most calls to swedish numbers that belong to our system?