Hi Johanna, looks like nobody review your project yet, so I had a go at it.
I’m obviously no expert here (I just finished the project myself), but here are my remarks:
- The queries we accurate and well formatted
- The report was clear and spot on
- The concepts seem to be well understood
I have one “critic” concerning the bonus question:
- the way you queried produces a result grouped in months and segments, but with a large number of segments this would not be a readable result (especially if you increase the time frame as well) as the number of rows would become too important.
I am not sure that my solution (basically pivoting the table to have the months as columns and grouping the segments) is really however.
Overall, excellent job. Keep up!