Data Interview Qs - Top keywords for advertiser spend

InterviewQs

Top keywords for advertiser spend

SQL Windowing Functions Aggergation

Forward this email to a friend or colleague and challenge them to solve it.

Hi, 

You’re given a table called total_ad_spend_by_keywords with the following schema:

Column Name Description Data Type
keyword Keyword the ad is running against string
ad_id Unique ID of the advert integer
advertiser_id Unique ID of the advertiser integer
total_spend Total spend against the given keyword, ad_id, and advertiser combination integer

Given this, write SQL a query to return the keywords with the most spend, and provide the top 5 advertisers advertising against those keywords.


 

You’ve accumulated 201 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.


Was this email forwarded to you? You can join our list here to receive questions

How did you like today's question?

15411 Boischatel, Montreal, QC, H9H1Y7, Canada
Don't want to get these emails anymore? We'll forgive you if you unsubscribe

Older messages

User messaging

Thursday, October 14, 2021

Data Analysis, Python, Pandas, Data Manipulation, InterviewQs User messaging Data Analysis Python Pandas Data Manipulation Forward this email to a friend or colleague and challenge them to solve it. Hi

Type I vs Type II error

Monday, October 11, 2021

Statistics, Machine Learning, InterviewQs Type I vs Type II error Statistics Machine Learning Forward this email to a friend or colleague and challenge them to solve it. Hi, In statistical hypothesis

Arrays of arrays

Friday, October 8, 2021

Python, Data Structures, Arrays, InterviewQs Arrays of arrays Python Data Structures Arrays Forward this email to a friend or colleague and challenge them to solve it. Hi, Given two sorted arrays A and

Employees who are managers

Wednesday, October 6, 2021

SQL, Database Querying, InterviewQs Employees who are managers SQL Database Querying Forward this email to a friend or colleague and challenge them to solve it. Hi, You're trying to understand how

Create a model to predict bicycle ridership

Monday, October 4, 2021

Python, Pandas, Data Analysis, External Dataset, Linear Regression, Data Visualization, InterviewQs Create a model to predict bicycle ridership Python Pandas Data Analysis External Dataset Linear

You Might Also Like

Launch pad decongestion

Monday, May 6, 2024

We've got some very cool news from Hubble Networks, which became the first company to connect a Bluetooth chip to a satellite. View this email online in your browser By Aria Alamalhodaei Monday,

Daily Coding Problem: Problem #1433 [Medium]

Monday, May 6, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Nest. Create a basic sentence checker that takes in a stream of characters and

Want to become an AI consultant?

Monday, May 6, 2024

My take on this new industry ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Visualized | Interest Rate Forecasts for Advanced Economies 📈📉

Monday, May 6, 2024

In this graphic, we show the IMF's interest rate forecast for the US, Europe, the UK, and Japan for the next five years ahead. View Online | Subscribe Presented by Voronoi: The App Where Data Tells

⚙️ Apple AI updates

Monday, May 6, 2024

Plus: X AI stories & YouTube "skip to the good part" ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Unlock Time Series Data, FTC Chair Joins StrictlyVC & More

Monday, May 6, 2024

TechCrunch Events Roundup | May 6 TechCrunch Events TechCrunch events roundup Unlock the power of time series data with industry experts from AWS and InfluxDB on May 16. Join us next week for this free

Deepdive – product strategy, AI, leadership, emotional intelligence

Monday, May 6, 2024

Earlier this month, we presented our Virtual edition of INDUSTRY: The Product Conference, featuring some of our favorite product leaders worldwide. There were seven great keynote presentations, live

Noonification: The Human Roots of Rising Fascism

Monday, May 6, 2024

Top Tech Content sent at Noon! Get Algolia: AI Search that understands How are you, @newsletterest1? 🪐 What's happening in tech today, May 6, 2024? The HackerNoon Newsletter brings the HackerNoon

Code Story - Apr 24

Monday, May 6, 2024

Welcome to the April addition of the podcast newsletter. Please enjoy, and check out any of the episodes you might have missed below. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

Dell turns 40: How a teen founded a tech giant

Monday, May 6, 2024

Samsung's new entry-level OLED TV; Google Threat Intelligence -- ZDNET ZDNET Tech Today - US May 6, 2024 placeholder Dell turns 40: How a teenager transformed $1000 worth of PC parts into a tech