SQL

Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days.

Data Scientist

Square

Netflix

Snap

Dropbox

Samsara

Zalando

Did you come across this question in an interview?

Your answer

Answers

Unlock Community Insights

Contribute your knowledge to access all answers

#Give&Take - Share to unlock

Unlock Community Insights

Contribute your knowledge to access all answers

#Give&Take - Share to unlock

Try Free AI Interview

Google logo

Google

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Strategy
Meta logo

Meta

Product Manager

Prepare for success with realistic, role-specific interview simulations.

Product Sense
Meta logo

Meta

Engineering Manager

Prepare for success with realistic, role-specific interview simulations.

System Design
Amazon logo

Amazon

Data Scientist

Prepare for success with realistic, role-specific interview simulations.

Behavioral
  • Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days.
  • How could you calculate the average transaction amount for customers who have made more than 10 purchases in the past 90 days?
  • What is the average amount of transactions for customers who have recently made more than 10 purchases in the last 90 days?
  • Tell me the average transaction amount for customers who have made more than 10 purchases within the last 90 days?
  • How would you determine the average transaction amount for customers with more than 10 purchases in the last 90 days?
  • What would be the average transaction amount for customers who made over 10 purchases within the last 3 months?
  • Can you provide me the average value of transaction for customers who have made over 10 purchases in the past 90 days?
  • How can we calculate the average transaction value for customers who have made more than 10 purchases in the last 90 days?
  • What is the average amount spent by customers who have made more than 10 purchases in the last 3 months?
  • What is the typical transaction amount for customers who have made more than 10 purchases in the past 90 days?
  • Can you tell me what the average transaction amount is for customers who have made over 10 purchases in the last 90 days?

Interview question asked to Data Scientists interviewing at Discord, Tesla, Square and others: Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days..