/frontend-test

Engineering Take Home Test

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)

Front End Section

You will have 1.5-ish hours to complete this portion of the assignment.

Goals/Outcomes

  • To test knowledge of consuming APIs and handling responses
  • Loading state and knowing where and how to make multiple API calls efficiently

Pre-requisites

  • 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.

Requirements

Please build pages with the following:

Task 1

  • Fetch and display Released This Week songs
    • Use the API path new-releases

Task 2

  • Fetch and display Featured Playlists
    • Use the API path featured-playlists

Task 3

  • Fetch and display Browse genres
    • Use the API path categories

Task 4 (Optional)

  • Surprise us with something if you have the time. Your choice.

What's Already Been Done

  • UI/UX for all elements, including previews (mobile responsive)

Useful info

Screenshots

screenshot-desktop screenshot-mobile

Database Section

You will have a half hour to complete this portion of the assigment.

You have two tables in a database:

ourdata.users

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

ourdata.geo

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

Your Mission

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.

Task 1

Please submit the answers in this file. Please write SQL statements that will:

  1. Show each user id with each state name and state code.
  2. Return the number of users per state.
  3. Return the state with the highest proportion of users.

Task 2

Fix the SQL in this file.