Avatar

Level 2

Hey,

 

I have a scenario, that I am working on and kind of struck with that, any pointer will be appreciated.

 

  • Problem Statement: I have to fetch number of times a customer(count) have booked on same train, same day, same route.
  • Note: A customer can book multiple tickets on same train, same day, same route.

Output expected:

------------------------

Customer_id, Number_of_times_tickets_are_booked, train_number

 

Thanks in advance.

Sonika