SQLize Online / PHPize Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Enter the following code for instance at https://sqlize.online/ - make sure to select PostgreSQL 13.2 as execution environment! CREATE TABLE flights ( "Flight Number" character varying NOT NULL, "Launch Date" date NOT NULL, "Launch Time" time without time zone NOT NULL, "Launch Site" character varying NOT NULL, "Vehicle Type" character varying NOT NULL, "Payload Name" character varying NOT NULL, "Payload Type" character varying, "Payload Mass (kg)" numeric, "Payload Orbit" character varying, "Customer Name" character varying, "Customer Type" character varying, "Customer Country" character varying, "Mission Outcome" character varying NOT NULL, "Failure Reason" character varying, "Landing Type" character varying, "Landing Outcome" character varying ); -- -- -- Data for Name: database; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-1', '2006-03-24', '22:30:00', 'Marshall Islands', 'Falcon 1', 'FalconSAT-2', 'Research Satellite', 19.5, NULL, 'DARPA', 'Government', 'United States', 'Failure', 'Engine Fire During Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-2', '2007-03-21', '01:10:00', 'Marshall Islands', 'Falcon 1', 'DemoSat', NULL, NULL, NULL, 'DARPA', 'Government', 'United States', 'Failure', 'Engine Shutdown During Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-3', '2008-08-03', '03:34:00', 'Marshall Islands', 'Falcon 1', 'Trailblazer', 'Communication Satellite', NULL, NULL, 'ORS', 'Government', 'United States', 'Failure', 'Collision During Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-3', '2008-08-03', '03:34:00', 'Marshall Islands', 'Falcon 1', 'PRESat, NanoSail-D', 'Research Satellites', 8, NULL, 'NASA', 'Government', 'United States', 'Failure', 'Collision During Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-3', '2008-08-03', '03:34:00', 'Marshall Islands', 'Falcon 1', 'Explorers', 'Human Remains', NULL, NULL, 'Celestis', 'Business', 'United States', 'Failure', 'Collision During Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-4', '2008-09-28', '23:15:00', 'Marshall Islands', 'Falcon 1', 'RatSat (DemoSat)', NULL, 165, 'Low Earth Orbit', NULL, NULL, NULL, 'Success', NULL, NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F1-5', '2009-07-14', '03:35:00', 'Marshall Islands', 'Falcon 1', 'RazakSAT', 'Weather Satellite', 180, 'Low Earth Orbit', 'ATSB', 'Government', 'Malaysia', 'Success', NULL, NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-1', '2010-06-04', '18:45:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'Dragon Spacecraft Qualification Unit', NULL, NULL, 'Low Earth Orbit', NULL, NULL, NULL, 'Success', NULL, 'Parachute', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-2', '2010-12-08', '15:43:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'SpaceX CRS (Dragon C1)', 'Space Station Supplies', NULL, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Parachute', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-3', '2012-05-22', '07:44:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'SpaceX CRS (Dragon C2+)', 'Space Station Supplies', NULL, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-4', '2012-10-08', '00:35:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'SpaceX CRS-1', 'Space Station Supplies', 500, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-4', '2012-10-08', '00:35:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'Orbcomm-OG2', 'Communication Satellite', 150, 'Low Earth Orbit', 'Orbcomm', 'Business', 'United States', 'Failure', 'Engine Failure During Flight', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-5', '2013-03-01', '15:10:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.0)', 'SpaceX CRS-2', 'Space Station Supplies', 677, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-6', '2013-09-29', '16:00:00', 'Vandenberg AFB SLC-4E', 'Falcon 9 (v1.1)', 'CASSIOPE', 'Communication/Research Satellite', 500, 'Polar Orbit', 'MDA Corp', 'Business', 'Canada', 'Success', NULL, 'Ocean', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-7', '2013-12-03', '22:41:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SES-8', 'Communication Satellite', 3170, 'Geostationary Transfer Orbit', 'SES', 'Business', 'Luxembourg', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-8', '2014-12-06', '22:06:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'Thaicom 6', 'Communication Satellite', 3325, 'Geostationary Transfer Orbit', 'Thaicom', 'Business', 'Thailand', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-9', '2014-04-18', '19:25:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SpaceX CRS-3', 'Space Station Supplies', 2296, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Ocean', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-10', '2014-07-14', '15:15:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'OG2 Mission 1 (6 OG2 Satellites)', 'Communication Satellite', NULL, 'Low Earth Orbit', 'Orbcomm', 'Business', 'United States', 'Success', NULL, 'Ocean', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-11', '2014-08-05', '08:00:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'AsiaSat 8', 'Communication Satellite', 4535, 'Geostationary Transfer Orbit', 'AsiaSat', 'Business', 'China', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-12', '2014-09-07', '05:00:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'AsiaSat 6', 'Communication Satellite', 4428, 'Geostationary Transfer Orbit', 'AsiaSat', 'Business', 'China', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-13', '2014-09-21', '05:52:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SpaceX CRS-4', 'Space Station Supplies', 2216, 'Geostationary Transfer Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Ocean', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-14', '2015-01-10', '09:47:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SpaceX CRS-5', 'Space Station Supplies', 2395, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-15', '2015-02-11', '23:03:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'DSCOVR', 'Weather Satellite', 570, 'Sun/Earth Orbit', 'US Air Force; NASA; NOAA', 'Government', 'United States', 'Success', NULL, 'Ocean', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-16', '2015-03-02', '03:50:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'ABS-3A', 'Communication Satellite', 4159, 'Geostationary Transfer Orbit', 'Asia Broadcast Satellite', 'Business', 'Bermuda', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-16', '2015-03-02', '03:50:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'Eutelsat 115 West B (Satmex 7)', 'Communication Satellite', 4159, 'Geostationary Transfer Orbit', 'Eutelsat (Satmex)', 'Business', 'France (Mexico)', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-17', '2015-04-14', '20:10:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SpaceX CRS-6', 'Space Station Supplies', 1898, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-18', '2015-04-27', '23:03:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'TurkmenAlem 52E/MonacoSAT', 'Communication Satellite', 4707, 'Geostationary Transfer Orbit', 'Turkmenistan NSA', 'Government', 'Turkmenistan', 'Success', NULL, 'None', NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-19', '2015-06-28', '14:21:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 (v1.1)', 'SpaceX CRS-7', 'Space Station Supplies', 1952, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Failure', 'Vehicle Explosion During Flight', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-1', '2015-12-22', '01:29:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'OG2 Mission 2 (11 OG2 Satellites)', 'Communication Satellite', NULL, 'Low Earth Orbit', 'Orbcomm', 'Business', 'United States', 'Success', NULL, 'Land', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('F9-21', '2016-01-17', '18:42:00', 'Vandenberg AFB SLC-4E', 'Falcon 9 (v1.1)', 'Jason-3', 'Weather Satellite', 553, 'Low Earth Orbit', 'NASA; NOAA; CNES', 'Government', 'United States', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-2', '2016-03-04', '23:35:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'SES-9', 'Communication Satellite', 5271, 'Geostationary Transfer Orbit', 'SES', 'Business', 'Luxembourg', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-3', '2016-04-08', '20:43:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'SpaceX CRS-8', 'Space Station Supplies', 3136, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Ship', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-4', '2016-05-06', '05:21:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'JCSAT-14', 'Communication Satellite', 4696, 'Geostationary Transfer Orbit', 'SKY Perfect JSAT Group', 'Business', 'Japan', 'Success', NULL, 'Ship', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-5', '2016-05-27', '21:39:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'Thaicom 8', 'Communication Satellite', 3100, 'Geostationary Transfer Orbit', 'Thaicom', 'Business', 'Thailand', 'Success', NULL, 'Ship', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-6', '2016-06-15', '14:29:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'ABS-2A', 'Communication Satellite', 3600, 'Geostationary Transfer Orbit', 'Asia Broadcast Satellite', 'Business', 'Bermuda', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-6', '2016-06-15', '14:29:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'Eutelsat 117 West B (Satmex 9)', 'Communication Satellite', 3600, 'Geostationary Transfer Orbit', 'Eutelsat (Satmex)', 'Business', 'France (Mexico)', 'Success', NULL, 'Ship', 'Failure'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-7', '2016-07-18', '04:45:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'SpaceX CRS-9', 'Space Station Supplies', 2257, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Land', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-8', '2016-08-14', '05:26:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'JCSAT-16', 'Communication Satellite', 4600, 'Geostationary Transfer Orbit', 'SKY Perfect JSAT Group', 'Business', 'Japan', 'Success', NULL, 'Ship', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-9', '2016-09-01', '13:07:00', 'Cape Canaveral AFS LC-40', 'Falcon 9 Full Thrust (v1.2)', 'Amos-6', 'Communication Satellite', 5500, 'Geostationary Transfer Orbit', 'Spacecom', 'Business', 'Israel', 'Failure', 'Vehicle Explosion Before Launch', NULL, NULL); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-10', '2017-01-14', '17:54:00', 'Vandenberg AFB SLC-4E', 'Falcon 9 Full Thrust (v1.2)', 'Iridium NEXT 1-10', 'Communication Satellite', 9600, 'Low Earth Orbit', 'Iridium Communications', 'Business', 'United States', 'Success', NULL, 'Ship', 'Success'); INSERT INTO flights ("Flight Number", "Launch Date", "Launch Time", "Launch Site", "Vehicle Type", "Payload Name", "Payload Type", "Payload Mass (kg)", "Payload Orbit", "Customer Name", "Customer Type", "Customer Country", "Mission Outcome", "Failure Reason", "Landing Type", "Landing Outcome") VALUES ('FT-11', '2017-02-19', '14:39:00', 'Kennedy Space Center LC-39A', 'Falcon 9 Full Thrust (v1.2)', 'SpaceX CRS-10', 'Space Station Supplies', 2490, 'Low Earth Orbit', 'NASA', 'Government', 'United States', 'Success', NULL, 'Land', 'Success'); select T."Landing Type", count(F."Landing Type") from (select distinct "Landing Type" from flights) as T left outer join (select * from flights where "Mission Outcome" = 'Failure') as F on (T."Landing Type" = F."Landing Type") group by T."Landing Type";
Stuck with a problem? Got Error? Ask ChatGPT!
Copy