Find out the number of routes with the greatest number of flights (trips).
Notes.
A - B and B - A are to be considered DIFFERENT routes.
Use the Trip table only.
Trip(trip_no, id_comp, plane, town_from, town_to, time_out, time_in).
ADVICE:- scheduled flights are operated daily; the duration of any flight is less than 24 hours; town_from <> town_to;
Mike hello again its like the other execerise u asked for ddl , i dont have it just have tu built a query to get the result 4 , i tried a lot of queris but got different numbers i dont know what is the problem.
Thanks for ur time
Thanks u sir , i appreciate and sorry for wasting ur time.
U make it look so easy and ur solution its very easy to understand. Thank u.
If i have more questions i will ask u