SELECT
CASE WHEN LOWER("type") LIKE '%boeing%' THEN survivalrate ELSE NULL END AS "Boeing survival rate",
CASE WHEN LOWER("type") LIKE '%airbus%' THEN survivalrate ELSE NULL END AS "Airbus survival rate",
"date"
FROM
@kaggle.juancarlosventosa_large_passenger_plane_crashes_19332009.large_passenger_plane_crashes_1933_to_2009
WHERE
CASE WHEN LOWER("type") LIKE '%boeing%' THEN survivalrate ELSE NULL END IS NOT NULL
OR CASE WHEN LOWER("type") LIKE '%airbus%' THEN survivalrate ELSE NULL END IS NOT NULL
ORDER BY "date" ASC;| Boeing survival rate | Airbus survival rate | date |
|---|---|---|
| 0 | null | 1969-06-04 00:00:00 |
| 0.771186441 | null | 1969-09-21 00:00:00 |
| 0.006097561 | null | 1971-07-30 00:00:00 |
| 1 | null | 1971-07-30 00:00:00 |
| 0 | null | 1971-09-04 00:00:00 |
| 0.128712871 | null | 1973-01-22 00:00:00 |
| 0.026548673 | null | 1973-02-21 00:00:00 |
| 0.082089552 | null | 1973-07-11 00:00:00 |
| 0.012658228 | null | 1973-07-22 00:00:00 |
| 0.993288591 | null | 1973-08-28 00:00:00 |
| 0.830508475 | null | 1973-12-17 00:00:00 |
| 0.04950495 | null | 1974-01-30 00:00:00 |
| 0.996644295 | null | 1974-02-02 00:00:00 |
| 0 | null | 1974-04-22 00:00:00 |
| 0 | null | 1974-09-08 00:00:00 |
| 0 | null | 1974-09-15 00:00:00 |
| 0.624203822 | null | 1974-11-20 00:00:00 |
| 0 | null | 1974-12-01 00:00:00 |
| 0.088709677 | null | 1975-06-24 00:00:00 |
| 0 | null | 1975-08-03 00:00:00 |
| 1 | null | 1975-08-07 00:00:00 |
| 0 | null | 1976-01-01 00:00:00 |
| null | 0.972868217 | 1976-06-27 00:00:00 |
| 0 | null | 1976-09-19 00:00:00 |
| 0.094720497 | null | 1977-03-27 00:00:00 |
| 0.201219512 | null | 1977-11-19 00:00:00 |
| 0 | null | 1977-12-04 00:00:00 |
| 0 | null | 1978-01-01 00:00:00 |
| 0.981651376 | null | 1978-04-20 00:00:00 |
| 0 | null | 1978-09-25 00:00:00 |
| 0.992424242 | null | 1978-12-17 00:00:00 |
| 0 | null | 1979-11-26 00:00:00 |
| 0 | null | 1980-01-21 00:00:00 |
| 0.985185185 | null | 1980-02-27 00:00:00 |
| 0 | null | 1980-04-25 00:00:00 |
| 0.933628319 | null | 1980-11-19 00:00:00 |
| 0 | null | 1981-08-22 00:00:00 |
| 0.063291139 | null | 1982-01-13 00:00:00 |
| 0.983050847 | null | 1982-05-25 00:00:00 |
| 0 | null | 1982-06-08 00:00:00 |
| 0.846846847 | null | 1982-06-22 00:00:00 |
| 1 | null | 1982-06-24 00:00:00 |
| 0 | null | 1982-07-09 00:00:00 |
| 0 | null | 1983-07-11 00:00:00 |
| 0 | null | 1983-09-01 00:00:00 |
| 0 | null | 1983-09-23 00:00:00 |
| 0 | null | 1983-11-08 00:00:00 |
| 0.057291667 | null | 1983-11-27 00:00:00 |
| 0.311111111 | null | 1983-12-07 00:00:00 |
| 0.982758621 | null | 1984-08-30 00:00:00 |
| 0 | null | 1985-02-19 00:00:00 |
| 1 | null | 1985-02-19 00:00:00 |
| 0.993464052 | null | 1985-06-14 00:00:00 |
| 0 | null | 1985-06-23 00:00:00 |
| 0.007633588 | null | 1985-08-12 00:00:00 |
| 0.598540146 | null | 1985-08-22 00:00:00 |
| 0.417475728 | null | 1985-11-24 00:00:00 |
| 0 | null | 1986-03-31 00:00:00 |
| 0.966942149 | null | 1986-04-02 00:00:00 |
| 0.958333333 | null | 1986-09-05 00:00:00 |
| 0.405660377 | null | 1986-12-25 00:00:00 |
| 0 | null | 1987-08-31 00:00:00 |
| 0 | null | 1987-11-28 00:00:00 |
| 0 | null | 1987-11-29 00:00:00 |
| 0 | null | 1988-03-17 00:00:00 |
| 0.982142857 | null | 1988-04-05 00:00:00 |
| 0.989473684 | null | 1988-04-28 00:00:00 |
| null | 0.977941176 | 1988-06-26 00:00:00 |
| null | 0 | 1988-07-03 00:00:00 |
| 0.87037037 | null | 1988-08-31 00:00:00 |
| 0.663461538 | null | 1988-09-15 00:00:00 |
| 0.03875969 | null | 1988-10-19 00:00:00 |
| 0 | null | 1988-12-21 00:00:00 |
| 0.626984127 | null | 1989-01-08 00:00:00 |
| 0 | null | 1989-02-08 00:00:00 |
| 0.974719101 | null | 1989-02-24 00:00:00 |
| 0.130136986 | null | 1989-10-21 00:00:00 |
| 0 | null | 1989-11-27 00:00:00 |
| 0.537974684 | null | 1990-01-25 00:00:00 |
| null | 0.369863014 | 1990-02-14 00:00:00 |
| 0.932773109 | null | 1990-05-11 00:00:00 |
| 0.433628319 | null | 1990-10-02 00:00:00 |
| 0.95959596 | null | 1990-12-03 00:00:00 |
| 0 | null | 1991-05-26 00:00:00 |
| 0 | null | 1991-08-16 00:00:00 |
| null | 0.09375 | 1992-01-20 00:00:00 |
| null | 0 | 1992-07-31 00:00:00 |
| null | 0 | 1992-09-28 00:00:00 |
| 0 | null | 1992-11-24 00:00:00 |
| 0 | null | 1992-12-22 00:00:00 |
| 0.525423729 | null | 1993-04-26 00:00:00 |
| 0 | null | 1993-05-19 00:00:00 |
| 0.381818182 | null | 1993-07-26 00:00:00 |
| null | 0 | 1994-03-23 00:00:00 |
| null | 0.025830258 | 1994-04-26 00:00:00 |
| null | 1 | 1994-08-10 00:00:00 |
| 0 | null | 1994-09-08 00:00:00 |
| 0.996587031 | null | 1994-12-10 00:00:00 |
| null | 0.987447699 | 1994-12-26 00:00:00 |
| 0.934306569 | null | 1995-11-13 00:00:00 |
| 0.076923077 | null | 1995-12-03 00:00:00 |
| 0.024390244 | null | 1995-12-20 00:00:00 |
| 0 | null | 1996-02-06 00:00:00 |
| 0 | null | 1996-02-29 00:00:00 |
| 0 | null | 1996-07-17 00:00:00 |
| 0 | null | 1996-10-02 00:00:00 |
| 0 | null | 1996-11-07 00:00:00 |
| 0 | null | 1996-11-12 00:00:00 |
| 0.274285714 | null | 1996-11-23 00:00:00 |
| 0.098425197 | null | 1997-08-06 00:00:00 |
| null | 0 | 1997-09-26 00:00:00 |
| 0 | null | 1997-12-19 00:00:00 |
| 0.997455471 | null | 1997-12-28 00:00:00 |
| null | 0 | 1998-02-16 00:00:00 |
| null | 1 | 1998-03-22 00:00:00 |
| 0.147727273 | null | 1998-05-05 00:00:00 |
| null | 0.301369863 | 1998-12-11 00:00:00 |
| 0.998065764 | null | 1999-07-23 00:00:00 |
| 0.378640777 | null | 1999-08-31 00:00:00 |
| 0 | null | 1999-10-31 00:00:00 |
| null | 0.994708995 | 1999-12-24 00:00:00 |
| null | 0.055865922 | 2000-01-30 00:00:00 |
| 1 | null | 2000-03-05 00:00:00 |
| 0 | null | 2000-04-19 00:00:00 |
| null | 0.996644295 | 2000-05-25 00:00:00 |
| null | 0 | 2000-08-23 00:00:00 |
| 0.536312849 | null | 2000-10-31 00:00:00 |
| null | 0.99122807 | 2000-11-20 00:00:00 |
| null | 1 | 2001-08-24 00:00:00 |
| 0 | null | 2001-09-11 00:00:00 |
| null | 0 | 2001-11-12 00:00:00 |
| 0 | null | 2002-01-28 00:00:00 |
| 0.228915663 | null | 2002-04-15 00:00:00 |
| 0 | null | 2002-05-25 00:00:00 |
| 0 | null | 2002-07-01 00:00:00 |
| 0.009708738 | null | 2003-03-06 00:00:00 |
| 0.008547009 | null | 2003-07-08 00:00:00 |
| 0.130434783 | null | 2003-12-25 00:00:00 |
| 0 | null | 2004-01-03 00:00:00 |
| 0 | null | 2005-02-03 00:00:00 |
| 0.982248521 | null | 2005-04-20 00:00:00 |
| null | 1 | 2005-08-02 00:00:00 |
| 0 | null | 2005-08-14 00:00:00 |
| 0.591836735 | null | 2005-08-23 00:00:00 |
| 0.153846154 | null | 2005-09-05 00:00:00 |
| 0 | null | 2005-10-22 00:00:00 |
| 1 | null | 2005-12-08 00:00:00 |
| null | 0 | 2006-05-03 00:00:00 |
| null | 0.369458128 | 2006-07-09 00:00:00 |
| 0.043478261 | null | 2006-09-29 00:00:00 |
| 0.085714286 | null | 2006-10-29 00:00:00 |
| 0 | null | 2007-01-01 00:00:00 |
| 0.842857143 | null | 2007-03-07 00:00:00 |
| 0 | null | 2007-05-05 00:00:00 |
| null | 0 | 2007-07-17 00:00:00 |
| 1 | null | 2008-01-17 00:00:00 |
| null | 0.977941176 | 2008-05-30 00:00:00 |
| null | 0.85046729 | 2008-06-10 00:00:00 |
| 0.244444444 | null | 2008-08-24 00:00:00 |
| 0 | null | 2008-09-14 00:00:00 |
| null | 1 | 2009-01-15 00:00:00 |
| 0.932835821 | null | 2009-02-25 00:00:00 |
| null | 0 | 2009-06-01 00:00:00 |
| 0 | null | 2061-02-15 00:00:00 |
| 0 | null | 2062-03-01 00:00:00 |
| 0.015151515 | null | 2062-06-03 00:00:00 |
| 0 | null | 2062-06-22 00:00:00 |
| 0 | null | 2062-11-27 00:00:00 |
| 0 | null | 2063-12-08 00:00:00 |
| 0.05952381 | null | 2064-05-11 00:00:00 |
| 0.048 | null | 2065-05-20 00:00:00 |
| 0 | null | 2065-06-25 00:00:00 |
| 1 | null | 2065-06-28 00:00:00 |
| 0.964285714 | null | 2065-12-04 00:00:00 |
| 0 | null | 2066-01-24 00:00:00 |
| 0 | null | 2066-02-04 00:00:00 |
| 0 | null | 2066-03-05 00:00:00 |
| 0 | null | 2067-07-19 00:00:00 |
| 0.960629921 | null | 2068-04-08 00:00:00 |
| 0.0390625 | null | 2068-04-20 00:00:00 |