DataDriven
LearnPracticeInterviewDiscussDailyJobs

Find the total revenue (sum of total_amount) and average transaction amount for each user

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium

Problem

Find the total revenue (sum of total_amount) and average transaction amount for each user. Label them total_revenue and avg_transaction.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons