Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Top Three Transactions Per Account

Medium
SQL & Data ManipulationWindow FunctionsDate FunctionsRankingAsked 1 times

Problem

Write a SQL query using a window function to find the top three highest-value transactions for each customer account over the last 30 days at Sumitomo mitsui financial group.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Sumitomo mitsui financial group Data Analyst Interview QuestionsSumitomo mitsui financial group Interview Questions
Next questions
Galileo ProcessingTop Transactions Per CardholderHardMillimanSQL Window Functions Top 3MediumAlly FinancialTop Customers Last 30 DaysMedium
0 / ~200 words