Challenge: Compute Fortnightly Changes
Explore how to calculate fortnightly percentage changes using SQL queries in PostgreSQL. This lesson guides you through implementing time-based data analysis by computing the percentage difference over two-week intervals, helping you practice window functions and gain deeper skills in data manipulation using SQL.
We'll cover the following...
We'll cover the following...
Problem statement
An example of calculating the week-over-week percentage difference is great for practicing PostgreSQL. We may think computing it through some other ...