Data Interview Qs - Data Interview Questions: Problem #53
Reddit comment activity
SQL Database Querying
Suppose you're working for Reddit as an analyst. Reddit is trying to optimize its server allocation per subreddit, and you've been tasked with figuring out how much comment activity happens once a post is published.
Use your intuition to select a timeframe to query the data as well as how you would want to present this information to the partnering team. The solution will be a SQL query with assumptions that you would need to state if this was asked in an interview. You have the following tables:
Table: posts
| Column Name | Data Type | Description |
|---|---|---|
| id | integer | id of the post |
| publisher_id | integer | id the user posting |
| score | integer | score of the post |
| time | integer | post publish time in unixtime |
| title | string | title of the post |
| deleted | boolean | is the post deleted? |
| dead | boolean | is the post active? |
| subreddit_id | integer | id of the subreddit |
Table: comments
| Column Name | Data Type | Description |
|---|---|---|
| id | integer | id of the comment |
| author_id | integer | id of the commenter |
| post_id | integer | id of the post the comment is nested under |
| parent_comment | integer | id of parent comment that comment is nested under |
| deleted | integer | is comment deleted? |
Given the above, write a SQL query to highlight comment activity by subreddit.
This problem is intended to test how you can think through vague/open-ended questions.
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one, as well as the questions you've previously received).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Data Interview Questions: Problem #55
Tuesday, August 25, 2020
Data Interview Qs Rolling 9s for $50 Statistics Probability Theory Expected Value Suppose you are playing a game where there are two fair six-sided dice, and every time you roll the dice and they add
Data Interview Questions: Problem #57
Tuesday, August 25, 2020
Data Interview Qs Student GPA SQL Database Querying Provided the following tables, write a SQL query to pull the average GPA (grade_point in table) by subject for completed classes. Table 1:
Data Interview Questions: Problem #59
Tuesday, August 25, 2020
Data Interview Qs Judging smiles Statistics Box Plot Data Visualization External Dataset It's often hypothesized (and backed in some studies) that smiling can increase leniency, or reduce the
Data Interview Questions: Problem #60
Tuesday, August 25, 2020
Data Interview Qs Most common part of speech using NLTK Python NLP NLTK Library Arrays Given the following text, can you find the most frequent part of speech (POS) used in the text below? To solve
Data Interview Questions: Problem #51
Monday, August 3, 2020
Data Interview Qs Exponential distribution question Statistics Exponential Distribution A given car has a number of miles it can run before its battery is depleted, where the number of miles are
You Might Also Like
📧 EF Core Migrations: A Detailed Guide
Saturday, May 18, 2024
EF Core Migrations: A Detailed Guide Read on: my website / Read time: 10 minutes BROUGHT TO YOU BY Low-code Framework for .NET Devs Introducing Shesha, a brand new, open-source, low-code
Slack is under attack … and you don’t want that
Friday, May 17, 2024
Plus: OpenAI is not aligned with its Superalignment team View this email online in your browser By Christine Hall Friday, May 17, 2024 Good afternoon, and welcome back to TechCrunch PM. We made it to
Ilya Sutskever leaves OpenAI - Weekly News Roundup - Issue #467
Friday, May 17, 2024
Plus: Apple is close to using ChatGPT; Microsoft builds its own LLM; China is sending a humanoid robot to space; lab-grown meat is on shelves but there is a catch; hybrid mouse/rat brains; and more! ͏
SWLW #599: Surfing through trade-offs, How to do hard things, and more.
Friday, May 17, 2024
Weekly articles & videos about people, culture and leadership: everything you need to design the org that makes the product. A weekly newsletter by Oren Ellenbogen with the best content I found
💾 There Will Never Be Another Windows XP — Why Ray Tracing is a Big Deal in Gaming
Friday, May 17, 2024
Also: What to Know About Google's Project Astra, and More! How-To Geek Logo May 17, 2024 Did You Know The very first mass-manufactured drinking straw was made of paper coated in wax; the straw was
It's the dawning of the age of AI
Friday, May 17, 2024
Plus: Musk is raging against the machine View this email online in your browser By Haje Jan Kamps Friday, May 17, 2024 Image Credits: Google Welcome to Startups Weekly — Haje's weekly recap of
Daily Coding Problem: Problem #1444 [Medium]
Friday, May 17, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Yahoo. Recall that a full binary tree is one in which each node is either a leaf node,
(Not) Sent From My iPad
Friday, May 17, 2024
The future of computing remains frustrating (Not) Sent From My iPad By MG Siegler • 17 May 2024 View in browser View in browser I tried. I really did. I tried to put together and send this newsletter
iOS Dev Weekly - Issue 661
Friday, May 17, 2024
What's the word on everyone's lips? 🅰️👁️ View on the Web Archives ISSUE 661 May 17th 2024 Comment Did you catch Google I/O this week? It's Always Interesting to see what the Android
Your Google Play recap from I/O 2024
Friday, May 17, 2024
Check out all of our latest updates and announcements Email not displaying correctly? View it online May 2024 Google Play at I/O 2024 Check out the Google Play keynote to discover the latest products