Previous question · 6
Top 3 Click Rates
mediumDatabase
Next question · 8
Artists' Top-10 Songs
easyDatabase
7. Ad Impressions Count
easy
Metasenior
ads_actions
| Column Name | Type |
|---|---|
| ad_exp_id | int64 |
| ad_name | object |
| cpc_rate | object |
| clicked_ad | int64 |
Expected Output Schema
| Column Name | Type |
|---|---|
| ad_name | object |
| ad_impressions | int64 |
Constraints
Hint 1
Hint 2
Hint 3
Roles
Data Analyst
Analytics Engineer
Data Engineer
Business Intelligence Engineer
Data Scientist
Product Manager
ML Engineer
AI Engineer
Companies
MetaLevels
senior
entry
Tags
sql
pandas
group-by
aggregation
sorting
Similar Questions
Ad CTR Calculationeasy
DatabaseTop 3 Click Ratesmedium
DatabaseArtists' Top-10 Songseasy
Database36 people are solving this problem
Loading editor for the selected language
Ln 1, Col 1
Program Output
DATAINTERVIEW
Interactive coding terminal
Python / pandas environment ready.
Type a command below or run code from the editor.
run scriptExecute the current editor contents
submitGrade the current editor contents against all solution test cases
python ("print hello world")Run an isolated Python command
helpShow all available commands