From the course: Practice It: Advanced SQL

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Try it: Extracting the year and month

Try it: Extracting the year and month - SQL Tutorial

From the course: Practice It: Advanced SQL

Try it: Extracting the year and month

(keyboard clacking) - [Instructor] In our second date manipulation challenge, you will need to calculate the total revenue earned for each month in the database, retrieve the month and year along with the total revenue. You can execute your code in the setup_script file under the date manipulation folder in your codespace. Go ahead and try it yourself, and in the next video, I'll walk you through my solution. Good luck.

Contents