Avatar

Correct answer by
Community Advisor

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.

View solution in original post