Simple SQL Task
Budget: $10 – $30 USD
Using the tables provided (Orders and Users - Attached csv's - have to create tables for them) , create the following queries (in Redshift friendly SQL if possible). Please explain your thought process through comments in the query:
1. Provide the total running sales by week for the period of 10/1/19-12/31/19, split out by order category and channel.
● Table names are Orders and Users
● Orders.completed_at is a UTC timestamp. Standardize to EST date (UTC – 5 hours), as the date of sale.
● Use the combination of Orders.order_category and user.signup_channel as the series
● Use Orders.order_total as the sales total
● Final output should have the following columns: Week, Signup Channel, Order Category, Total Running Sales
2. Provide the total running sales (i.e; total sales for the quarter as of that day) by day for the period of 10/1/19-12/31/19, tracked vs a goal rate:
● Use the following goal rates: $2,100,000 in sales in October, $2,500,000 in November, $3,300,000 in December
● Final output should have the following columns: Date, Total Running Sales, Goal, Variance from Goal
What I need:
a) the SQL queries
b) The output for question 1 and 2
To accept this job:
You need to
a) have availability to work on this right now
b) needs to be completed by 8 AM CST 6/28
This is a simple SQL task which I could complete myself very fast but I'm swamped. Please only apply if you know what you're doing as I don't want to spend more time correcting your work then doing it myself.
1. Provide the total running sales by week for the period of 10/1/19-12/31/19, split out by order category and channel.
● Table names are Orders and Users
● Orders.completed_at is a UTC timestamp. Standardize to EST date (UTC – 5 hours), as the date of sale.
● Use the combination of Orders.order_category and user.signup_channel as the series
● Use Orders.order_total as the sales total
● Final output should have the following columns: Week, Signup Channel, Order Category, Total Running Sales
2. Provide the total running sales (i.e; total sales for the quarter as of that day) by day for the period of 10/1/19-12/31/19, tracked vs a goal rate:
● Use the following goal rates: $2,100,000 in sales in October, $2,500,000 in November, $3,300,000 in December
● Final output should have the following columns: Date, Total Running Sales, Goal, Variance from Goal
What I need:
a) the SQL queries
b) The output for question 1 and 2
To accept this job:
You need to
a) have availability to work on this right now
b) needs to be completed by 8 AM CST 6/28
This is a simple SQL task which I could complete myself very fast but I'm swamped. Please only apply if you know what you're doing as I don't want to spend more time correcting your work then doing it myself.