Queries For Partitioning Test
[edit] Queries used for Partitioning test
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-10-06' AND '2002-10-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-10-06' AND '2002-10-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-7-01' AND '2002-7-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-7-06' AND '2002-7-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-11-01' AND '2002-11-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-11-06' AND '2002-11-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-9-01' AND '2002-9-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-9-06' AND '2002-9-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-12-01' AND '2002-12-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-12-06' AND '2002-12-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-8-01' AND '2002-8-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-8-06' AND '2002-8-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-3-01' AND '2002-3-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-3-06' AND '2002-3-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-6-01' AND '2002-6-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-6-06' AND '2002-6-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-5-01' AND '2002-5-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-5-06' AND '2002-5-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-1-01' AND '2002-1-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-1-06' AND '2002-1-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-4-01' AND '2002-4-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-4-06' AND '2002-4-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-2-01' AND '2002-2-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2002-2-06' AND '2002-2-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-10-01' AND '2003-10-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-10-06' AND '2003-10-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-7-01' AND '2003-7-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-7-06' AND '2003-7-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-11-01' AND '2003-11-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-11-06' AND '2003-11-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-9-01' AND '2003-9-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-9-06' AND '2003-9-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-12-01' AND '2003-12-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-12-06' AND '2003-12-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-8-01' AND '2003-8-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-8-06' AND '2003-8-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-3-01' AND '2003-3-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-3-06' AND '2003-3-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-6-01' AND '2003-6-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-6-06' AND '2003-6-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-5-01' AND '2003-5-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-5-06' AND '2003-5-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-1-01' AND '2003-1-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-1-06' AND '2003-1-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-4-01' AND '2003-4-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-4-06' AND '2003-4-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-2-01' AND '2003-2-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2003-2-06' AND '2003-2-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-10-01' AND '2001-10-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-10-06' AND '2001-10-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-7-01' AND '2001-7-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-7-06' AND '2001-7-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-11-01' AND '2001-11-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-11-06' AND '2001-11-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-9-01' AND '2001-9-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-9-06' AND '2001-9-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-12-01' AND '2001-12-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-12-06' AND '2001-12-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-8-01' AND '2001-8-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-8-06' AND '2001-8-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-3-01' AND '2001-3-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-3-06' AND '2001-3-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-6-01' AND '2001-6-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-6-06' AND '2001-6-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-5-01' AND '2001-5-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-5-06' AND '2001-5-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-1-01' AND '2001-1-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-1-06' AND '2001-1-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-4-01' AND '2001-4-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-4-06' AND '2001-4-10'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-2-01' AND '2001-2-04'
SELECT COUNT(*) FROM flightstats WHERE FlightDate BETWEEN '2001-2-06' AND '2001-2-10'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-10-01' AND FlightNum = '1017' AND DepTime = '2002-10-01 09:01:00' AND Origin = 'DTW' AND Dest = 'MBS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-10-01' AND FlightNum = '1017' AND DepTime = '2002-10-01 06:03:00' AND Origin = 'EWR' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-10-01' AND FlightNum = '1019' AND DepTime = '2002-10-01 07:56:00' AND Origin = 'BDL' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-10-01' AND FlightNum = '102' AND DepTime = '2002-10-01 18:57:00' AND Origin = 'MSP' AND Dest = 'MDW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-10-01' AND FlightNum = '102' AND DepTime = '2002-10-01 12:08:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-07-01' AND FlightNum = '1015' AND DepTime = '2002-07-01 21:52:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-07-01' AND FlightNum = '1019' AND DepTime = '2002-07-01 08:09:00' AND Origin = 'RDU' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-07-01' AND FlightNum = '102' AND DepTime = '2002-07-01 18:50:00' AND Origin = 'MSP' AND Dest = 'DCA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-07-01' AND FlightNum = '102' AND DepTime = '2002-07-01 12:39:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-07-01' AND FlightNum = '1020' AND DepTime = '2002-07-01 19:05:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-11-01' AND FlightNum = '1011' AND DepTime = '2002-11-01 06:57:00' AND Origin = 'MSP' AND Dest = 'GRR'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-11-01' AND FlightNum = '1012' AND DepTime = '2002-11-01 09:57:00' AND Origin = 'GRR' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-11-01' AND FlightNum = '1018' AND DepTime = '2002-11-01 20:56:00' AND Origin = 'DTW' AND Dest = 'GRR'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-11-01' AND FlightNum = '1018' AND DepTime = '2002-11-01 18:47:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-11-01' AND FlightNum = '1019' AND DepTime = '2002-11-01 08:06:00' AND Origin = 'PVD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-09-01' AND FlightNum = '1020' AND DepTime = '2002-09-01 19:13:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-09-01' AND FlightNum = '1021' AND DepTime = '2002-09-01 12:58:00' AND Origin = 'IAH' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-09-01' AND FlightNum = '1022' AND DepTime = '2002-09-01 12:58:00' AND Origin = 'MSP' AND Dest = 'PVD'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-09-01' AND FlightNum = '1023' AND DepTime = '2002-09-01 17:43:00' AND Origin = 'BDL' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-09-01' AND FlightNum = '1025' AND DepTime = '2002-09-01 09:12:00' AND Origin = 'MSP' AND Dest = 'ONT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-12-01' AND FlightNum = '1012' AND DepTime = '2002-12-01 09:53:00' AND Origin = 'GRR' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-12-01' AND FlightNum = '1018' AND DepTime = '2002-12-01 21:20:00' AND Origin = 'DTW' AND Dest = 'GRR'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-12-01' AND FlightNum = '1018' AND DepTime = '2002-12-01 18:43:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-12-01' AND FlightNum = '1019' AND DepTime = '2002-12-01 08:06:00' AND Origin = 'PVD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-12-01' AND FlightNum = '102' AND DepTime = '2002-12-01 13:02:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-08-01' AND FlightNum = '1015' AND DepTime = '2002-08-01 21:04:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-08-01' AND FlightNum = '1019' AND DepTime = '2002-08-01 08:55:00' AND Origin = 'RDU' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-08-01' AND FlightNum = '102' AND DepTime = '2002-08-01 18:48:00' AND Origin = 'MSP' AND Dest = 'DCA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-08-01' AND FlightNum = '102' AND DepTime = '2002-08-01 12:18:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-08-01' AND FlightNum = '1020' AND DepTime = '2002-08-01 18:58:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-03-01' AND FlightNum = '102' AND DepTime = '2002-03-01 13:30:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-03-01' AND FlightNum = '1022' AND DepTime = '2002-03-01 13:12:00' AND Origin = 'MSP' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-03-01' AND FlightNum = '1023' AND DepTime = '2002-03-01 17:37:00' AND Origin = 'IAH' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-03-01' AND FlightNum = '1025' AND DepTime = '2002-03-01 06:55:00' AND Origin = 'MDW' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-03-01' AND FlightNum = '1025' AND DepTime = '2002-03-01 09:27:00' AND Origin = 'MSP' AND Dest = 'ONT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-06-01' AND FlightNum = '101' AND DepTime = '2002-06-01 09:30:00' AND Origin = 'MSP' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-06-01' AND FlightNum = '1015' AND DepTime = '2002-06-01 19:04:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-06-01' AND FlightNum = '1019' AND DepTime = '2002-06-01 08:15:00' AND Origin = 'IAD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-06-01' AND FlightNum = '102' AND DepTime = '2002-06-01 12:20:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-06-01' AND FlightNum = '1020' AND DepTime = '2002-06-01 18:44:00' AND Origin = 'MSP' AND Dest = 'SAT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-05-01' AND FlightNum = '1008' AND DepTime = '2002-05-01 13:52:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-05-01' AND FlightNum = '101' AND DepTime = '2002-05-01 06:53:00' AND Origin = 'MKE' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-05-01' AND FlightNum = '101' AND DepTime = '2002-05-01 09:30:00' AND Origin = 'MSP' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-05-01' AND FlightNum = '1010' AND DepTime = '2002-05-01 16:07:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-05-01' AND FlightNum = '1015' AND DepTime = '2002-05-01 19:30:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-01-01' AND FlightNum = '0032' AND DepTime = '2002-01-01 12:32:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-01-01' AND FlightNum = '0039' AND DepTime = '2002-01-01 12:29:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-01-01' AND FlightNum = '0041' AND DepTime = '2002-01-01 14:37:00' AND Origin = 'MSP' AND Dest = 'LAS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-01-01' AND FlightNum = '0042' AND DepTime = '2002-01-01 10:27:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-01-01' AND FlightNum = '0043' AND DepTime = '2002-01-01 17:15:00' AND Origin = 'MSP' AND Dest = 'SEA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-04-01' AND FlightNum = '102' AND DepTime = '2002-04-01 14:23:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-04-01' AND FlightNum = '1022' AND DepTime = '2002-04-01 13:33:00' AND Origin = 'MSP' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-04-01' AND FlightNum = '1023' AND DepTime = '2002-04-01 19:53:00' AND Origin = 'IAH' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-04-01' AND FlightNum = '1025' AND DepTime = '2002-04-01 06:54:00' AND Origin = 'MDW' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-04-01' AND FlightNum = '1025' AND DepTime = '2002-04-01 09:19:00' AND Origin = 'MSP' AND Dest = 'ONT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-02-01' AND FlightNum = '0031' AND DepTime = '2002-02-01 19:42:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-02-01' AND FlightNum = '0032' AND DepTime = '2002-02-01 12:25:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-02-01' AND FlightNum = '0039' AND DepTime = '2002-02-01 12:31:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-02-01' AND FlightNum = '0041' AND DepTime = '2002-02-01 14:26:00' AND Origin = 'MSP' AND Dest = 'LAS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2002-02-01' AND FlightNum = '0042' AND DepTime = '2002-02-01 10:22:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-10-01' AND FlightNum = '1008' AND DepTime = '2003-10-01 13:22:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-10-01' AND FlightNum = '101' AND DepTime = '2003-10-01 09:25:00' AND Origin = 'MSP' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-10-01' AND FlightNum = '1010' AND DepTime = '2003-10-01 12:21:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-10-01' AND FlightNum = '1016' AND DepTime = '2003-10-01 10:26:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-10-01' AND FlightNum = '102' AND DepTime = '2003-10-01 18:39:00' AND Origin = 'MSP' AND Dest = 'LGA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-07-01' AND FlightNum = '101' AND DepTime = '2003-07-01 06:56:00' AND Origin = 'ORD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-07-01' AND FlightNum = '1011' AND DepTime = '2003-07-01 17:17:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-07-01' AND FlightNum = '1011' AND DepTime = '2003-07-01 13:28:00' AND Origin = 'STL' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-07-01' AND FlightNum = '1012' AND DepTime = '2003-07-01 08:56:00' AND Origin = 'DTW' AND Dest = 'MBS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-07-01' AND FlightNum = '1012' AND DepTime = '2003-07-01 05:54:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-11-01' AND FlightNum = '102' AND DepTime = '2003-11-01 13:20:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-11-01' AND FlightNum = '1020' AND DepTime = '2003-11-01 18:41:00' AND Origin = 'MSP' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-11-01' AND FlightNum = '1024' AND DepTime = '2003-11-01 15:15:00' AND Origin = 'MSP' AND Dest = 'LGA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-11-01' AND FlightNum = '1029' AND DepTime = '2003-11-01 17:49:00' AND Origin = 'BDL' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-11-01' AND FlightNum = '1029' AND DepTime = '2003-11-01 21:04:00' AND Origin = 'MSP' AND Dest = 'ONT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-09-01' AND FlightNum = '101' AND DepTime = '2003-09-01 06:58:00' AND Origin = 'ORD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-09-01' AND FlightNum = '1011' AND DepTime = '2003-09-01 17:51:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-09-01' AND FlightNum = '1011' AND DepTime = '2003-09-01 13:35:00' AND Origin = 'STL' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-09-01' AND FlightNum = '1012' AND DepTime = '2003-09-01 08:56:00' AND Origin = 'DTW' AND Dest = 'MBS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-09-01' AND FlightNum = '102' AND DepTime = '2003-09-01 11:55:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-12-01' AND FlightNum = '1019' AND DepTime = '2003-12-01 08:08:00' AND Origin = 'BDL' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-12-01' AND FlightNum = '102' AND DepTime = '2003-12-01 13:04:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-12-01' AND FlightNum = '1020' AND DepTime = '2003-12-01 18:42:00' AND Origin = 'MSP' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-12-01' AND FlightNum = '1024' AND DepTime = '2003-12-01 15:43:00' AND Origin = 'MSP' AND Dest = 'LGA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-12-01' AND FlightNum = '1029' AND DepTime = '2003-12-01 17:56:00' AND Origin = 'BDL' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-08-01' AND FlightNum = '101' AND DepTime = '2003-08-01 06:59:00' AND Origin = 'ORD' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-08-01' AND FlightNum = '1011' AND DepTime = '2003-08-01 00:00:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-08-01' AND FlightNum = '1011' AND DepTime = '2003-08-01 00:00:00' AND Origin = 'STL' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-08-01' AND FlightNum = '1012' AND DepTime = '2003-08-01 10:38:00' AND Origin = 'DTW' AND Dest = 'MBS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-08-01' AND FlightNum = '1012' AND DepTime = '2003-08-01 08:04:00' AND Origin = 'IND' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-03-01' AND FlightNum = '102' AND DepTime = '2003-03-01 13:09:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-03-01' AND FlightNum = '1020' AND DepTime = '2003-03-01 18:55:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-03-01' AND FlightNum = '1021' AND DepTime = '2003-03-01 15:15:00' AND Origin = 'GRR' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-03-01' AND FlightNum = '1022' AND DepTime = '2003-03-01 13:15:00' AND Origin = 'MSP' AND Dest = 'SAT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-03-01' AND FlightNum = '1023' AND DepTime = '2003-03-01 17:19:00' AND Origin = 'IAH' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-06-01' AND FlightNum = '1016' AND DepTime = '2003-06-01 13:48:00' AND Origin = 'DTW' AND Dest = 'RIC'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-06-01' AND FlightNum = '1017' AND DepTime = '2003-06-01 13:20:00' AND Origin = 'MSP' AND Dest = 'OMA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-06-01' AND FlightNum = '1019' AND DepTime = '2003-06-01 08:19:00' AND Origin = 'RDU' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-06-01' AND FlightNum = '102' AND DepTime = '2003-06-01 12:05:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-06-01' AND FlightNum = '1020' AND DepTime = '2003-06-01 18:52:00' AND Origin = 'MSP' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-05-01' AND FlightNum = '101' AND DepTime = '2003-05-01 09:43:00' AND Origin = 'MSP' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-05-01' AND FlightNum = '1011' AND DepTime = '2003-05-01 17:09:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-05-01' AND FlightNum = '1016' AND DepTime = '2003-05-01 14:44:00' AND Origin = 'DTW' AND Dest = 'RIC'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-05-01' AND FlightNum = '1017' AND DepTime = '2003-05-01 12:50:00' AND Origin = 'MSP' AND Dest = 'OMA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-05-01' AND FlightNum = '1019' AND DepTime = '2003-05-01 08:32:00' AND Origin = 'RDU' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-01-01' AND FlightNum = '1023' AND DepTime = '2003-01-01 17:28:00' AND Origin = 'IAH' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-01-01' AND FlightNum = '1024' AND DepTime = '2003-01-01 15:02:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-01-01' AND FlightNum = '1028' AND DepTime = '2003-01-01 11:52:00' AND Origin = 'ONT' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-01-01' AND FlightNum = '1029' AND DepTime = '2003-01-01 18:09:00' AND Origin = 'JAX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-01-01' AND FlightNum = '1029' AND DepTime = '2003-01-01 21:02:00' AND Origin = 'MSP' AND Dest = 'ONT'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-04-01' AND FlightNum = '1015' AND DepTime = '2003-04-01 19:24:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-04-01' AND FlightNum = '1019' AND DepTime = '2003-04-01 08:04:00' AND Origin = 'JAX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-04-01' AND FlightNum = '102' AND DepTime = '2003-04-01 13:06:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-04-01' AND FlightNum = '1020' AND DepTime = '2003-04-01 19:01:00' AND Origin = 'MSP' AND Dest = 'IAH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-04-01' AND FlightNum = '1021' AND DepTime = '2003-04-01 15:17:00' AND Origin = 'GRR' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-02-01' AND FlightNum = '1011' AND DepTime = '2003-02-01 17:01:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-02-01' AND FlightNum = '1017' AND DepTime = '2003-02-01 21:02:00' AND Origin = 'DTW' AND Dest = 'IND'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-02-01' AND FlightNum = '1019' AND DepTime = '2003-02-01 07:50:00' AND Origin = 'DFW' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-02-01' AND FlightNum = '102' AND DepTime = '2003-02-01 13:03:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2003-02-01' AND FlightNum = '1020' AND DepTime = '2003-02-01 18:47:00' AND Origin = 'MSP' AND Dest = 'CMH'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-10-01' AND FlightNum = '0038' AND DepTime = '2001-10-01 12:36:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-10-01' AND FlightNum = '0039' AND DepTime = '2001-10-01 12:30:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-10-01' AND FlightNum = '0040' AND DepTime = '2001-10-01 11:07:00' AND Origin = 'MCO' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-10-01' AND FlightNum = '0043' AND DepTime = '2001-10-01 17:38:00' AND Origin = 'MSP' AND Dest = 'SEA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-10-01' AND FlightNum = '0044' AND DepTime = '2001-10-01 12:17:00' AND Origin = 'SEA' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-07-01' AND FlightNum = '0031' AND DepTime = '2001-07-01 19:35:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-07-01' AND FlightNum = '0032' AND DepTime = '2001-07-01 12:19:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-07-01' AND FlightNum = '0038' AND DepTime = '2001-07-01 12:46:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-07-01' AND FlightNum = '0039' AND DepTime = '2001-07-01 13:14:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-07-01' AND FlightNum = '0040' AND DepTime = '2001-07-01 11:19:00' AND Origin = 'MCO' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-11-01' AND FlightNum = '0031' AND DepTime = '2001-11-01 19:35:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-11-01' AND FlightNum = '0032' AND DepTime = '2001-11-01 12:35:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-11-01' AND FlightNum = '0039' AND DepTime = '2001-11-01 12:38:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-11-01' AND FlightNum = '0041' AND DepTime = '2001-11-01 14:54:00' AND Origin = 'MSP' AND Dest = 'LAS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-11-01' AND FlightNum = '0042' AND DepTime = '2001-11-01 09:37:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-09-01' AND FlightNum = '0031' AND DepTime = '2001-09-01 19:25:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-09-01' AND FlightNum = '0032' AND DepTime = '2001-09-01 12:20:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-09-01' AND FlightNum = '0038' AND DepTime = '2001-09-01 08:53:00' AND Origin = 'DEN' AND Dest = 'MEM'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-09-01' AND FlightNum = '0038' AND DepTime = '2001-09-01 12:52:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-09-01' AND FlightNum = '0039' AND DepTime = '2001-09-01 12:29:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-12-01' AND FlightNum = '0032' AND DepTime = '2001-12-01 12:27:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-12-01' AND FlightNum = '0039' AND DepTime = '2001-12-01 12:19:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-12-01' AND FlightNum = '0041' AND DepTime = '2001-12-01 14:53:00' AND Origin = 'MSP' AND Dest = 'LAS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-12-01' AND FlightNum = '0042' AND DepTime = '2001-12-01 09:32:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-12-01' AND FlightNum = '0043' AND DepTime = '2001-12-01 17:01:00' AND Origin = 'MSP' AND Dest = 'SEA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-08-01' AND FlightNum = '0031' AND DepTime = '2001-08-01 19:39:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-08-01' AND FlightNum = '0032' AND DepTime = '2001-08-01 12:18:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-08-01' AND FlightNum = '0038' AND DepTime = '2001-08-01 12:39:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-08-01' AND FlightNum = '0039' AND DepTime = '2001-08-01 12:31:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-08-01' AND FlightNum = '0040' AND DepTime = '2001-08-01 11:19:00' AND Origin = 'MCO' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-03-01' AND FlightNum = '0037' AND DepTime = '2001-03-01 17:29:00' AND Origin = 'BOS' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-03-01' AND FlightNum = '0038' AND DepTime = '2001-03-01 12:48:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-03-01' AND FlightNum = '0039' AND DepTime = '2001-03-01 13:19:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-03-01' AND FlightNum = '0042' AND DepTime = '2001-03-01 09:54:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-03-01' AND FlightNum = '0043' AND DepTime = '2001-03-01 16:59:00' AND Origin = 'MSP' AND Dest = 'SEA'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-06-01' AND FlightNum = '0031' AND DepTime = '2001-06-01 19:29:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-06-01' AND FlightNum = '0032' AND DepTime = '2001-06-01 12:18:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-06-01' AND FlightNum = '0038' AND DepTime = '2001-06-01 12:39:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-06-01' AND FlightNum = '0039' AND DepTime = '2001-06-01 12:29:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-06-01' AND FlightNum = '0040' AND DepTime = '2001-06-01 11:09:00' AND Origin = 'MCO' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-05-01' AND FlightNum = '0026' AND DepTime = '2001-05-01 11:37:00' AND Origin = 'LAX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-05-01' AND FlightNum = '0031' AND DepTime = '2001-05-01 21:18:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-05-01' AND FlightNum = '0032' AND DepTime = '2001-05-01 12:22:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-05-01' AND FlightNum = '0038' AND DepTime = '2001-05-01 12:40:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-05-01' AND FlightNum = '0039' AND DepTime = '2001-05-01 12:24:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-01-01' AND FlightNum = '0026' AND DepTime = '2001-01-01 00:00:00' AND Origin = 'LAX' AND Dest = 'SAN'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-01-01' AND FlightNum = '0031' AND DepTime = '2001-01-01 19:20:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-01-01' AND FlightNum = '0032' AND DepTime = '2001-01-01 12:20:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-01-01' AND FlightNum = '0037' AND DepTime = '2001-01-01 17:31:00' AND Origin = 'BOS' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-01-01' AND FlightNum = '0037' AND DepTime = '2001-01-01 21:08:00' AND Origin = 'MSP' AND Dest = 'SAN'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-04-01' AND FlightNum = '0031' AND DepTime = '2001-04-01 19:23:00' AND Origin = 'DTW' AND Dest = 'LAX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-04-01' AND FlightNum = '0032' AND DepTime = '2001-04-01 12:51:00' AND Origin = 'LAX' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-04-01' AND FlightNum = '0038' AND DepTime = '2001-04-01 12:42:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-04-01' AND FlightNum = '0039' AND DepTime = '2001-04-01 13:57:00' AND Origin = 'DTW' AND Dest = 'DFW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-04-01' AND FlightNum = '0040' AND DepTime = '2001-04-01 11:14:00' AND Origin = 'MCO' AND Dest = 'DTW'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-02-01' AND FlightNum = '0037' AND DepTime = '2001-02-01 17:34:00' AND Origin = 'BOS' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-02-01' AND FlightNum = '0038' AND DepTime = '2001-02-01 12:46:00' AND Origin = 'MEM' AND Dest = 'BOS'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-02-01' AND FlightNum = '0039' AND DepTime = '2001-02-01 12:26:00' AND Origin = 'DTW' AND Dest = 'PHX'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-02-01' AND FlightNum = '0042' AND DepTime = '2001-02-01 09:20:00' AND Origin = 'PHX' AND Dest = 'MSP'
SELECT * FROM flightstats WHERE AirlineID = '19386' AND UniqueCarrier = 'NW' AND Carrier = 'NW' AND FlightDate = '2001-02-01' AND FlightNum = '0043' AND DepTime = '2001-02-01 17:01:00' AND Origin = 'MSP' AND Dest = 'SEA'