Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL for Branch Transaction Declines

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsRanking

Problem

Write a SQL query to identify branches with declining transaction volume over the last 3 months, including month-over-month change and ranking by decline.

Practicing as: Operations Manager interview at Industrial and Commercial Bank of China

Hi, I'll play your Industrial and Commercial Bank of China interviewer for the Operations Manager role. Candidates describe these interviews as mostly positive and moderately difficult, so expect me to be friendly and conversational. Take your time with the question above and answer like we're in the room.

Take this as a live interview session →

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
Industrial and Commercial Bank of China Operations Manager Interview Questions
Next questions
Union BankSQL for Branch Transaction MetricsMediumHuntington BancsharesSQL for Declining AccuracyMediumFis globalSQL for Three-Month Volume DecreasesHard