The prerecorded video interview on Hirevue.com felt quite impersonal, awkward, and monodirectional. You are shown a number of videos of a recruiter asking questions, and then you have 30 seconds to get ready before the webcam starts recording your answer. Throughout the process, you don't have any chance to ask questions about the job nor the company.

Usual HR Questions

What are some of the reasons you would be asked to intentionally run a marketing campaign at a net loss?

In general, what are some steps you could take to speed up a SQL query?

Please use the following schema for a simple customer database to write a query to get the email of the customer with the second-highest number of loyalty points:

• Table EMAIL, columns: id, email
• Table LOYALTY, columns: id, country, loyalty_tier, tenure, loyalty_points

Coding Challenge (Python):

Write a program that, given a URL, parses out and displays its constituent components. For the purpose of this challenge, a URL is in the form :///path?<query_string>. Print out the protocol, domain, and query_string, separated by commas.

A slightly more complex coding challenge (in Python) involving dictionaries.