Quest

Window Functions in SQL

Join us on Discord
STATUS Past
TOTAL REWARDS
$1,000
REWARD AMOUNT
$2
STARTS (GMT +08:00)
ENDS (GMT +08:00)

Learning Outcomes

By the end of this tutorial, you will be able to:

  • Partition data and perform analysis on them
  • Fetch and rank data
  • Perform aggregate functions on frames
  • Understand LEAD/LAG clauses
  • Describe bounded and unbounded statements

Quest Details

Introduction

In this journey, we delve deeper into data analysis, exploring the concept of window functions, a powerful tool in data analysis that enables analysts to perform complex calculations efficiently and gain valuable insights from structured data.

By utilising these functions, we can analyse partitioned data, empowering analysts to efficiently uncover valuable insights and make well-informed decisions based on the data's patterns and trends.

You’ll need to complete Step 1 of the previous tutorial before proceeding with this tutorial as we’ll be utilising the datasets imported then for this tutorial.

Deliverables

This quest has 1 deliverable.

  1. A screenshot of your MySQL WorkBench after running a specific SQL query

This quest is part of a campaign so do check out other quests!

More Quests
Help Center Need help?

Find articles to support you through your journey or chat with our support team.

Help Center