Calculating quarterly moving average of revenue in SQL
Calculating quarterly moving average of revenue in SQL
SQL Database Querying Window Function Moving Average
Suppose you're working with a large conglomerate and are trying to aggregate revenue across all divisions to highlight the overall trend. The table you're querying off of is called allRevenue, sample schema is shown below.
Table: allRevenue
date | revenue | division |
---|---|---|
2018-01-20 | 15000000 | chemicals |
2019-02-21 | 120000 | agriculture |
2019-04-09 | 390900 | pharma |
Given the above, can you write a SQL query that calculates 4-quarter rolling average revenue, cut by each quarter? The output query should only have 2 columns: 'quarter' and 'revenue' (where revenue is the trailing 4-quarter average). You can assume you have access to a function similar to this.
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Best ad group
Wednesday, March 31, 2021
Data Interview Qs Best ad group Data Analysis Python Pandas Data Manipulation External Dataset Given the following dataset, can you identify the top 3 performing ad groups? Explain how you evaluated
Snowblowing a driveway
Monday, March 29, 2021
Data Interview Qs Snowblowing a driveway Calculus Rate of change General logic Suppose it starts snowing at a constant rate. Eventually, at 9am an individual comes out of their house with a snowblower
Classifying customer frequency
Friday, March 26, 2021
Data Interview Qs Classifying customer frequency Data Analysis Python Pandas Data Manipulation Data Visualization Histogram External Dataset Given the following dataset, classify customer value based
Employee salary history
Wednesday, March 24, 2021
Data Interview Qs Employee salary history SQL Database Querying Window Function Lead Function You are given the following table containing historical employee salaries for company XYZ: Table:
Active users on a messaging application
Monday, March 22, 2021
Data Interview Qs Active users on a messaging application Data Analysis Python Pandas Data Manipulation External Dataset Here is a table containing information from a P2P messaging application. The
You Might Also Like
This Week's Daily Tip Roundup
Sunday, May 19, 2024
Missed some of this week's tips? No problem. We've compiled all of them here in one convenient place for you to enjoy. Happy learning! iPhoneLife Logo View In Browser Your Tip of the Day is
Reading Beyond the Hype: Some Observations About OpenAI and Google’s Announcements
Sunday, May 19, 2024
Google vs. OpenAI is shaping up as one of the biggest rivarly of the generative AI era. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Final Reminder: Apple Issues "Update Now Warning"
Sunday, May 19, 2024
I wanted to send a final reminder — if you haven't already updated your iPhone to iOS 17.5, we strongly recommend you do so today. This is also your last chance to get access to our iOS 17.5 In-
Second Brain/Attention/Find Your Books
Sunday, May 19, 2024
Recomendo - issue #411 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Kotlin Weekly #407
Sunday, May 19, 2024
ISSUE #407 19th of May 2024 Hello Kotliners! The Google I/O just finished this week with a huge announcement for us, with Google supporting now Kotlin Multiplatform on Android, and the KotlinConf will
Learn How to Use AI to Reach Your Full Potential, newsletterest1!
Sunday, May 19, 2024
3 Ways AI Can Help Your Writing ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Software Testing Weekly - Issue 220
Saturday, May 18, 2024
Software Testing Conferences 📚 View on the Web Archives ISSUE 220 May 18th 2024 COMMENT Welcome to the 220th issue! Have you ever been to a testing conference? They're a great way to learn about
📶 Is a Cellular iPad Worth It? — How to Prevent YouTube From Taking Over Your Screensaver
Saturday, May 18, 2024
Also: This Robot Vacuum Can Clean Stairs, and More! How-To Geek Logo May 18, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by
Weekend Reading — Objection-oriented programming
Saturday, May 18, 2024
This week we find a power-up box, replace GitHub Actions with Maven XMLs, avoid the worst website in the world, revisit RTO policies, “listen” to OpenAI employees, watch our Slack private messages, do
Daily Coding Problem: Problem #1445 [Easy]
Saturday, May 18, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Jane Street. The United States uses the imperial system of weights and measures, which