MySQL : Total Revenue

Database

Environment Specifications & Instructions

Type of Database

MySQL

Database Name to be used

OrderDb

Problem Statement

Write a SQL query to calculate the total revenue for each month and year based on the order$\_$date and retrieve the year, month, and total$\_$revenue.

The result should be in the increasing order of the year and the month.

Table Description:

Column Name: year, month, total$\_$revenue

orders