ros wrote:
> I am completely clueless about the following query.
>
> - - Where does the longest flight go?
That depends on where it is leaving from. From where I am I think it is
Australia.

>
> This relates to 2 tables and the sql scripts are as follows:
>
> CREATE TABLE `my-database`.`flight_profiles` (
> `FLP_ID` decimal(8,0) default NULL,
> `FLT_NUMB` decimal(4,0) default NULL,
> `PRICE_CODE` varchar(50) default NULL,
> `FLT_FROM` varchar(50) default NULL,
> `FLT_TO` varchar(50) default NULL,
> `depart` datetime default NULL,
> `arrive` datetime default NULL
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
>
> CREATE TABLE `my-database`.`cities` (
> `IATA_CODE` varchar(3) default NULL,
> `COU_IATA_CODE` varchar(2) default NULL,
> `NAME` varchar(40) default NULL
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
> Would appreciate help with this one. Also I am just building my SQL
> and MySQL skills so any recommendations on resources like books or
> online resources would be most welcome.
>
> Thanks
>
> ros
The tables are very interesting, but what do you want us to help with?