[Chicago-talk] Database or Code?
warren.lindsey at gmail.com
Sat Jun 27 15:41:08 PDT 2009
Whoops, missed by carrier.
Select airline, depart, arrive, count(*) from flights group by airline, depart, arrive;
From: imran javaid <imranjj at gmail.com>
Sent: Saturday, June 27, 2009 3:55 PM
To: Chicago.pm chatter <chicago-talk at pm.org>
Subject: Re: [Chicago-talk] Database or Code?
There are many ways to slice and dice this. One is to build a hash of hashes:
On 6/27/09, Richard Reina <richard at rushlogistics.com> wrote:
> 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:
> 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?
> Chicago-talk mailing list
> Chicago-talk at pm.org
Sent from my mobile device
Chicago-talk mailing list
Chicago-talk at pm.org
More information about the Chicago-talk