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
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)
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
- The number of active ads
