profile pic # Data Engineering @ Netflix
Upvote 0 Downvote
Identify Customers with Orders in Multiple Years Data Engineer @ Netflix Difficulty Hard

Write an SQL query to identify customers who have placed orders in multiple years. The orders table has columns order_id, customer_id, and order_date.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
SQL Coding Case for Gift Card Program Data Engineer @ Netflix Difficulty Medium

You are given two tables: gift_cards and transactions. The gift_cards table has columns card_id, issued_date, and initial_balance. The transactions table has columns transaction_id, card_id, transaction_date, and amount. Write an SQL query to calculate the remaining balance on each gift card as of the current date.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Metrics Case Study for Gift Card Program Data Engineer @ Netflix Difficulty Medium

As part of a hypothetical gift card program, you are asked to analyze the performance of the program. Key metrics to calculate include:

  1. Total number of gift cards issued
  2. Total value of gift cards issued
  3. Total value of transactions
  4. Average remaining balance per gift card Provide SQL queries for each metric.
Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Metric Design for Hiring Linguists to Produce Subtitles Data Scientist @ Netflix Difficulty Hard

Design a set of metrics to evaluate the effectiveness of hiring linguists to produce subtitles for Netflix shows. Explain why each metric is important and how it would be measured.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
SQL Queries to Find Time Difference Between Two Events Data Engineer @ Netflix Difficulty Medium

Given a table events with columns event_id, user_id, event_type, and event_time, write an SQL query to find the time difference between two specific types of events for each user. For example, calculate the time difference between 'login' and 'logout' events for each user.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Retrieve Top 5 Highest Salaries Data Engineer @ Netflix Difficulty Medium

Write an SQL query to retrieve the top 5 highest salaries from the employees table. The table has the following columns: employee_id, name, and salary.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Find Duplicate Email Addresses Data Engineer @ Netflix Difficulty Medium

Write an SQL query to find all email addresses that appear more than once in a users table with an email column.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
A/B Testing Case Study Data Scientist @ Netflix Difficulty Hard

You are tasked with designing an A/B test to evaluate whether hiring linguists to produce subtitles for shows increases user engagement. Describe the steps you would take to design and implement this A/B test, including how you would measure success.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Calculate Average Salary by Department Data Engineer @ Netflix Difficulty Medium

Write an SQL query to find the average salary of employees in each department from a table employees with columns department_id, employee_id, and salary.

Solution:

Please sign-in to view the solution