Data Analyst代写、代写SQL编程语言、代写SQL、代做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: