Réaliser les manipulations suivantes dans le fichier fournit en répondant dans la section correspondante.

• Le fichier doit pouvoir être exécuté plusieurs fois en donnant exactement les mêmes résultats

Serveur

• Créer la base de données airport
• Utiliser le mot de passe pwd pour tous les utilisateurs
  • Créer l'utilisateur alice possédant les accès complets sur airport et la gestion des permissions via une connexion de localhost
  • Créer l'utilisateur bob possédant les accès SELECT sur airport via une connexion externe
• Créer la table pilots selon la structure suivante

• Compléter l'initialisation de la base de données en exécutant le script fournis

INSERT INTO `pilots` (`name`,`age`,`country`,`experience`,`weekly_flights`) VALUES ("Dacey Ward",26,"uk",0, NULL),("Timothy Foley",38,"spain",15,3),("Kyla Bryan",25,"spain",0,NULL),("Celeste Mcclain",39,"uk",24,10),("Danielle Luna",50,"uk",17,7),("Odysseus Gill",51,"uk",11,1),("Vielka Kelley",28,"italy",20,5),("Tate Bonner",46,"mexico",29,1),("Carla Drake",54,"france",23,8),("Hyatt Chandler",60,"spain",29,5),("Marsden Anderson",51,"usa",12,5),("Phillip Silva",35,"usa",30,1),("Donovan Walton",33,"italy",28,5),("Keely Maynard",53,"usa",21,10),("Cadman Sheppard",34,"france",29,5),("Alyssa Orr",36,"usa",20,2),("Plato Rhodes",33,"usa",22,2),("Thor Cortez",55,"france",29,8),("Clinton Carey",58,"usa",19,5),("Jesse Berg",51,"spain",19,6),("Tanek Wilder",34,"france",25,9),("Karina Schroeder",44,"usa",28,6),("Gemma Donovan",38,"spain",12,4),("Thaddeus Henson",38,"france",27,2),("Igor Frank",34,"spain",21,5),("Charlotte Warner",26,"canada",15,8),("Travis Merritt",42,"canada",16,2),("Caryn Dickson",25,"france",0,NULL),("Willow Yates",60,"spain",24,6),("Lesley Jennings",39,"france",12,2),("Jaquelyn Munoz",53,"italy",10,9),("Baxter Pratt",43,"canada",17,9),("Demetria Browning",40,"italy",24,3),("Azalia Ramirez",45,"italy",20,6),("Isabelle Herrera",57,"spain",25,8),("Felix Sexton",28,"uk",12,1),("Kieran Shannon",43,"mexico",15,9),("Yuli Spencer",59,"italy",18,NULL),("Chancellor Delacruz",51,"canada",27,2),("Maggie Boyle",43,"usa",10,8),("Lois Merrill",27,"france",25,1),("Sophia Casey",60,"france",29,7),("Raven Lamb",49,"usa",14,2),("Thaddeus Valenzuela",51,"france",17,3),("Fitzgerald Blackburn",54,"spain",23,9),("Amity Flowers",44,"mexico",22,10),("Imelda York",52,"france",27,8),("Deacon Anderson",25,"uk",25,6),("Geraldine Castillo",51,"canada",23,5),("Donna Rodriguez",48,"france",12,9),("Sylvester Wise",45,"canada",14,8),("Sydney Summers",29,"italy",12,1),("Elaine Foley",28,"france",27,10),("Isabelle Glenn",28,"usa",23,1),("Veda Holden",37,"usa",17,4),("Randall Bishop",44,"spain",25,1),("Sigourney Donovan",37,"usa",14,10),("Tyrone Jacobs",28,"mexico",11,8),("Shafira Kent",37,"france",18,6),("Cynthia Dejesus",35,"france",10,6),("Daniel Ferguson",28,"usa",30,3),("Mufutau Bowman",51,"mexico",30,9),("Sophia Patton",40,"uk",22,4),("Marvin Craft",27,"uk",23,4),("Mariko Cole",55,"usa",30,5),("Zachery Cash",55,"canada",16,6),("Reagan Bass",40,"italy",13,5),("Kirby Stanton",26,"uk",18,9),("Xander Frank",38,"mexico",17,5),("Jacob Schultz",58,"uk",24,7),("Kelly Douglas",46,"italy",11,6),("Alden Snider",49,"mexico",13,6),("Chanda Santos",26,"italy",27,5),("Upton Gordon",44,"italy",23,6),("Tashya Wagner",49,"mexico",15,5),("Todd Zimmerman",49,"canada",14,9),("Alan Hebert",34,"uk",27,3),("Vivien Hickman",38,"mexico",19,6),("Kennedy Pena",46,"usa",24,3),("Scott Bond",25,"france",23,2),("Justina Nixon",51,"france",21,1),("Wanda Donovan",37,"france",18,4),("Tasha Smith",26,"france",21,2),("Jackson Patel",43,"spain",14,5),("Wyatt Mueller",58,"mexico",22,6),("Halla Romero",34,"france",29,10),("Eugenia Mullins",60,"mexico",13,NULL),("Ferris Schultz",56,"italy",11,2),("Ruby Gilliam",35,"uk",26,7),("Drake Case",46,"canada",30,10),("Basil Estrada",29,"uk",21,5),("Cara Mccoy",57,"canada",14,2),("Dane Brooks",48,"italy",28,10),("Ulric Hooper",46,"spain",10,3),("Belle Hinton",45,"mexico",18,10),("Zachary Park",37,"mexico",13,1),("Tucker Watts",42,"canada",16,8),("Roanna Frost",56,"france",20,5),("Amena Howe",54,"canada",20,3),("Sarah Allen",49,"mexico",23,3);

CREATE TABLE IF NOT EXISTS `flights` (
    `pilot` VARCHAR(255) NOT NULL,
    `number` CHAR(4) NOT NULL,
    `departure_hour` TINYINT UNSIGNED NOT NULL,
    `departure_minutes` TINYINT UNSIGNED NOT NULL,
    `origin` VARCHAR(255) NOT NULL,
    `destination` VARCHAR(255) NOT NULL,
    `duration_minutes` MEDIUMINT UNSIGNED NOT NULL,
    `delay_minutes` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
    `plane` VARCHAR(255) NOT NULL
);

INSERT INTO `flights` (`pilot`,`number`,`departure_hour`,`departure_minutes`,`origin`,`destination`,`duration_minutes`,`delay_minutes`,`plane`) VALUES ("dave","X553",19,57,"usa","italy",702,1186,"A350"),("charlie","G683",22,37,"italy","italy",623,438,"B747"),("eve","M031",12,37,"italy","spain",315,135,"B737"),("alice","H479",11,42,"uk","canada",93,844,"B737"),("charlie","Y894",19,52,"italy","usa",753,697,"B737"),("eve","Z078",16,18,"usa","canada",531,1284,"A380"),("charlie","T408",3,7,"usa","mexico",162,1330,"A350"),("franck","D006",12,34,"canada","uk",887,317,"B747"),("bob","X656",15,36,"france","uk",957,899,"B747"),("franck","S204",21,3,"usa","france",578,735,"A380"),("charlie","M381",9,22,"france","italy",842,618,"B737"),("alice","A988",11,19,"france","canada",771,829,"B747"),("eve","B773",22,46,"france","mexico",331,752,"B737"),("bob","W888",8,47,"canada","france",832,1112,"B737"),("dave","N354",18,3,"france","spain",835,318,"A380"),("bob","S373",20,43,"spain","uk",665,883,"A380"),("bob","L015",15,55,"france","spain",256,404,"B747"),("franck","T110",2,8,"canada","spain",781,975,"B747"),("franck","U642",0,15,"spain","france",520,334,"B747"),("charlie","K771",23,46,"usa","italy",923,959,"B737"),("charlie","A409",1,16,"italy","uk",980,227,"A380"),("charlie","B859",10,3,"mexico","italy",557,565,"A380"),("franck","U191",3,50,"italy","italy",585,637,"A350"),("alice","H435",19,13,"spain","france",973,1238,"B747"),("charlie","Y288",0,33,"italy","canada",799,658,"B737"),("dave","H976",18,6,"mexico","uk",540,772,"A350"),("eve","Q507",19,54,"france","france",107,319,"A380"),("bob","Q807",0,29,"mexico","france",971,257,"B737"),("franck","Q205",23,11,"mexico","canada",374,1390,"B747"),("dave","S700",20,1,"mexico","usa",256,593,"A380"),("eve","I250",23,29,"uk","mexico",696,1377,"A350"),("alice","C877",18,7,"italy","france",900,582,"A380"),("eve","E196",17,39,"italy","canada",845,588,"B737"),("bob","D536",2,27,"italy","usa",931,175,"A380"),("franck","J309",17,15,"spain","spain",228,117,"A380"),("eve","U505",7,6,"mexico","mexico",828,764,"A380"),("eve","C589",11,30,"canada","mexico",874,1418,"A380"),("eve","H150",0,10,"uk","uk",253,263,"B737"),("eve","V645",2,17,"canada","spain",905,769,"A380"),("franck","P604",23,2,"usa","mexico",545,1404,"A380"),("eve","K794",14,18,"canada","spain",144,1329,"A350"),("bob","S374",12,13,"mexico","spain",366,653,"A330"),("alice","P783",6,27,"spain","usa",442,1372,"B747"),("bob","Q714",16,16,"france","spain",676,1399,"A380"),("dave","X469",11,7,"mexico","mexico",143,263,"A380"),("bob","A521",13,48,"canada","mexico",899,1073,"A330"),("charlie","N312",1,37,"canada","italy",238,884,"B747"),("bob","W827",14,0,"uk","uk",778,1170,"A380"),("bob","G232",2,39,"canada","italy",127,550,"B747"),("alice","D785",14,44,"uk","usa",290,888,"B737"),("dave","Z934",8,57,"usa","france",315,181,"A350"),("alice","D303",9,0,"usa","uk",200,943,"B747"),("eve","T974",20,46,"france","uk",129,79,"B737"),("franck","W450",15,56,"spain","france",693,906,"A380"),("alice","T994",10,51,"usa","usa",628,646,"A380"),("bob","R126",1,12,"spain","uk",287,81,"A350"),("alice","M210",7,42,"spain","france",557,1253,"A350"),("eve","B141",15,24,"italy","mexico",971,1065,"A380"),("franck","Z896",22,15,"usa","uk",258,867,"A380"),("dave","C450",12,24,"uk","france",695,457,"B747"),("dave","A203",18,58,"usa","mexico",210,644,"A330"),("franck","R984",15,21,"usa","spain",568,1125,"B747"),("dave","D914",23,0,"usa","canada",125,1179,"A330"),("alice","D010",17,32,"mexico","uk",710,352,"B737"),("franck","T559",22,7,"italy","spain",491,637,"B747"),("dave","K678",20,16,"france","mexico",160,197,"A330"),("dave","B111",19,51,"spain","mexico",536,1041,"A330"),("dave","S085",19,13,"spain","italy",436,481,"B747"),("dave","F715",18,52,"italy","italy",81,726,"A350"),("alice","T295",18,41,"uk","usa",279,958,"A380"),("alice","Y117",2,36,"spain","uk",319,17,"A380"),("dave","W419",1,10,"uk","usa",249,84,"B747"),("charlie","L724",23,40,"spain","uk",880,1208,"B747"),("franck","S898",15,54,"italy","spain",974,1246,"A380"),("eve","J886",13,16,"mexico","canada",494,1049,"B737"),("dave","O643",7,35,"italy","usa",961,560,"B737"),("eve","N245",2,45,"italy","spain",426,275,"A380"),("alice","T041",3,45,"usa","france",232,258,"B747"),("bob","T842",4,26,"mexico","usa",115,1330,"A380"),("alice","N935",15,4,"spain","france",862,605,"A330"),("franck","I118",23,16,"spain","spain",593,493,"B737"),("alice","X379",2,44,"usa","italy",306,302,"B737"),("charlie","S599",11,47,"usa","usa",135,1158,"A380"),("eve","I619",18,31,"spain","mexico",879,307,"B747"),("franck","O837",19,44,"spain","usa",675,360,"B737"),("bob","K407",0,50,"italy","usa",185,653,"A330"),("bob","P551",3,2,"spain","usa",950,1087,"A350"),("alice","C492",7,41,"spain","france",436,8,"A380"),("alice","P073",1,59,"france","france",330,1255,"B747"),("bob","X665",4,45,"usa","italy",924,257,"A350"),("bob","I975",20,41,"italy","uk",770,204,"B747"),("bob","C158",6,31,"italy","italy",246,852,"A330"),("alice","K208",22,35,"canada","uk",991,654,"B747"),("alice","X079",4,18,"italy","uk",191,389,"A350"),("franck","H202",20,42,"spain","spain",570,689,"A380"),("charlie","P397",14,38,"france","uk",901,902,"A330"),("bob","E856",1,18,"mexico","canada",920,101,"B747"),("dave","A054",17,18,"uk","mexico",71,183,"B737"),("eve","O733",18,22,"uk","spain",495,466,"B747"),("franck","L490",2,17,"mexico","uk",338,874,"B737");
INSERT INTO `flights` (`pilot`,`number`,`departure_hour`,`departure_minutes`,`origin`,`destination`,`duration_minutes`,`delay_minutes`,`plane`) VALUES ("alice","Y680",6,7,"italy","uk",431,231,"B737"),("alice","P757",1,7,"mexico","spain",411,764,"B737"),("eve","G378",9,44,"mexico","spain",593,913,"B737"),("eve","U297",3,14,"france","france",910,608,"A330"),("charlie","N284",10,10,"usa","italy",50,608,"A380"),("alice","A135",3,43,"spain","usa",980,359,"A330"),("alice","Y952",19,31,"usa","italy",852,1135,"A350"),("eve","X250",0,40,"mexico","usa",395,397,"A380"),("bob","O115",12,33,"spain","usa",622,1233,"A350"),("charlie","Y388",4,15,"spain","usa",792,513,"B747"),("bob","G956",23,46,"canada","canada",544,20,"B737"),("bob","M205",9,19,"mexico","france",64,400,"A380"),("alice","S338",11,30,"france","spain",919,320,"A350"),("dave","B378",1,17,"uk","usa",904,796,"A350"),("eve","F861",12,29,"uk","france",597,466,"A380"),("dave","D991",12,7,"uk","italy",30,313,"B737"),("alice","I662",0,44,"mexico","italy",220,983,"A350"),("charlie","H056",12,59,"italy","italy",244,518,"A350"),("dave","H056",22,9,"canada","canada",100,340,"B747"),("charlie","J826",22,32,"uk","mexico",895,897,"A380"),("dave","E059",8,58,"uk","france",244,105,"B747"),("bob","P296",15,17,"usa","italy",984,163,"B737"),("franck","Y306",14,44,"mexico","mexico",290,217,"B747"),("dave","J412",16,21,"spain","usa",542,735,"B737"),("franck","G505",6,7,"spain","mexico",760,787,"A330"),("dave","G488",14,43,"italy","spain",82,288,"A330"),("alice","Z940",3,6,"italy","france",925,1102,"A330"),("alice","K921",9,53,"usa","usa",734,1384,"A350"),("dave","W499",12,37,"mexico","usa",784,1119,"B737"),("dave","G194",1,9,"uk","mexico",44,225,"B737"),("eve","Q258",14,5,"spain","usa",52,1008,"B747"),("bob","C543",19,15,"canada","italy",614,142,"A330"),("charlie","V217",7,34,"usa","italy",542,1171,"A330"),("dave","H740",16,47,"spain","spain",582,361,"A330"),("bob","P972",18,34,"spain","spain",677,351,"A350"),("eve","X569",22,6,"canada","spain",870,64,"B747"),("bob","Y322",19,44,"canada","mexico",961,5,"A350"),("franck","H207",16,23,"france","uk",819,662,"A380"),("alice","Z733",11,9,"uk","uk",705,171,"A380"),("eve","S836",15,31,"uk","canada",245,540,"B747"),("alice","S168",21,56,"uk","france",442,448,"A380"),("alice","X784",1,19,"france","spain",382,746,"B737"),("dave","T304",23,2,"canada","usa",935,1026,"A380"),("alice","H028",13,4,"italy","mexico",922,1120,"A330"),("eve","I990",2,30,"canada","usa",332,892,"B737"),("alice","C472",12,45,"usa","mexico",418,1104,"A350"),("dave","K918",3,23,"france","france",118,502,"B737"),("alice","W186",4,20,"canada","uk",148,1363,"A330"),("franck","E315",22,51,"spain","usa",988,664,"A330"),("alice","J890",13,48,"italy","canada",803,261,"A380"),("eve","K640",10,11,"uk","mexico",196,1365,"B737"),("eve","I099",10,3,"france","canada",542,574,"A330"),("charlie","P475",14,24,"spain","uk",766,833,"B737"),("charlie","Q617",5,29,"france","canada",121,833,"A330"),("dave","J269",7,49,"usa","italy",729,626,"A350"),("eve","G150",9,36,"mexico","uk",811,879,"A350"),("eve","B401",16,17,"uk","italy",342,358,"B737"),("franck","O754",5,46,"france","mexico",145,621,"B737"),("alice","H720",19,21,"italy","usa",241,831,"B747"),("charlie","Y465",5,1,"canada","italy",746,739,"A330"),("franck","I797",16,45,"uk","spain",515,622,"A330"),("dave","E958",9,42,"mexico","canada",101,233,"A380"),("bob","A968",8,0,"spain","italy",937,763,"A330"),("eve","X319",6,46,"usa","mexico",823,1151,"B737"),("franck","S811",10,1,"mexico","italy",662,572,"B737"),("alice","A310",7,19,"spain","france",878,107,"A330"),("dave","F697",10,7,"mexico","italy",606,21,"B747"),("eve","L187",10,41,"uk","spain",499,931,"A350"),("charlie","H149",4,57,"spain","uk",793,275,"B747"),("bob","D870",15,0,"italy","spain",204,1135,"B747"),("eve","Q842",0,12,"canada","usa",528,1413,"A350"),("eve","D918",14,54,"canada","mexico",629,894,"B737"),("alice","P792",23,58,"italy","italy",835,1405,"B737"),("eve","S785",14,36,"italy","france",544,621,"B737"),("charlie","L839",4,39,"france","uk",51,609,"B737"),("franck","R020",9,58,"uk","canada",495,980,"A380"),("alice","J300",16,21,"usa","france",363,1352,"A330"),("dave","H894",14,59,"france","mexico",313,253,"B747"),("dave","W724",17,42,"spain","mexico",793,1099,"A350"),("bob","E549",18,32,"uk","spain",501,899,"A350"),("dave","I667",5,41,"spain","italy",702,996,"A350"),("bob","R547",5,41,"italy","usa",492,656,"B737"),("eve","C388",16,11,"spain","uk",623,478,"A380"),("eve","Q816",1,18,"italy","uk",290,1200,"A350"),("bob","P046",14,34,"uk","canada",402,885,"B747"),("charlie","N751",13,27,"france","uk",987,1202,"B737"),("bob","J518",22,56,"france","usa",182,834,"A350"),("bob","F174",15,0,"usa","uk",181,1257,"A350"),("franck","B096",10,18,"canada","uk",191,1297,"A350"),("dave","L396",10,26,"uk","france",712,549,"A330"),("charlie","J068",9,11,"italy","usa",354,921,"A350"),("charlie","E496",7,48,"canada","canada",128,173,"A380"),("eve","U628",18,36,"italy","france",247,1219,"B737"),("bob","Q481",12,0,"uk","spain",710,625,"B737"),("dave","A229",7,29,"spain","mexico",917,278,"A350"),("franck","L235",3,40,"usa","france",261,838,"A350"),("dave","L624",16,35,"uk","canada",678,214,"A330"),("charlie","S466",18,28,"uk","usa",824,220,"A380"),("charlie","P151",9,49,"italy","spain",886,1198,"B747"),("dave","K580",15,35,"mexico","uk",745,436,"A350");

Insertions

• Effectuer une insertion minimale dans la table pilots
• Effectuer une insertion minimale dans la table flights

Pilotes

• Les pilotes âgés de plus de 50 ans
  • Nom, Âge, Nationalité, Expérience, Vols hebdomadaires

+----------------------+-----+---------+------------+----------------+
| name                 | age | country | experience | weekly_flights |
+----------------------+-----+---------+------------+----------------+
| Odysseus Gill        |  51 | uk      |         11 |              1 |
| Carla Drake          |  54 | france  |         23 |              8 |
...
| Roanna Frost         |  56 | france  |         20 |              5 |
| Amena Howe           |  54 | canada  |         20 |              3 |
+----------------------+-----+---------+------------+----------------+

• Les pilotes européens
  • Nom, Nationalité

+----------------------+---------------+
| `Nom`                | `Nationalité` |
+----------------------+---------------+
| Dacey Ward           | uk            |
| Timothy Foley        | spain         |
...
| Ulric Hooper         | spain         |
| Roanna Frost         | france        |
+----------------------+---------------+

• Les pilotes de nationalité autre que les États-Unis
  • Nom, Nationalité

+----------------------+---------------+
| `Nom`                | `Nationalité` |
+----------------------+---------------+
| Dacey Ward           | uk            |
| Timothy Foley        | spain         |
...
| Amena Howe           | canada        |
| Sarah Allen          | mexico        |
+----------------------+---------------+

• Les pilotes en service, ceux qui effectuent des vols hebdomadaires
  • Ajouter la colonne Vols annuels qui calcule le nombre de vols effectué dans une année, en supposant aucuns congés
  • Nom, Expérience, Vols hebdomadaires, Vols annuels

+------------------+--------------+----------------------+----------------+
| `Nom`            | `Expérience` | `Vols hebdomadaires` | *Vols annuels* |
+------------------+--------------+----------------------+----------------+
| Dacey Ward       |           29 |                    9 |            468 |
| Timothy Foley    |           15 |                    3 |            156 |
...
| Amena Howe       |           20 |                    3 |            156 |
| Sarah Allen      |           23 |                    4 |            208 |
+------------------+--------------+----------------------+----------------+

• Tous les pilotes qui ont piloté plus de la moitié de leur vie
  • Ajouter la colonne % d'expérience qui calcule la portion de la vie du pilote passée à piloter (il est possible d'obtenir >100% dans les données aléatoires si expérience > âge)
  • Nom, Âge, Expérience, % Exp.

+-----------------+-------+--------------+----------+
| `Nom`           | `Age` | `Experience` |  *% Exp* |
+-----------------+-------+--------------+----------+
| Dacey Ward      |    26 |           29 | 111.5385 |
| Kyla Bryan      |    25 |           14 |  56.0000 |
...
| Basil Estrada   |    29 |           21 |  72.4138 |
| Dane Brooks     |    48 |           28 |  58.3333 |
+-----------------+-------+--------------+----------+

Vols

• Tous les vols du pilote alice dans un avion airbus(Axyz)
  • La colonne Départ réunit l'heure et les minutes du départ
  • Numéro, Départ, Origine, Destination, Durée, Retard, Avion
  • Consulter la documentation des fonctions String pour respecter le formatage demandé

+--------+-------------+--------+-------------+------------------+---------------+-------+
| number | *departure* | origin | destination | duration_minutes | delay_minutes | plane |
+--------+-------------+--------+-------------+------------------+---------------+-------+
| C877   | 18:7        | italy  | france      |              900 |           582 | A380  |
| T994   | 10:51       | usa    | usa         |              628 |           646 | A380  |
...
| A310   | 7:19        | spain  | france      |              878 |           107 | A330  |
| J300   | 16:21       | usa    | france      |              363 |          1352 | A330  |
+--------+-------------+--------+-------------+------------------+---------------+-------+

• Tous les vols intra-europe
  • Pilote, Numéro, Origine, Destination

+---------+--------+--------+-------------+
| pilot   | number | origin | destination |
+---------+--------+--------+-------------+
| bob     | X656   | france | uk          |
| dave    | N354   | france | spain       |
...
| dave    | L396   | uk     | france      |
| bob     | Q481   | uk     | spain       |
+---------+--------+--------+-------------+

• Tous les vols en retard d'au moins 1 heure
  • La colonne Départ réunit l'heure et les minutes du départ
  • La colonne Durée transforme les unités minutes en format lisible heures-minutes, ex: 9h42
  • Ajouter la colonne Arrivée prévue qui calcule l'heure d'arrivée selon la durée
  • La colonne Retard transforme les unités minutes en format lisible heures-minutes, ex: 9h42
  • Ajouter la colonne Arrivée réelle qui calcule l'heure d'arrivée selon la durée, en considérant le retard
  • Pilote, Numéro, Origine, Destination, Avion, Départ, Durée, Arrivée prévue, Retard, Arrivée réelle
  • Consulter la documentation des fonctions DIV et MOD pour effectuer les calculs
  • Trouver une fonction permettant de formatter l'affichage des minutes, ex: 9:0 => 9:00
  • [BONUS] Considérer la journée dans les colonnes *Arrivée prévue* et *Arrivée réelle*, ex: 0j 9:42, 2j 15:23

+----------+-----------+-----------+---------------+---------+-----------+----------+--------------------+----------+-------------------+
| `Pilote` | `Numéro`  | `Origine` | `Destination` | `Avion` | *Départ*  | *Durée*  | *Arrivée prévue*   | *Retard* | *Arrivée réelle*  |
+----------+-----------+-----------+---------------+---------+-----------+----------+--------------------+----------+-------------------+
| dave     | X553      | usa       | italy         | A350    | 19:57     | 11h42    | 7:39               | 19h46    | 3:25              |
| charlie  | G683      | italy     | italy         | B747    | 22:37     | 10h23    | 9:00               | 7h18     | 16:18             |
...
| charlie  | P151      | italy     | spain         | B747    | 9:49      | 14h46    | 0:35               | 19h58    | 20:33             |
| dave     | K580      | mexico    | uk            | A350    | 15:35     | 12h25    | 4:00               | 7h16     | 11:16             |
+----------+-----------+-----------+---------------+---------+-----------+----------+--------------------+----------+-------------------+

Remise

21 septembre, 8h AM via LÉA

• Envoyer uniquement le fichier .sql fournis contenant vos requêtes
  • Inscrire votre nom en commentaire

Critères d'évaluation

Laboratoire 1 - 5% / 27

Nom: ____________________________________