Skip to main content
All Questions

Monthly Post Success Analysis.

Easy

You are given the following tables:

post table:

post_idpost_dateuser_idinterfaceis_successful_post
integertimestampintegerstringboolean

post_user table

user_iduser_typeage
integerstringinteger

Write a SQL query that shows the total amount of successful post per user type in the current month (Assume current month is Nov 2023)

Your output should include the following columns: user_type, post_success (no. of successful posts), post_attempt (no. of posts), post_success_rate (range: 0.00 - 1.00). Order by descending success rate

Related courses

Course

BizOps & Strategy Interview Prep

Land your dream operations and strategy role at Google, Meta, Amazon, Uber, Microsoft, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice strategic decision-making, stakeholder management, product strategy, analytics, and behavioral interviews.

Course

Product Strategy Questions

Product strategy is fundamentally different in the AI era, and we'll tell you exactly how to approach these rounds effectively within the new rules.