Sunday, April 24, 2011
Today is sunday. Sunday is not friday. Thus, it is possible to have a good night sky, and that is indeed the case. If you don't get what I mean, you need a more detailed introduction to NUSH Astro Club. In fact, the sky's awesome enough to see the Southern Cross, Crux.
Anyway, I was doing CS project, due on Sat.
if( if(type="Arr",1,-1) = cast(timestampdiff(
minute, date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00' ) /
abs(timestampdiff(minute, date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00' ) )
as signed integer ), "Present","Absent") Presence
from flight fta, fly fya, pilot pla, airline al
where fya.pilot_airline = al.code and
fya.fly_date = fta.date and
fya.fly_flight_no = fta.flight_no and
fya.pilot_staff_id = pla.staff_id and
fya.pilot_airline = pla.p_airline_name and
abs(timestampdiff(
minute,date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00')) =
(select min(abs(timestampdiff(
minute,date_add(date,INTERVAL ftb.a_time HOUR_SECOND), '2011-04-04 12:00:00')))
from flight ftb, fly fyb, pilot plb
where fyb.fly_date = ftb.date and
fyb.fly_flight_no = ftb.flight_no and
fyb.pilot_staff_id = plb.staff_id and
fyb.pilot_airline = plb.p_airline_name and
pla.p_airline_name = plb.p_airline_name and
pla.staff_id = plb.staff_id )
union
select al.code Code,al.name Airlines,null ID, aca.tail_no Pilot_Plane,
if( if(type="Arr",1,-1) = cast(timestampdiff(
minute, date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00' ) /
abs(timestampdiff(minute, date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00' ))
as signed integer ), "Present","Absent") Presence
from flight fta, aircraft aca, airline al
where al.code = aca.airline_name and
fta.plane_tailno = aca.tail_no and
abs(timestampdiff(
minute,date_add(date,INTERVAL fta.a_time HOUR_SECOND), '2011-04-04 12:00:00')) =
(select min(abs(timestampdiff(
minute,date_add(date,INTERVAL ftb.a_time HOUR_SECOND), '2011-04-04 12:00:00')))
from flight ftb, aircraft acb
where ftb.plane_tailno = acb.tail_no and
aca.tail_no = acb.tail_no)
order by Code, ID, Pilot_Plane;