联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp

您当前位置:首页 >> Database作业Database作业

日期:2019-08-29 10:28

Data Analyst Exercise

Please be prepared to spend 45-60 minutes on this exercise. You will need access a

computer with internet connection and a SQL workbench of your choice. The

database is Postgres. Please email back your answers and the amount of time you

spent.

Postgres Database Connection Details

PGUSER=thistle_data

PGPASS=Water.Lemon.Town

PGDB=thistle

PGPORT=5432

PGHOST=thistle-sample.crysldnompz3.us-west-2.rds.amazonaws.com

The two schemas are public and thistle_web

thistle_web.subscriptions_subscription contains subscription data for a given

customer. Customers can have more than 1 subscription.

thistle_web.subscriptions_subscriptioncancellation.subscription_id is the

foreign key for thistle_web.subscriptions_subscription.id

A row is created in subscriptions_subscription when someone enters the

checkout flow.

subscriptions_subscription.date_initialized refers to the timestamp when a

customer signs up for a subscription.

There is also an etl_calendar table in the public schema

Please provide the SQL queries, results and written context for the following

requests

.

Please write a query for how many customers started the subscription flow each

month as well as the number and % that completed.

.

What is the signup success rate (# of people signing up for a subscription vs. all

people who enter the checkout flow) for meat vs. veg plans?

.

Please calculate how many customers cancel within 14 days of signing up.

.

Please calculate retention by weekly cohort. Result should look like the following:


版权所有:留学生编程辅导网 2020 All Rights Reserved 联系方式:QQ:99515681 微信:codinghelp 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。 站长地图

python代写
微信客服:codinghelp