Crack SQL Interview Question: Window Functions with Partition-By

Solving SQL questions with useful procedures

Aaron Zhu
Towards Data Science
7 min readSep 21, 2022

--

Photo by Marvin Meyer on Unsplash

In this article, we will go over a SQL question from an Amazon data science interview. Hope the procedure explained in this article would help you become more effective in writing SQL queries.

SQL Question:

Marketing Campaign

--

--

Senior Data Analyst | Always looking for new and exciting ways to turn complex data into actionable insights | https://www.linkedin.com/in/aaron-zhu-53105765/