[Chicago-talk] Database or Code?
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.
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:
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