Assignment Grade : A+
A dataset about English Premier League (EPL) matches has been provided, it is expected to create a MongoDB database for the dataset and write codes for the given queries.
- Show all the EPL teams involved in the season.
- How many matches were played on Mondays?
- Display the total number of goals “Liverpool” had scored and conceded in the season.
- Which teams have the most and least shots in the season?
- Who refereed the most matches?
- How many matches “Arsenal” won as the away team?
- Display all the matches that “Man United” lost.
- Display all matches that “Liverpool” won but were down in the first half.
- Write a query to display the final ranking of all the teams based on their total points.