利用SQL技能处理数据集

问答题 （100分）
【第一题】
1、创建db名字叫 flight 创建新表名字叫on_time_performance

mysql> create database flight character set 'utf8';
Query OK, 1 row affected (0.00 sec)

2、航班数据检查csv ，导入到sql数据库中

3、执行count语句查看总行数

mysql> select count(*) from on_time_performance;
+----------+
| count(*) |
+----------+
|   469008 |
+----------+
1 row in set (0.16 sec)

【第二题】
1、在航班及时率表中有如下delay延迟字段，请找出导致延迟次数最多的是哪一个原因 ，并给出各个原因累计的延迟时间
WeatherDelay CarrierDelay NASDelay SecurityDelay LateAircraftDelay

mysql> create view delay_view as
    -> select 'WeatherDelay' as delay_name, count(WeatherDelay) as delay_times, sum(WeatherDelay) as dalay_hours from on_time_performance where WeatherDelay > 0
    -> union
    -> select 'CarrierDelay', count(CarrierDelay), sum(CarrierDelay) from on_time_performance where CarrierDelay > 0
    -> union
    -> select 'NASDelay', count(NASDelay),