Dear All

I have table that has name | flightdate| from | to | flight number | booking datetime|
Name1 : 10/10/2013: london| frankfurt| 100| 05/10/2013 10:00pm
Name2 : 10/10/2013: london| frankfurt| 100| 05/10/2013 11:00pm
Name1 : 10/10/2013: london| frankfurt| 100| 02/11/2013 6:00pm

how can i get number of rows that has flown same sector...