[Chicago-talk] Database or Code?

Richard Reina richard at rushlogistics.com
Sat Jun 27 13:24:30 PDT 2009


I have to create a summary report out of a database that contains data about flight departures.

Example:

Chicago, IL Phoenix, AZ United

Each report has to summarize an airline's quantity of unique monthly flights  so that in the end I get:

Continental Airlines:
Chicago, IL to New York 21
New York, NY to Dallas 17
Houston, TX to Dallas 45
Chicago, IL to Phoenix 5

I can't find an SQL query that allows me to parse the data in such a way so I was wondering if I could get some general opinions on what would be the easiest way to do this in perl?


More information about the Chicago-talk mailing list