Get Bonus Downloads Here.url

  1. Query 1 leverage FULL OUTER JOIN to calculate the percentages.mp4

  1.1 Q1.sql

  10. Query 10 Tracking update staychurnrevivenew.srt

  11. Query 11 Recommend reading lists based on friends' reading history.mp4

  11.1 Q11.sql

  12. Query 12 Percentage of users who have page crashed during view.srt

  13. Real FLAG data scientist SQL interview questions to practice.mp4

  13.1 Real_Interview_question_practice_1_Answer.sql

  13.3 Real_Interview_question_practice_2_Answer.sql

  13.5 Real_Interview_question_practice_3_Answer.sql

  2. Query 2 Use Window Function LAG to get difference between previous time.mp4

  2.1 Q2.sql

  3. Query 3 Window Function row_number() To get 5th date for each user.srt

  4. Query 4 Application of UNION ALLGROUP BYWindow Functions.mp4

  4.1 Q4.sql

  5. Query 5 Combine Group By and Window Function in one question using multi-layers.srt

  6. Query 6 Calculate acceptance rate in a Math way.mp4

  6.1 Q6.sql

  7. Query 7 Use Group By and Limit to get the top 1.srt

  8. Query 8 Group by Order By Limit Application 2 - highest answer rate.mp4

  8.1 Q8.sql

  9. Query 9 Fraction of advertisers that have at least 1 conversion.srt

  Bonus Resources.txt