.
@StrataScratch
ID:1420409230985601025
28-07-2021 15:42:51
701 Tweets
817 Followers
50 Following
StrataScratch #Day6 of 100 #100DaysOfCode
Another SQL prob from StrataScratch ,
Find the total number of downloads for paying and non-paying users by date. Include only records where non-paying customers have more downloads than paying customers.
platform.stratascratch.com/coding/10300-p…
StrataScratch Here is the solution:
Join the tables -> count for the distinct user_id for apple_users using case when and count total distinct users
Grouped by language .
duplicates may exist in the data , need to write a robust query.
platform.stratascratch.com/user/Khaja1Zaf…
I am doing coding on stratascratch where I myself leveraged coding skills in pyspark and sql.
StrataScratch is a coding platform where we can do coding for #dataengineer and other data domian.
#Lisbon #Portugal #dataengineer jobs