Data Interview Qs - Twitch view times by creators
Twitch view times by creators
SQL Database Querying
Suppose you are working for a company like Twitch.tv. Twitch.tv is a live streaming platform, where creators (e.g. the people creating content on the live streams) can receive donations from viewers.
Using the tables below -- write a SQL query to find the top content creators by total watch time, filtering for users who watch the stream on the same day the stream was created.
Table 1: creatorStreams
| Column Name | Data Type | Description |
|---|---|---|
| creator_id | integer | unique id of content creator |
| stream_id | integer | unique id of stream |
| date | string | format is "YYYY-MM-DD", date of stream session |
| length | integer | length of streaming session |
Table 2: viewWatches
| Column Name | Data Type | Description |
|---|---|---|
| viewer_id | integer | unique id of viewer |
| session_id | integer | unique use session id |
| date | string | format is "YYYY-MM-DD", date of the view |
| stream_id | integer | unique session id of stream |
| mins_viewed | integer | total number of the viewer watched the stream |
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Simulating future stock prices using Monte Carlo methods
Monday, October 19, 2020
Data Interview Qs Simulating future stock prices using Monte Carlo methods Data Analysis Python Pandas Data Manipulation Monte Carlo Simulation External Dataset Using Monte Carlo methods, simulate
Monotonic array
Monday, October 19, 2020
Data Interview Qs Monotonic array Python Data Structures Arrays Can you check if a given array containing n integers is monotonic? Your function should return "true" if it is monotonic and
Life expectancy
Monday, October 19, 2020
Data Interview Qs Life expectancy Statistics Probability Theory Suppose you're analyzing a population of 100000 people, and you're trying to understand life expectancy. Within this population
Joining to get total sales, a SQL problem
Monday, October 12, 2020
Data Interview Qs Joining to get total sales, a SQL problem SQL Database Querying Suppose you work for a retail company that has a database containing two tables, one called 'orders', and one
Formatting dirty data
Friday, October 9, 2020
Data Interview Qs Formatting dirty data Data Analysis Python Pandas Data Manipulation Suppose you have the following dataset which contains which contains (1st tab) a list of items purchased by a given
You Might Also Like
Software Testing Weekly - Issue 220
Saturday, May 18, 2024
Software Testing Conferences 📚 View on the Web Archives ISSUE 220 May 18th 2024 COMMENT Welcome to the 220th issue! Have you ever been to a testing conference? They're a great way to learn about
📶 Is a Cellular iPad Worth It? — How to Prevent YouTube From Taking Over Your Screensaver
Saturday, May 18, 2024
Also: This Robot Vacuum Can Clean Stairs, and More! How-To Geek Logo May 18, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by
Weekend Reading — Objection-oriented programming
Saturday, May 18, 2024
This week we find a power-up box, replace GitHub Actions with Maven XMLs, avoid the worst website in the world, revisit RTO policies, “listen” to OpenAI employees, watch our Slack private messages, do
Daily Coding Problem: Problem #1445 [Easy]
Saturday, May 18, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Jane Street. The United States uses the imperial system of weights and measures, which
You don’t have to take our word for it…
Saturday, May 18, 2024
You can probably tell how excited we are to re-launch our Gigantic courses – which bring on-demand product management training for today's modern Product Managers and Product Leaders. In fact, we
🐍 New Python tutorials on Real Python
Saturday, May 18, 2024
Hey there, There's always something going on over at realpython.com as far as Python tutorials go. Here's what you may have missed this past week: What Is the __pycache__ Folder in Python? In
Visualized | Life Expectancy by Region (1950-2050F) 📊
Saturday, May 18, 2024
This map shows life expectancy at birth for key global regions, from 1950 to 2050F. View Online | Subscribe Presented by Voronoi: The App Where Data Tells the Story FEATURED STORY Life Expectancy by
New Wi-Fi Vulnerability Enables Network Eavesdropping via Downgrade Attacks
Saturday, May 18, 2024
THN Daily Updates Newsletter cover The DevSecOps Playbook: Deliver Continuous Security at Speed ($19.00 Value) FREE for a Limited Time A must-read guide to a new and rapidly growing field in
🐍 New Python tutorials on Real Python
Saturday, May 18, 2024
Hey there, There's always something going on over at realpython.com as far as Python tutorials go. Here's what you may have missed this past week: What Is the __pycache__ Folder in Python? In
Toward 'local' AI w/ Apple's new chip
Saturday, May 18, 2024
faster than the cloud ☁️