Discover and read the best of Twitter Threads about #100daysofpythoncode

Most recents (1)

Preparing for a #MachineLearning or #DataScience interview?

One retweet — one technical question.

Categories: SQL, coding (Python) and algorithms

Let’s start!

#100DaysOfMLCode #100DaysOfPythonCode
= SQL =

Suppose we have the following schema:
* Ads(ad_id, camplaign_id, status)
* Events(event_id, ad_id, source, event_type, date, hour)

status: active, inactive
event_type: impression (ad is shown), click (ad is clicked), conversion (app is installed)
Write a query to return:

- The number of active ads
Read 52 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!