Data Interview Qs - Lifetime of a customer
Lifetime of a customer
SQL Database Querying
Suppose you work for a large eCommerce company. You're given the below table schema for a table called 'orders' that highlights eCommerce purchases since the company's inception:
Table: orders
order_id | customer_id | created_at |
---|---|---|
unique id of the order | unique id of the customer associated with the given order |
the date the order was made |
Additionally you're provided the below table schema, called 'customers' containing the customer's unique id, as well as their name:
Table: customers
customer_id | name | address |
---|---|---|
unique id of the customer | name of the customer | shipping address of the customer |
Given the above, write a SQL query to return the name and address of your first 100 customers.
(Your company wants to send gift cards + thank you notes and needs this information).
Want the solutions? Upgrade to premium to access detailed solutions to each problem (including this one).
Was this email forwarded to you? You can join our list here to receive questions
Unsubscribe
Older messages
Similarity Matrix and Heat Chart
Friday, November 6, 2020
Data Interview Qs Similarity Matrix and Heat Chart Data Analysis Python Pandas Data Manipulation Data Visualization Similarity Matrix Heat Chart External Dataset Suppose you have the following dataset
Reverse it
Monday, November 2, 2020
Data Interview Qs Reverse it Python String Manipulation Suppose you're given an array of strings, s. Write a function using Python to take each string in the array and reverse it. For example: #
Querying types of widgets
Friday, October 30, 2020
Data Interview Qs Querying types of widgets SQL Database Querying Rank Function Window Function Suppose that each day widgets are produced on 3 assembly lines (A, B, and C) and eventually end up on one
Calorically dense foods
Wednesday, October 28, 2020
Data Interview Qs Calorically dense foods Data Analysis Python Pandas Data Manipulation Suppose you are given the following dataframe containing food, weight, and calories. You'll notice the foods
MSE vs. RMSE
Monday, October 26, 2020
Data Interview Qs MSE vs. RMSE Statistics Mean Squared Error Root Mean Squared Error Explain what Mean Squared Error (MSE) and Root Mean Squared Error (RMSE) are. What are the similarities between the
You Might Also Like
SRE Weekly Issue #423
Monday, May 6, 2024
View on sreweekly.com A message from our sponsor, FireHydrant: FireHydrant is now AI-powered for faster, smarter incidents! Power up your incidents with auto-generated real-time summaries,
⚠️ Avoiding AI Scams on Social Media — An Open Source Google Photos Alternative
Sunday, May 5, 2024
Also: Reviewing the Customizable Drop Mechanical Keyboard, and More! How-To Geek Logo May 5, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to
Daily Coding Problem: Problem #1432 [Medium]
Sunday, May 5, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This question was asked by Snapchat. Given the head to a singly linked list, where each node also has a “random”
PD#572 Good Ideas in Computer Science
Sunday, May 5, 2024
Ideas every programmer likes and why Garbage Collection and Object Oriented Programming don't count
RD#454 API Layer & Fetch Functions
Sunday, May 5, 2024
ixing API and UI code quickly leads to messy and unmaintainable code
The Shiny Toy Syndrome & Tiny macOS utility apps I love
Sunday, May 5, 2024
Lex launching its redesign, Raycast shares another monthly update packed with AI updates, prompts should be designed not engineered, and a lot more in this week's issue of Creativerly. Creativerly
Hyundai antes up $1B for AV startup Motional and Elon unplugs the Tesla Supercharger team
Sunday, May 5, 2024
Plus, layoffs come for Luminar, Fisker and Ola View this email online in your browser By Kirsten Korosec Sunday, May 5, 2024 Image Credits: Motional Welcome back to TechCrunch Mobility — your central
C#504 Adventures serializing absolutely everything in C#
Sunday, May 5, 2024
A fantastic journey porting Newtonsoft.Json to System.Text.Json
Sunday Digest | Featuring 'Which City Has the Most Billionaires in 2024?' 📊
Sunday, May 5, 2024
Every visualization published this week, in one place. Visual Capitalist Sunday Digest logo May 5, 2024 | View Online | Subscribe | VC+ The Best of This Week's Visuals Presented by Voronoi: The
The dark side of startup accelerators
Sunday, May 5, 2024
Plus: No easy solution to AI hallucinations View this email online in your browser By Anthony Ha Sunday, May 5, 2024 Image Credits: Bryce Durbin This Week, TechCrunch dug into the struggles at two