Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL KPI Tracking by Month

Hard
SQL & Data ManipulationWindow FunctionsJoinsAggregations

Problem

Write a SQL query to track operational KPIs by month for Crédit Agricole Cib, joining transaction data with team and client tables, and calculate month-over-month changes.

Practicing as: Operations Manager interview at Crédit Agricole Cib

Hi, I'll play your Crédit Agricole Cib 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.

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
Next questions
Red Rock Government ServicesSQL for Operational PerformanceMediumSQL for Performance ReportingMediumSumitomo mitsui financial groupSQL for Operational PerformanceMedium