8 Replies Latest reply: Oct 16, 2017 5:08 AM by Andrew Walker RSS

    Top n data

    Arshad Hussain

      1st table    

      AirportRevenue in US$Flights 
      Grand Total57,732,036,7571,068,164
      Maya-Maya Airport
      24,082,856,986467,982
      Asmara International Airport
      16,156,464,665280,323
      Cairo International Airport
      10,150,200,885188,215
      Tripoli International Airport
      3,460,486,57248,468
      Cape Town International Airport
      2,335,975,37144,474
      Calgary International Airport
      772,424,866  14,234
      Vancouver International Airport
      505,395,81211,452
      Ontario International Airport
      268,231,60113,016

       

      2nd table extracted from 1st table(Top 3 Airports)    

      AirportRevenue in US$Flights 
      Grand Total50,389,522,535936,520
      Maya-Maya Airport
      24,082,856,986467,982
      Asmara International Airport
      16,156,464,665280,323
      Cairo International Airport
      10,150,200,885188,215

       

      I am having problem in acquiring the result of 2nd table. Can anyone help me? I want to see any top n airports with revenue & flight detail as mentioned in the 2nd table.