Welcome candidate and thank you for taking the time to complete take-home challenge for our engineering position.
There are two sections to this take home with time estimates. Please complete both and keep to the time allotted. If you do not complete a section, add annotations for what you would do if you had had more time.
- Front End: A section on using React (1.5 hours)
- Database: A section on databases and SQL (0.5 hours)
You will have 1.5-ish hours to complete this portion of the assignment.
- To test knowledge of consuming APIs and handling responses
- Loading state and knowing where and how to make multiple API calls efficiently
- Add your Spotify client ID & secret to
config.js
- Note. Never add this type of config to version control. This would usually come from your build server.
Please build pages with the following:
- Fetch and display Released This Week songs
- Use the API path
new-releases
- Use the API path
- Fetch and display Featured Playlists
- Use the API path
featured-playlists
- Use the API path
- Fetch and display Browse genres
- Use the API path
categories
- Use the API path
- Surprise us with something if you have the time. Your choice.
- UI/UX for all elements, including previews (mobile responsive)
You will have a half hour to complete this portion of the assigment.
You have two tables in a database:
user_id | name | state |
---|---|---|
1 | Ella | IL |
2 | Albert | OR |
3 | Lucy | ME |
4 | Lou | NY |
5 | Amy | IA |
6 | Owen | ME |
7 | Bryce | ME |
8 | Clara | NY |
9 | Chad | OR |
10 | Arny | FL |
11 | Bob | FL |
state_id | st_code | state_name | population |
---|---|---|---|
1 | ME | Maine | 100 |
2 | NY | New York | 1000 |
3 | IA | Iowa | 300 |
4 | OR | Oregon | 250 |
5 | WY | Wyoming | 150 |
Please complete the following tasks. If any of the below are ill-defined, take a guess at the best approach to define any missing parts and indicate those assumptions in comments.
Please submit the answers in this file. Please write SQL statements that will:
- Show each user id with each state name and state code.
- Return the number of users per state.
- Return the state with the highest proportion of users.
Fix the SQL in this file.