Travel booking Count

[SonikaDutta]

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 

[Manoj_Kumar_ · Accepted solution]

Hello @SonikaDutta 

Assuming your bookings table has the informaton you have given and the cardinality from recipient is a 1:N.

The right way to do is group by train_number and do a count of your primary key.

If this is not the case,then please share the schema relationships.

[Sukrity_Wadhwa]

Hi @SonikaDutta,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!