Skip to content

Instantly share code, notes, and snippets.

@mcivorsteiner

mcivorsteiner/peek_sql_data_challenge_submission_template.md

Last active June 8, 2023 15:56
Show Gist options
  • Save mcivorsteiner/00d4c5a3108845b16f17059047c3f78a to your computer and use it in GitHub Desktop.
Save mcivorsteiner/00d4c5a3108845b16f17059047c3f78a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
peek_sql_data_challenge_submission_template.md

Peek SQL Code Challenge Submission

Applicant Name

[your name here]

Additional Information You Would Seek Out

There are many ways of modeling and approaching this problem, and there are many unknown factors that could determine which approach is better. Please list additional factors/information you would seek out.

[list all additional factors/information you would seek out]

Assumptions Made

List all assumptions being made (regarding the above missing information or otherwise)

[list your assumptions here]

Data Model Schema

Map out the data model schema you believe is best given the information you were provided and the assumptions you made. Feel free to organize however you like, no need to spend time formatting it to make it pretty, you can just have the table names and list of columns in each table.

[your chosen data model schema here]

Source Tables -> Desired Data Model - SQL

Provide the SQL to transform the source data tables to your desired data model. This can be organized however you like, just add notes describing each snippet of SQL.

[Your SQL here]

Data Analyst Needs - SQL

For each data analyst need, write the SQL to return the data from the example. The SQL should be based on your data model schema, not using source data tables.

1) Number of accounts with specific feature enabled over time

For each day from 2/3/21 to 2/10/21, list the number of accounts that had the timeslot_caps feature flag enabled at the beginning of the day

[Your SQL here]

2) Number of accounts that have feature activated and deactivated by day

For each day from 2/3/21 to 2/10/21, list the number of accounts that had the timeslot_caps "activated" on that day, and number "deactivated" on that day.

[Your SQL here]

3) List of all accounts with enabled status for a feature, and last change date

List all accounts, whether they currently have the ios_waivers feature enabled, and the day it was changed to that status

[Your SQL here]

Any Other Thoughts/Comments

Any additional comments/thoughts you have regarding the challenge or your submission, any thoughts on other tools you would consider using given the problem, etc.

[Your thoughts/comments here]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment