LINK FOR TABLE CREATION AND INSERT QUERIES: https://drive.google.com/file/d/1g0QdHqc-HOLZGWIHjdbslwxKdygispjf/view?usp=s

[answerhappygod]

LINK FOR TABLE CREATION AND INSERT QUERIES:

QUESTION: 1- Create a new dim_users_extended table whichincludes information : a. whether the users have added a course b.when is the first time they added c. whether the users viewed thepro page d. how many times the users viewed the pro page e. Whetherthe user is an active user f. How many activities did the userperform g. whether the user took a trial h. last active date of theuser i. last activity of the user j. last used platform k. Can youpropose other columns that can be added to this table? (Example:last activity type, if the user completed a lesson, how manylessons, ...)
3. Based on the newly created dim_users_extended table, answerthe following questions:
a. What is the average number of pro page views
b. What is the % trial
c. What is the country with the highest DAU?
d. What is the platform with the lowest Lesson Completion rate?(Use the last used platform)
e. The average number of lessons completed
f. Lesson completers from pro page viewers? What do younotice?
g. Elaborate the funnel that needs to be checked with the KPIsthat need to be tracked.
h. What other parts of the funnel do you think are missing, andneed to be added to the dataset? What are the KPIs that need to betracked?
DELIVERABLE: pdf with questions and answers + sql code used toget results PLEASE NEED THIS ASAP