App Clickthrough Rate (CTR) — Facebook Asked SQL Question

Solving SQL Question asked by Facebook

Suraj Mishra

·

Follow

3 min read

·

Sep 7, 2022

--

Share

Originally Published in https://asyncq.com/

Introduction

• In this article we will solve Apply Clickthrough Rate SQL question which is asked by Facebook as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been given event table , this table consist of app_id , events along with timestamp.
• All we have to do is to calculate CTR for each app id for year 2022

• Click through rate is defined as how many time app_id was clicked when it was shown to user. For example if we app_id was shown 4 time and user clicked it 2 time then the CTR % would be 50%

• For given input table we can see app_id 123 was shown 2 times and and user…