After being contacted by the recruiter, a technical phone screen was set up, along with an online coding test through HackerRank. Then I proceeded to the onsite interview stage, which involved four interviews with engineers and team leads. Three of those four interviews were technical in nature, with separate coding and database questions in each. The interviewers were friendly, engaged, and eager to answer any questions I had. All in all, the process took just over four hours and gave me a clear look at the culture and character of the company.

Implement a least-frequently-used cache.

Write SQL queries to find the daily active users and daily churn, given user activity tables that record the times when users performed actions on the website.