Skip to main content
All Questions

Monthly Post Success Analysis.

Easy
Unlock detailed company stats for this questionUpgrade

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

Interview experiences

1 shared
LinkedIn · a year ago
"It was amazing. Had lovely conversations and it was amazing. I got nervous towards the end and the panel understood hence was not rejected at last round"
BizOps & Strategy · Senior / L5

Related questions

Post Success By Age Group.Post Success After FailurePost Success By Interface.

Related courses

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.

Course

Data Analyst Interview Prep

Ace your data analyst interviews—whether you're targeting product, marketing, or business analyst roles. Tackle real take-home case studies, sharpen your technical and dashboarding skills, and get strategies from interviewers at top tech companies and startups.