Back to all questionsSQL
Write a SQL query for the average transaction amount for customers who have made more than 10 purchases in the last 90 days.
Tags
Data Analyst
Marketer
General
Consider using GROUP BY with HAVING clause to filter aggregated data, and date functions to handle the time period constraint.
Companies Asking this quesiton.
Hard Difficulty
Hard questions require advanced understanding and critical thinking. Here, your problem-solving skills are key, as these questions often involve complex scenarios needing in-depth analysis and well-structured responses.
SQL question
SQL questions test your ability to work with relational databases. Demonstrate your proficiency in writing queries, understanding database design, optimizing performance, and extracting meaningful information from structured data.