-- MySQL dump 10.13  Distrib 8.0.20, for Win64 (x86_64)
--
-- Host: localhost    Database: car_fuel
-- ------------------------------------------------------
-- Server version	8.0.20

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `car_make`
--

DROP TABLE IF EXISTS `car_make`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `car_make` (
  `make_id` int unsigned NOT NULL AUTO_INCREMENT,
  `make` varchar(50) NOT NULL,
  PRIMARY KEY (`make_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `car_make`
--

LOCK TABLES `car_make` WRITE;
/*!40000 ALTER TABLE `car_make` DISABLE KEYS */;
INSERT INTO `car_make` VALUES (1,'ACURA'),(2,'ASTON MARTIN'),(3,'AUDI'),(4,'BENTLEY'),(5,'BMW'),(6,'BUGATTI'),(7,'BUICK'),(8,'CADILLAC'),(9,'CHEVROLET'),(10,'CHRYSLER'),(11,'DODGE'),(12,'FIAT'),(13,'FORD'),(14,'GMC'),(15,'HONDA'),(16,'HYUNDAI'),(17,'INFINITI'),(18,'JAGUAR'),(19,'JEEP'),(20,'KIA'),(21,'LAMBORGHINI'),(22,'LAND ROVER'),(23,'LEXUS'),(24,'LINCOLN'),(25,'MASERATI'),(26,'MAZDA'),(27,'MERCEDES-BENZ'),(28,'MINI'),(29,'MITSUBISHI'),(30,'NISSAN'),(31,'PORSCHE'),(32,'RAM'),(33,'ROLLS-ROYCE'),(34,'SCION'),(35,'SMART'),(36,'SUBARU'),(37,'SUZUKI'),(38,'TOYOTA'),(39,'VOLKSWAGEN'),(40,'VOLVO');
/*!40000 ALTER TABLE `car_make` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `car_vehicle_class`
--

DROP TABLE IF EXISTS `car_vehicle_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `car_vehicle_class` (
  `﻿class_id` int unsigned NOT NULL AUTO_INCREMENT,
  `vehicle_class` varchar(200) NOT NULL,
  PRIMARY KEY (`﻿class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `car_vehicle_class`
--

LOCK TABLES `car_vehicle_class` WRITE;
/*!40000 ALTER TABLE `car_vehicle_class` DISABLE KEYS */;
INSERT INTO `car_vehicle_class` VALUES (1,'SUV'),(2,'MID-SIZE'),(3,'COMPACT'),(4,'MINICOMPACT'),(5,'SUBCOMPACT'),(6,'TWO-SEATER'),(7,'STATION WAGON - SMALL'),(8,'FULL-SIZE'),(9,'PICKUP TRUCK - STANDARD'),(10,'PICKUP TRUCK - SMALL'),(11,'VAN - CARGO'),(12,'VAN - PASSENGER'),(13,'MINIVAN'),(14,'SPECIAL PURPOSE VEHICLE'),(15,'STATION WAGON - MID-SIZE');
/*!40000 ALTER TABLE `car_vehicle_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fuel_consumption`
--

DROP TABLE IF EXISTS `fuel_consumption`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fuel_consumption` (
  `﻿fuel_consumption_id` int unsigned NOT NULL AUTO_INCREMENT,
  `make_id` int unsigned NOT NULL,
  `class_id` int unsigned NOT NULL,
  `fuel_consumption` double NOT NULL,
  `transmission_id` int unsigned DEFAULT NULL,
  `fuel_type_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`﻿fuel_consumption_id`),
  KEY `make_id` (`make_id`),
  KEY `class_id_idx` (`class_id`),
  KEY `transmission_id` (`transmission_id`),
  KEY `fuel_type_id` (`fuel_type_id`),
  CONSTRAINT `class_id` FOREIGN KEY (`class_id`) REFERENCES `car_vehicle_class` (`﻿class_id`),
  CONSTRAINT `fuel_consumption_ibfk_1` FOREIGN KEY (`make_id`) REFERENCES `car_make` (`make_id`) ON UPDATE CASCADE,
  CONSTRAINT `fuel_consumption_ibfk_2` FOREIGN KEY (`transmission_id`) REFERENCES `transmission` (`transmission_id`) ON UPDATE CASCADE,
  CONSTRAINT `fuel_consumption_ibfk_3` FOREIGN KEY (`fuel_type_id`) REFERENCES `fuel_type` (`fuel_type_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1093 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fuel_consumption`
--

LOCK TABLES `fuel_consumption` WRITE;
/*!40000 ALTER TABLE `fuel_consumption` DISABLE KEYS */;
INSERT INTO `fuel_consumption` VALUES (1,1,1,14.8,NULL,NULL),(2,1,1,13.2,NULL,NULL),(3,1,2,13.7,NULL,NULL),(4,1,2,11.8,NULL,NULL),(5,1,2,12.9,NULL,NULL),(6,1,2,13.4,NULL,NULL),(7,1,3,10.6,NULL,NULL),(8,1,3,11.3,NULL,NULL),(9,1,3,12.1,NULL,NULL),(10,1,1,14.3,NULL,NULL),(11,2,4,18,NULL,NULL),(12,2,4,20.8,NULL,NULL),(13,2,4,20,NULL,NULL),(14,2,4,21.1,NULL,NULL),(15,2,5,18.6,NULL,NULL),(16,2,6,21.1,NULL,NULL),(17,2,6,17,NULL,NULL),(18,2,6,18.1,NULL,NULL),(19,2,6,17.3,NULL,NULL),(20,2,4,18.7,NULL,NULL),(21,3,7,10.8,NULL,NULL),(22,3,7,11.8,NULL,NULL),(23,3,7,11,NULL,NULL),(24,3,7,7.9,NULL,NULL),(25,3,3,10.2,NULL,NULL),(26,3,7,11.4,NULL,NULL),(27,3,3,11.4,NULL,NULL),(28,3,3,10.9,NULL,NULL),(29,3,5,11.4,NULL,NULL),(30,3,5,11.4,NULL,NULL),(31,3,5,10.9,NULL,NULL),(32,3,2,12.8,NULL,NULL),(33,3,2,12.9,NULL,NULL),(34,3,2,13.5,NULL,NULL),(35,3,8,13.5,NULL,NULL),(36,3,8,17.3,NULL,NULL),(37,3,1,12,NULL,NULL),(38,3,1,13,NULL,NULL),(39,3,1,15.2,NULL,NULL),(40,3,1,13.8,NULL,NULL),(41,3,6,18.1,NULL,NULL),(42,3,6,21.1,NULL,NULL),(43,3,6,18.8,NULL,NULL),(44,3,6,21.1,NULL,NULL),(45,3,6,18.1,NULL,NULL),(46,3,6,21.1,NULL,NULL),(47,3,6,18.8,NULL,NULL),(48,3,6,21.1,NULL,NULL),(49,3,3,13.6,NULL,NULL),(50,3,3,13.7,NULL,NULL),(51,3,5,14.5,NULL,NULL),(52,3,5,14.4,NULL,NULL),(53,3,5,16.8,NULL,NULL),(54,3,5,10.4,NULL,NULL),(55,3,6,10.4,NULL,NULL),(56,3,5,13.8,NULL,NULL),(57,3,5,11.5,NULL,NULL),(58,3,6,11.5,NULL,NULL),(59,4,2,21.1,NULL,NULL),(60,4,3,20.7,NULL,NULL),(61,4,5,21.1,NULL,NULL),(62,4,6,20.2,NULL,NULL),(63,4,6,20.7,NULL,NULL),(64,4,2,22.4,NULL,NULL),(65,5,5,12.9,NULL,NULL),(66,5,5,12.2,NULL,NULL),(67,5,5,12.8,NULL,NULL),(68,5,5,12.2,NULL,NULL),(69,5,5,13.2,NULL,NULL),(70,5,5,12.7,NULL,NULL),(71,5,5,13.1,NULL,NULL),(72,5,5,11.8,NULL,NULL),(73,5,5,12.9,NULL,NULL),(74,5,5,13.7,NULL,NULL),(75,5,5,12.8,NULL,NULL),(76,5,5,12.2,NULL,NULL),(77,5,5,13.4,NULL,NULL),(78,5,5,13.9,NULL,NULL),(79,5,7,13.4,NULL,NULL),(80,5,7,13.9,NULL,NULL),(81,5,5,13,NULL,NULL),(82,5,5,12.7,NULL,NULL),(83,5,5,13,NULL,NULL),(84,5,5,12.7,NULL,NULL),(85,5,5,12.8,NULL,NULL),(86,5,5,12.5,NULL,NULL),(87,5,5,13.8,NULL,NULL),(88,5,5,13.4,NULL,NULL),(89,5,5,13.8,NULL,NULL),(90,5,5,13.4,NULL,NULL),(91,5,2,9.9,NULL,NULL),(92,5,2,10.1,NULL,NULL),(93,5,2,11.1,NULL,NULL),(94,5,8,13,NULL,NULL),(95,5,2,15.1,NULL,NULL),(96,5,8,15.5,NULL,NULL),(97,5,3,15.2,NULL,NULL),(98,5,3,16.1,NULL,NULL),(99,5,3,15.5,NULL,NULL),(100,5,3,15.1,NULL,NULL),(101,5,8,17.1,NULL,NULL),(102,5,8,17.1,NULL,NULL),(103,5,8,18.5,NULL,NULL),(104,5,8,13.7,NULL,NULL),(105,5,8,17.3,NULL,NULL),(106,5,5,17.3,NULL,NULL),(107,5,5,17.4,NULL,NULL),(108,5,5,17.1,NULL,NULL),(109,5,5,16.9,NULL,NULL),(110,5,1,11.6,NULL,NULL),(111,5,1,12.3,NULL,NULL),(112,5,1,12.6,NULL,NULL),(113,5,1,18.7,NULL,NULL),(114,5,1,12.2,NULL,NULL),(115,5,1,14.7,NULL,NULL),(116,5,1,17,NULL,NULL),(117,5,1,18.7,NULL,NULL),(118,5,1,14.7,NULL,NULL),(119,5,1,17,NULL,NULL),(120,5,6,9.5,NULL,NULL),(121,5,6,10.6,NULL,NULL),(122,5,6,13.8,NULL,NULL),(123,5,6,12.7,NULL,NULL),(124,5,6,13.8,NULL,NULL),(125,6,6,28.5,NULL,NULL),(126,7,1,14.3,NULL,NULL),(127,7,1,14.7,NULL,NULL),(128,7,2,13.6,NULL,NULL),(129,7,2,18.5,NULL,NULL),(130,7,2,14.3,NULL,NULL),(131,7,2,19.3,NULL,NULL),(132,7,2,9.6,NULL,NULL),(133,7,2,12.8,NULL,NULL),(134,7,2,17.3,NULL,NULL),(135,7,2,11.9,NULL,NULL),(136,7,2,15.7,NULL,NULL),(137,7,2,12.1,NULL,NULL),(138,7,2,15.9,NULL,NULL),(139,7,2,9.6,NULL,NULL),(140,7,2,12.5,NULL,NULL),(141,7,2,12.6,NULL,NULL),(142,7,3,11.3,NULL,NULL),(143,7,3,15.6,NULL,NULL),(144,8,2,12.8,NULL,NULL),(145,8,2,14.7,NULL,NULL),(146,8,2,12.9,NULL,NULL),(147,8,2,13.4,NULL,NULL),(148,8,2,13.3,NULL,NULL),(149,8,7,12.8,NULL,NULL),(150,8,7,13.2,NULL,NULL),(151,8,7,13.4,NULL,NULL),(152,8,7,13.3,NULL,NULL),(153,8,2,19.6,NULL,NULL),(154,8,2,16.6,NULL,NULL),(155,8,7,19.6,NULL,NULL),(156,8,7,16.6,NULL,NULL),(157,8,1,17,NULL,NULL),(158,8,1,23.3,NULL,NULL),(159,8,1,18.8,NULL,NULL),(160,8,1,25.8,NULL,NULL),(161,8,1,11.8,NULL,NULL),(162,8,1,14.3,NULL,NULL),(163,8,1,18.9,NULL,NULL),(164,8,1,14.8,NULL,NULL),(165,8,1,19.7,NULL,NULL),(166,9,9,16,NULL,NULL),(167,9,9,21.5,NULL,NULL),(168,9,9,16.1,NULL,NULL),(169,9,9,21.5,NULL,NULL),(170,9,3,12.9,NULL,NULL),(171,9,3,13.9,NULL,NULL),(172,9,3,12.7,NULL,NULL),(173,9,3,15.1,NULL,NULL),(174,9,3,15,NULL,NULL),(175,9,3,19.6,NULL,NULL),(176,9,3,16.6,NULL,NULL),(177,9,10,12.8,NULL,NULL),(178,9,10,12.9,NULL,NULL),(179,9,10,14,NULL,NULL),(180,9,10,16.1,NULL,NULL),(181,9,10,13.5,NULL,NULL),(182,9,10,13.2,NULL,NULL),(183,9,10,14.5,NULL,NULL),(184,9,10,16.9,NULL,NULL),(185,9,10,15.4,NULL,NULL),(186,9,10,14.9,NULL,NULL),(187,9,10,12.8,NULL,NULL),(188,9,10,12.9,NULL,NULL),(189,9,10,14.2,NULL,NULL),(190,9,10,16.1,NULL,NULL),(191,9,10,14.9,NULL,NULL),(192,9,10,16.9,NULL,NULL),(193,9,6,16,NULL,NULL),(194,9,6,14.5,NULL,NULL),(195,9,6,16,NULL,NULL),(196,9,6,17.1,NULL,NULL),(197,9,2,9.1,NULL,NULL),(198,9,2,9.1,NULL,NULL),(199,9,2,10.5,NULL,NULL),(200,9,2,9.5,NULL,NULL),(201,9,2,8.9,NULL,NULL),(202,9,2,8.4,NULL,NULL),(203,9,1,10.5,NULL,NULL),(204,9,1,15.2,NULL,NULL),(205,9,1,13.9,NULL,NULL),(206,9,1,18.8,NULL,NULL),(207,9,1,11.5,NULL,NULL),(208,9,1,16,NULL,NULL),(209,9,1,14.5,NULL,NULL),(210,9,1,19.6,NULL,NULL),(211,9,11,15.7,NULL,NULL),(212,9,11,18,NULL,NULL),(213,9,11,23.5,NULL,NULL),(214,9,11,18.3,NULL,NULL),(215,9,11,25.3,NULL,NULL),(216,9,11,18.6,NULL,NULL),(217,9,11,23.9,NULL,NULL),(218,9,11,18.3,NULL,NULL),(219,9,11,25.3,NULL,NULL),(220,9,12,18.6,NULL,NULL),(221,9,12,23.9,NULL,NULL),(222,9,12,18.3,NULL,NULL),(223,9,12,25.3,NULL,NULL),(224,9,12,21.1,NULL,NULL),(225,9,12,28.3,NULL,NULL),(226,9,12,21.9,NULL,NULL),(227,9,12,30,NULL,NULL),(228,9,12,21.1,NULL,NULL),(229,9,12,28.3,NULL,NULL),(230,9,12,22.3,NULL,NULL),(231,9,12,30.4,NULL,NULL),(232,9,8,13.2,NULL,NULL),(233,9,8,17.2,NULL,NULL),(234,9,2,10.8,NULL,NULL),(235,9,2,15.7,NULL,NULL),(236,9,2,13.9,NULL,NULL),(237,9,1,12,NULL,NULL),(238,9,1,11.5,NULL,NULL),(239,9,9,15.7,NULL,NULL),(240,9,9,16.9,NULL,NULL),(241,9,9,22.3,NULL,NULL),(242,9,9,16,NULL,NULL),(243,9,9,21.5,NULL,NULL),(244,9,9,18.8,NULL,NULL),(245,9,9,25.5,NULL,NULL),(246,9,9,16.7,NULL,NULL),(247,9,9,17.7,NULL,NULL),(248,9,9,23.3,NULL,NULL),(249,9,9,16,NULL,NULL),(250,9,9,21.5,NULL,NULL),(251,9,9,19.6,NULL,NULL),(252,9,9,26.6,NULL,NULL),(253,9,9,11.5,NULL,NULL),(254,9,9,11.6,NULL,NULL),(255,9,9,15.3,NULL,NULL),(256,9,9,20.7,NULL,NULL),(257,9,3,8.5,NULL,NULL),(258,9,3,9.6,NULL,NULL),(259,9,3,8.9,NULL,NULL),(260,9,5,8.5,NULL,NULL),(261,9,5,9.6,NULL,NULL),(262,9,5,8.9,NULL,NULL),(263,9,1,16,NULL,NULL),(264,9,1,21.5,NULL,NULL),(265,9,1,16.1,NULL,NULL),(266,9,1,21.5,NULL,NULL),(267,9,1,22.8,NULL,NULL),(268,9,1,22.7,NULL,NULL),(269,9,1,16,NULL,NULL),(270,9,1,21.5,NULL,NULL),(271,9,1,16.1,NULL,NULL),(272,9,1,21.5,NULL,NULL),(273,9,1,11.5,NULL,NULL),(274,9,1,11.6,NULL,NULL),(275,9,1,14.3,NULL,NULL),(276,9,1,14.7,NULL,NULL),(277,10,2,11.3,NULL,NULL),(278,10,2,11.9,NULL,NULL),(279,10,8,12.3,NULL,NULL),(280,10,8,13.2,NULL,NULL),(281,10,2,11.7,NULL,NULL),(282,10,2,13,NULL,NULL),(283,10,2,12.5,NULL,NULL),(284,10,2,17,NULL,NULL),(285,10,2,12.5,NULL,NULL),(286,10,2,17,NULL,NULL),(287,10,8,12.9,NULL,NULL),(288,10,8,12.9,NULL,NULL),(289,10,8,17.3,NULL,NULL),(290,10,8,13.2,NULL,NULL),(291,10,8,18.3,NULL,NULL),(292,10,8,12.3,NULL,NULL),(293,10,8,16.8,NULL,NULL),(294,10,8,16.7,NULL,NULL),(295,10,8,15.1,NULL,NULL),(296,10,8,16.1,NULL,NULL),(297,10,13,13.7,NULL,NULL),(298,10,13,19.1,NULL,NULL),(299,11,2,11.3,NULL,NULL),(300,11,2,11.9,NULL,NULL),(301,11,2,12.5,NULL,NULL),(302,11,2,17,NULL,NULL),(303,11,2,10.3,NULL,NULL),(304,11,2,9.8,NULL,NULL),(305,11,2,10.9,NULL,NULL),(306,11,3,13.2,NULL,NULL),(307,11,3,15.6,NULL,NULL),(308,11,3,15.1,NULL,NULL),(309,11,3,16.8,NULL,NULL),(310,11,3,16.7,NULL,NULL),(311,11,8,12.3,NULL,NULL),(312,11,8,13.2,NULL,NULL),(313,11,8,15.1,NULL,NULL),(314,11,8,12.9,NULL,NULL),(315,11,8,16.1,NULL,NULL),(316,11,8,12.9,NULL,NULL),(317,11,8,17.3,NULL,NULL),(318,11,8,13.2,NULL,NULL),(319,11,8,18.3,NULL,NULL),(320,11,8,12.3,NULL,NULL),(321,11,8,16.8,NULL,NULL),(322,11,8,16.7,NULL,NULL),(323,11,1,18.4,NULL,NULL),(324,11,1,14.6,NULL,NULL),(325,11,1,19.1,NULL,NULL),(326,11,13,13.7,NULL,NULL),(327,11,13,19.1,NULL,NULL),(328,11,1,12.2,NULL,NULL),(329,11,1,14.6,NULL,NULL),(330,11,1,14.2,NULL,NULL),(331,11,1,18.8,NULL,NULL),(332,12,4,8.6,NULL,NULL),(333,12,4,7.9,NULL,NULL),(334,12,4,8.3,NULL,NULL),(335,13,11,17.9,NULL,NULL),(336,13,11,24.5,NULL,NULL),(337,13,11,19.3,NULL,NULL),(338,13,11,24.9,NULL,NULL),(339,13,12,18.6,NULL,NULL),(340,13,12,25.5,NULL,NULL),(341,13,12,19.9,NULL,NULL),(342,13,12,25.7,NULL,NULL),(343,13,12,24.2,NULL,NULL),(344,13,12,20.6,NULL,NULL),(345,13,12,26.7,NULL,NULL),(346,13,1,11.3,NULL,NULL),(347,13,1,12.6,NULL,NULL),(348,13,1,13.3,NULL,NULL),(349,13,1,13.7,NULL,NULL),(350,13,1,11.4,NULL,NULL),(351,13,1,10.4,NULL,NULL),(352,13,1,11.6,NULL,NULL),(353,13,1,13,NULL,NULL),(354,13,1,18,NULL,NULL),(355,13,1,12.3,NULL,NULL),(356,13,1,16.7,NULL,NULL),(357,13,1,6.9,NULL,NULL),(358,13,1,7.8,NULL,NULL),(359,13,1,18.2,NULL,NULL),(360,13,1,24.4,NULL,NULL),(361,13,1,11.8,NULL,NULL),(362,13,1,13.2,NULL,NULL),(363,13,1,14,NULL,NULL),(364,13,9,14.5,NULL,NULL),(365,13,9,14.5,NULL,NULL),(366,13,9,18.7,NULL,NULL),(367,13,9,15.6,NULL,NULL),(368,13,9,15.6,NULL,NULL),(369,13,9,20.4,NULL,NULL),(370,13,9,14.3,NULL,NULL),(371,13,9,19.3,NULL,NULL),(372,13,9,14.3,NULL,NULL),(373,13,9,19.3,NULL,NULL),(374,13,9,15.6,NULL,NULL),(375,13,9,20.8,NULL,NULL),(376,13,9,15.6,NULL,NULL),(377,13,9,20.8,NULL,NULL),(378,13,9,15,NULL,NULL),(379,13,9,20.3,NULL,NULL),(380,13,9,15,NULL,NULL),(381,13,9,20.3,NULL,NULL),(382,13,9,16.6,NULL,NULL),(383,13,9,22.1,NULL,NULL),(384,13,9,16.7,NULL,NULL),(385,13,9,22.1,NULL,NULL),(386,13,9,20.4,NULL,NULL),(387,13,5,8.1,NULL,NULL),(388,13,5,8.1,NULL,NULL),(389,13,5,8,NULL,NULL),(390,13,1,14.2,NULL,NULL),(391,13,1,14.8,NULL,NULL),(392,13,1,15,NULL,NULL),(393,13,3,8.5,NULL,NULL),(394,13,3,8.6,NULL,NULL),(395,13,3,9.1,NULL,NULL),(396,13,3,8.4,NULL,NULL),(397,13,2,10.3,NULL,NULL),(398,13,2,10.9,NULL,NULL),(399,13,2,10.8,NULL,NULL),(400,13,2,13.8,NULL,NULL),(401,13,2,12,NULL,NULL),(402,13,2,16.6,NULL,NULL),(403,13,2,13.4,NULL,NULL),(404,13,2,18.2,NULL,NULL),(405,13,2,5.7,NULL,NULL),(406,13,2,10.9,NULL,NULL),(407,13,5,12.5,NULL,NULL),(408,13,5,13.1,NULL,NULL),(409,13,5,13.2,NULL,NULL),(410,13,5,13.7,NULL,NULL),(411,13,5,16.2,NULL,NULL),(412,13,5,13.4,NULL,NULL),(413,13,8,13,NULL,NULL),(414,13,8,13.5,NULL,NULL),(415,13,8,13.7,NULL,NULL),(416,13,8,13.9,NULL,NULL),(417,13,14,11.3,NULL,NULL),(418,13,14,11,NULL,NULL),(419,14,1,14.3,NULL,NULL),(420,14,1,14.7,NULL,NULL),(421,14,10,12.8,NULL,NULL),(422,14,10,12.9,NULL,NULL),(423,14,10,14,NULL,NULL),(424,14,10,16.1,NULL,NULL),(425,14,10,13.5,NULL,NULL),(426,14,10,13.2,NULL,NULL),(427,14,10,14.5,NULL,NULL),(428,14,10,16.9,NULL,NULL),(429,14,10,15.4,NULL,NULL),(430,14,10,14.9,NULL,NULL),(431,14,10,12.8,NULL,NULL),(432,14,10,12.9,NULL,NULL),(433,14,10,14.2,NULL,NULL),(434,14,10,16.1,NULL,NULL),(435,14,10,14.9,NULL,NULL),(436,14,10,16.9,NULL,NULL),(437,14,11,15.7,NULL,NULL),(438,14,11,18,NULL,NULL),(439,14,11,23.5,NULL,NULL),(440,14,11,18.3,NULL,NULL),(441,14,11,25.3,NULL,NULL),(442,14,11,18.6,NULL,NULL),(443,14,11,23.9,NULL,NULL),(444,14,11,18.3,NULL,NULL),(445,14,11,25.3,NULL,NULL),(446,14,12,18.6,NULL,NULL),(447,14,12,23.9,NULL,NULL),(448,14,12,18.3,NULL,NULL),(449,14,12,25.3,NULL,NULL),(450,14,12,21.1,NULL,NULL),(451,14,12,28.3,NULL,NULL),(452,14,12,21.9,NULL,NULL),(453,14,12,30,NULL,NULL),(454,14,12,21.1,NULL,NULL),(455,14,12,28.3,NULL,NULL),(456,14,12,22.3,NULL,NULL),(457,14,12,30.4,NULL,NULL),(458,14,9,15.7,NULL,NULL),(459,14,9,16.9,NULL,NULL),(460,14,9,22.3,NULL,NULL),(461,14,9,16,NULL,NULL),(462,14,9,21.5,NULL,NULL),(463,14,9,18.8,NULL,NULL),(464,14,9,25.5,NULL,NULL),(465,14,9,16.7,NULL,NULL),(466,14,9,17.7,NULL,NULL),(467,14,9,23.3,NULL,NULL),(468,14,9,16,NULL,NULL),(469,14,9,21.5,NULL,NULL),(470,14,9,19.6,NULL,NULL),(471,14,9,26.6,NULL,NULL),(472,14,9,19.3,NULL,NULL),(473,14,9,26.3,NULL,NULL),(474,14,9,11.5,NULL,NULL),(475,14,9,11.6,NULL,NULL),(476,14,9,15.3,NULL,NULL),(477,14,9,20.7,NULL,NULL),(478,14,1,10.5,NULL,NULL),(479,14,1,15.2,NULL,NULL),(480,14,1,13.9,NULL,NULL),(481,14,1,18.8,NULL,NULL),(482,14,1,11.5,NULL,NULL),(483,14,1,16,NULL,NULL),(484,14,1,14.5,NULL,NULL),(485,14,1,19.6,NULL,NULL),(486,14,1,16,NULL,NULL),(487,14,1,21.5,NULL,NULL),(488,14,1,16.1,NULL,NULL),(489,14,1,21.5,NULL,NULL),(490,14,1,17,NULL,NULL),(491,14,1,23.3,NULL,NULL),(492,14,1,11.8,NULL,NULL),(493,14,1,11.5,NULL,NULL),(494,14,1,11.6,NULL,NULL),(495,14,1,16,NULL,NULL),(496,14,1,21.5,NULL,NULL),(497,14,1,16.1,NULL,NULL),(498,14,1,21.5,NULL,NULL),(499,14,1,22.8,NULL,NULL),(500,14,1,18.8,NULL,NULL),(501,14,1,25.8,NULL,NULL),(502,14,1,22.7,NULL,NULL),(503,15,3,10.5,NULL,NULL),(504,15,3,10.3,NULL,NULL),(505,15,3,12.1,NULL,NULL),(506,15,3,13.4,NULL,NULL),(507,15,8,10.3,NULL,NULL),(508,15,8,10.1,NULL,NULL),(509,15,8,11.7,NULL,NULL),(510,15,1,13.3,NULL,NULL),(511,15,3,8.4,NULL,NULL),(512,15,3,8.4,NULL,NULL),(513,15,3,11.4,NULL,NULL),(514,15,3,5.4,NULL,NULL),(515,15,1,10.3,NULL,NULL),(516,15,1,10.5,NULL,NULL),(517,15,6,6.7,NULL,NULL),(518,15,6,7.7,NULL,NULL),(519,15,7,8.3,NULL,NULL),(520,15,7,8.3,NULL,NULL),(521,15,3,5.8,NULL,NULL),(522,15,13,13.2,NULL,NULL),(523,15,13,12.3,NULL,NULL),(524,15,1,13.3,NULL,NULL),(525,15,1,13.8,NULL,NULL),(526,15,9,15.2,NULL,NULL),(527,16,3,8.3,NULL,NULL),(528,16,3,8.3,NULL,NULL),(529,16,2,8.4,NULL,NULL),(530,16,2,8.3,NULL,NULL),(531,16,7,10,NULL,NULL),(532,16,7,10.2,NULL,NULL),(533,16,8,15.3,NULL,NULL),(534,16,8,12.9,NULL,NULL),(535,16,5,11.9,NULL,NULL),(536,16,5,11.4,NULL,NULL),(537,16,5,13.7,NULL,NULL),(538,16,5,13.5,NULL,NULL),(539,16,8,15.1,NULL,NULL),(540,16,1,11.8,NULL,NULL),(541,16,1,12.5,NULL,NULL),(542,16,1,11.6,NULL,NULL),(543,16,1,12,NULL,NULL),(544,16,1,12,NULL,NULL),(545,16,8,10.5,NULL,NULL),(546,16,8,10,NULL,NULL),(547,16,8,10,NULL,NULL),(548,16,2,6.8,NULL,NULL),(549,16,1,10.6,NULL,NULL),(550,16,1,11.8,NULL,NULL),(551,16,1,11.1,NULL,NULL),(552,16,1,11.6,NULL,NULL),(553,16,3,8.5,NULL,NULL),(554,16,3,8.7,NULL,NULL),(555,16,1,14.3,NULL,NULL),(556,16,1,14.8,NULL,NULL),(557,17,7,13.8,NULL,NULL),(558,17,1,15,NULL,NULL),(559,17,1,16.3,NULL,NULL),(560,17,2,11.7,NULL,NULL),(561,17,2,12,NULL,NULL),(562,17,2,13.8,NULL,NULL),(563,17,5,13.4,NULL,NULL),(564,17,5,14.5,NULL,NULL),(565,17,5,12.5,NULL,NULL),(566,17,5,13.8,NULL,NULL),(567,17,2,13.2,NULL,NULL),(568,17,5,13.2,NULL,NULL),(569,17,2,8.7,NULL,NULL),(570,17,2,13.1,NULL,NULL),(571,17,2,13.5,NULL,NULL),(572,17,2,15.2,NULL,NULL),(573,17,2,15,NULL,NULL),(574,17,1,17.4,NULL,NULL),(575,18,2,14.7,NULL,NULL),(576,18,2,15.7,NULL,NULL),(577,18,8,14.7,NULL,NULL),(578,18,8,15.7,NULL,NULL),(579,18,8,15.7,NULL,NULL),(580,18,8,15.4,NULL,NULL),(581,18,8,15.7,NULL,NULL),(582,18,8,15.7,NULL,NULL),(583,18,4,15.1,NULL,NULL),(584,18,4,14.9,NULL,NULL),(585,18,4,15.7,NULL,NULL),(586,18,4,15.7,NULL,NULL),(587,18,4,15.7,NULL,NULL),(588,19,1,10.3,NULL,NULL),(589,19,1,10.4,NULL,NULL),(590,19,1,11,NULL,NULL),(591,19,1,10.3,NULL,NULL),(592,19,1,11.3,NULL,NULL),(593,19,1,10.5,NULL,NULL),(594,19,1,18.7,NULL,NULL),(595,19,1,14.6,NULL,NULL),(596,19,1,19.1,NULL,NULL),(597,19,1,18.9,NULL,NULL),(598,19,1,15.6,NULL,NULL),(599,19,1,10.3,NULL,NULL),(600,19,1,10.4,NULL,NULL),(601,19,1,11,NULL,NULL),(602,19,1,10.3,NULL,NULL),(603,19,1,11.3,NULL,NULL),(604,19,1,10.5,NULL,NULL),(605,19,1,14.2,NULL,NULL),(606,19,1,14.3,NULL,NULL),(607,19,1,14.8,NULL,NULL),(608,19,1,15,NULL,NULL),(609,20,2,9.3,NULL,NULL),(610,20,2,9.4,NULL,NULL),(611,20,2,10.3,NULL,NULL),(612,20,2,10.5,NULL,NULL),(613,20,3,9.3,NULL,NULL),(614,20,3,9.6,NULL,NULL),(615,20,3,10.3,NULL,NULL),(616,20,3,10.5,NULL,NULL),(617,20,2,10.5,NULL,NULL),(618,20,2,9.9,NULL,NULL),(619,20,2,10,NULL,NULL),(620,20,2,6.9,NULL,NULL),(621,20,3,8.3,NULL,NULL),(622,20,3,8.1,NULL,NULL),(623,20,15,12,NULL,NULL),(624,20,15,13,NULL,NULL),(625,20,13,13,NULL,NULL),(626,20,1,11.2,NULL,NULL),(627,20,1,12,NULL,NULL),(628,20,1,11.7,NULL,NULL),(629,20,1,11.7,NULL,NULL),(630,20,1,13,NULL,NULL),(631,20,7,9.4,NULL,NULL),(632,20,7,9.4,NULL,NULL),(633,20,7,10.1,NULL,NULL),(634,20,7,9.8,NULL,NULL),(635,20,7,8.9,NULL,NULL),(636,20,1,11.1,NULL,NULL),(637,20,1,11.7,NULL,NULL),(638,20,1,11.7,NULL,NULL),(639,20,1,11.6,NULL,NULL),(640,21,6,23.1,NULL,NULL),(641,21,6,23.1,NULL,NULL),(642,21,6,18,NULL,NULL),(643,21,6,20.6,NULL,NULL),(644,21,6,18.1,NULL,NULL),(645,21,6,22.1,NULL,NULL),(646,22,1,15.7,NULL,NULL),(647,22,1,18.9,NULL,NULL),(648,22,1,12.3,NULL,NULL),(649,22,1,19.1,NULL,NULL),(650,22,1,18.7,NULL,NULL),(651,22,1,20,NULL,NULL),(652,22,1,20.3,NULL,NULL),(653,23,3,5.5,NULL,NULL),(654,23,2,12.3,NULL,NULL),(655,23,1,15.7,NULL,NULL),(656,23,3,6.7,NULL,NULL),(657,23,5,10.9,NULL,NULL),(658,23,5,12.7,NULL,NULL),(659,23,5,11.9,NULL,NULL),(660,23,5,10.9,NULL,NULL),(661,23,5,12.7,NULL,NULL),(662,23,5,12.1,NULL,NULL),(663,23,5,12.8,NULL,NULL),(664,23,5,12.1,NULL,NULL),(665,23,5,14.6,NULL,NULL),(666,23,6,21.9,NULL,NULL),(667,23,2,14.5,NULL,NULL),(668,23,2,15.1,NULL,NULL),(669,23,2,15.1,NULL,NULL),(670,23,2,12,NULL,NULL),(671,23,1,13.3,NULL,NULL),(672,23,1,7.9,NULL,NULL),(673,24,8,13.7,NULL,NULL),(674,24,8,13.9,NULL,NULL),(675,24,8,14.4,NULL,NULL),(676,24,1,15,NULL,NULL),(677,24,1,14.3,NULL,NULL),(678,24,1,13.7,NULL,NULL),(679,24,2,13.5,NULL,NULL),(680,24,2,13.8,NULL,NULL),(681,24,2,5.7,NULL,NULL),(682,24,1,18.2,NULL,NULL),(683,24,1,24.4,NULL,NULL),(684,25,5,18.1,NULL,NULL),(685,25,5,18.1,NULL,NULL),(686,25,8,19.9,NULL,NULL),(687,26,1,14.3,NULL,NULL),(688,26,1,14.4,NULL,NULL),(689,26,3,8.3,NULL,NULL),(690,26,3,8,NULL,NULL),(691,26,3,10,NULL,NULL),(692,26,3,9.4,NULL,NULL),(693,26,3,10.5,NULL,NULL),(694,26,3,11.6,NULL,NULL),(695,26,3,8.3,NULL,NULL),(696,26,3,8.9,NULL,NULL),(697,26,2,8.3,NULL,NULL),(698,26,2,8.8,NULL,NULL),(699,26,13,10.9,NULL,NULL),(700,26,13,11.1,NULL,NULL),(701,26,2,10.8,NULL,NULL),(702,26,2,11.2,NULL,NULL),(703,26,2,13.4,NULL,NULL),(704,26,2,13,NULL,NULL),(705,26,6,11.5,NULL,NULL),(706,26,6,10.5,NULL,NULL),(707,26,6,11.1,NULL,NULL),(708,27,3,11,NULL,NULL),(709,27,3,13.9,NULL,NULL),(710,27,5,11.1,NULL,NULL),(711,27,3,13.3,NULL,NULL),(712,27,3,13.3,NULL,NULL),(713,27,3,18.1,NULL,NULL),(714,27,3,12.2,NULL,NULL),(715,27,3,12.1,NULL,NULL),(716,27,5,12.2,NULL,NULL),(717,27,5,12.3,NULL,NULL),(718,27,3,17.8,NULL,NULL),(719,27,5,17.9,NULL,NULL),(720,27,3,15.4,NULL,NULL),(721,27,3,20,NULL,NULL),(722,27,3,15.4,NULL,NULL),(723,27,3,19.3,NULL,NULL),(724,27,3,14.3,NULL,NULL),(725,27,3,15.2,NULL,NULL),(726,27,2,12.6,NULL,NULL),(727,27,2,12.5,NULL,NULL),(728,27,5,12.7,NULL,NULL),(729,27,15,12.7,NULL,NULL),(730,27,2,10.8,NULL,NULL),(731,27,5,12.8,NULL,NULL),(732,27,5,12.5,NULL,NULL),(733,27,2,14.5,NULL,NULL),(734,27,5,13.7,NULL,NULL),(735,27,5,13.5,NULL,NULL),(736,27,2,15.2,NULL,NULL),(737,27,15,15.4,NULL,NULL),(738,27,1,20.4,NULL,NULL),(739,27,1,14.3,NULL,NULL),(740,27,1,14.8,NULL,NULL),(741,27,1,14.6,NULL,NULL),(742,27,1,13.8,NULL,NULL),(743,27,1,11.9,NULL,NULL),(744,27,1,16.2,NULL,NULL),(745,27,1,17.3,NULL,NULL),(746,27,8,23.2,NULL,NULL),(747,27,8,22.8,NULL,NULL),(748,27,8,23.2,NULL,NULL),(749,27,8,22.8,NULL,NULL),(750,27,1,14.7,NULL,NULL),(751,27,1,13.2,NULL,NULL),(752,27,8,11.6,NULL,NULL),(753,27,8,12.7,NULL,NULL),(754,27,8,15.4,NULL,NULL),(755,27,8,15.4,NULL,NULL),(756,27,8,20.3,NULL,NULL),(757,27,8,15.4,NULL,NULL),(758,27,8,19.3,NULL,NULL),(759,27,6,17.3,NULL,NULL),(760,27,6,19.8,NULL,NULL),(761,27,6,10.4,NULL,NULL),(762,27,6,10.3,NULL,NULL),(763,27,6,11.9,NULL,NULL),(764,27,6,12.3,NULL,NULL),(765,27,6,17.3,NULL,NULL),(766,27,6,17.3,NULL,NULL),(767,28,4,8.5,NULL,NULL),(768,28,4,8,NULL,NULL),(769,28,5,8.8,NULL,NULL),(770,28,5,8.6,NULL,NULL),(771,28,4,8.8,NULL,NULL),(772,28,4,8.6,NULL,NULL),(773,28,3,9.4,NULL,NULL),(774,28,3,8.6,NULL,NULL),(775,28,6,8.5,NULL,NULL),(776,28,6,8,NULL,NULL),(777,28,6,8.8,NULL,NULL),(778,28,6,8.6,NULL,NULL),(779,28,4,9.2,NULL,NULL),(780,28,4,8.8,NULL,NULL),(781,28,5,9.2,NULL,NULL),(782,28,5,8.8,NULL,NULL),(783,28,4,9.2,NULL,NULL),(784,28,4,8.8,NULL,NULL),(785,28,3,9.4,NULL,NULL),(786,28,3,8.9,NULL,NULL),(787,28,3,10,NULL,NULL),(788,28,3,9.3,NULL,NULL),(789,28,6,9.2,NULL,NULL),(790,28,6,8.8,NULL,NULL),(791,28,6,9.2,NULL,NULL),(792,28,6,8.8,NULL,NULL),(793,28,4,9.5,NULL,NULL),(794,28,5,9.5,NULL,NULL),(795,28,4,9.5,NULL,NULL),(796,28,6,9.5,NULL,NULL),(797,28,6,9.5,NULL,NULL),(798,29,5,11.5,NULL,NULL),(799,29,5,12,NULL,NULL),(800,29,5,14.2,NULL,NULL),(801,29,5,14.7,NULL,NULL),(802,29,4,11.6,NULL,NULL),(803,29,4,12,NULL,NULL),(804,29,4,14.2,NULL,NULL),(805,29,4,14.7,NULL,NULL),(806,29,3,13.4,NULL,NULL),(807,29,3,9.2,NULL,NULL),(808,29,3,9.7,NULL,NULL),(809,29,3,10.4,NULL,NULL),(810,29,3,14.2,NULL,NULL),(811,29,3,13.9,NULL,NULL),(812,29,7,9.6,NULL,NULL),(813,29,7,9.7,NULL,NULL),(814,29,1,10.3,NULL,NULL),(815,29,1,10.4,NULL,NULL),(816,29,1,12.5,NULL,NULL),(817,29,1,9.9,NULL,NULL),(818,29,1,10,NULL,NULL),(819,29,1,9.9,NULL,NULL),(820,30,6,12.6,NULL,NULL),(821,30,6,13.3,NULL,NULL),(822,30,6,13.2,NULL,NULL),(823,30,6,13.4,NULL,NULL),(824,30,2,10,NULL,NULL),(825,30,2,10.1,NULL,NULL),(826,30,2,11.8,NULL,NULL),(827,30,5,10.2,NULL,NULL),(828,30,5,10.3,NULL,NULL),(829,30,5,11.6,NULL,NULL),(830,30,5,12.9,NULL,NULL),(831,30,1,19.1,NULL,NULL),(832,30,7,8.7,NULL,NULL),(833,30,7,9.4,NULL,NULL),(834,30,10,13.9,NULL,NULL),(835,30,10,12.1,NULL,NULL),(836,30,10,15.9,NULL,NULL),(837,30,10,16.6,NULL,NULL),(838,30,10,15.4,NULL,NULL),(839,30,5,14.6,NULL,NULL),(840,30,7,8.7,NULL,NULL),(841,30,7,9.5,NULL,NULL),(842,30,7,9.3,NULL,NULL),(843,30,2,12.3,NULL,NULL),(844,30,1,13.2,NULL,NULL),(845,30,1,16.6,NULL,NULL),(846,30,13,12.6,NULL,NULL),(847,30,1,10.3,NULL,NULL),(848,30,1,11,NULL,NULL),(849,30,2,8.8,NULL,NULL),(850,30,2,9.8,NULL,NULL),(851,30,2,10,NULL,NULL),(852,30,2,11.2,NULL,NULL),(853,30,9,17.9,NULL,NULL),(854,30,9,19.6,NULL,NULL),(855,30,3,7.9,NULL,NULL),(856,30,3,8.7,NULL,NULL),(857,30,3,9.8,NULL,NULL),(858,30,3,8.4,NULL,NULL),(859,30,3,9.2,NULL,NULL),(860,30,1,16.2,NULL,NULL),(861,30,1,15.3,NULL,NULL),(862,31,4,12.6,NULL,NULL),(863,31,4,12.8,NULL,NULL),(864,31,4,12.9,NULL,NULL),(865,31,4,12.9,NULL,NULL),(866,31,4,13,NULL,NULL),(867,31,4,12.9,NULL,NULL),(868,31,4,12.9,NULL,NULL),(869,31,4,13.1,NULL,NULL),(870,31,4,12.8,NULL,NULL),(871,31,4,13.4,NULL,NULL),(872,31,4,12.6,NULL,NULL),(873,31,4,12.8,NULL,NULL),(874,31,4,12.8,NULL,NULL),(875,31,4,12.8,NULL,NULL),(876,31,4,12.8,NULL,NULL),(877,31,4,12.8,NULL,NULL),(878,31,4,12.6,NULL,NULL),(879,31,4,13.1,NULL,NULL),(880,31,4,12.7,NULL,NULL),(881,31,4,13,NULL,NULL),(882,31,4,12.6,NULL,NULL),(883,31,4,13.1,NULL,NULL),(884,31,4,12.9,NULL,NULL),(885,31,4,13.1,NULL,NULL),(886,31,4,12.8,NULL,NULL),(887,31,4,13.4,NULL,NULL),(888,31,4,12.7,NULL,NULL),(889,31,4,13,NULL,NULL),(890,31,4,13,NULL,NULL),(891,31,4,12.9,NULL,NULL),(892,31,4,12.8,NULL,NULL),(893,31,4,13.4,NULL,NULL),(894,31,4,14.3,NULL,NULL),(895,31,4,14.3,NULL,NULL),(896,31,4,14.8,NULL,NULL),(897,31,4,14.7,NULL,NULL),(898,31,4,14.3,NULL,NULL),(899,31,4,14.8,NULL,NULL),(900,31,4,14.3,NULL,NULL),(901,31,4,14.8,NULL,NULL),(902,31,6,11.6,NULL,NULL),(903,31,6,12.7,NULL,NULL),(904,31,6,12,NULL,NULL),(905,31,6,12.6,NULL,NULL),(906,31,6,12,NULL,NULL),(907,31,6,12.6,NULL,NULL),(908,31,1,14.5,NULL,NULL),(909,31,1,15.7,NULL,NULL),(910,31,1,15,NULL,NULL),(911,31,1,15,NULL,NULL),(912,31,1,11.8,NULL,NULL),(913,31,1,16,NULL,NULL),(914,31,6,11.6,NULL,NULL),(915,31,6,12.7,NULL,NULL),(916,31,6,11.8,NULL,NULL),(917,31,6,12.2,NULL,NULL),(918,31,6,12,NULL,NULL),(919,31,6,12.6,NULL,NULL),(920,31,6,12,NULL,NULL),(921,31,6,12.6,NULL,NULL),(922,31,4,11.5,NULL,NULL),(923,31,4,12.5,NULL,NULL),(924,31,4,11.6,NULL,NULL),(925,31,4,12.3,NULL,NULL),(926,31,4,12,NULL,NULL),(927,31,4,12.6,NULL,NULL),(928,31,4,12.3,NULL,NULL),(929,31,4,12.7,NULL,NULL),(930,31,8,13.1,NULL,NULL),(931,31,8,13.3,NULL,NULL),(932,31,8,14.5,NULL,NULL),(933,31,8,14.5,NULL,NULL),(934,31,8,9.9,NULL,NULL),(935,31,8,15.7,NULL,NULL),(936,31,8,15.7,NULL,NULL),(937,32,9,16.7,NULL,NULL),(938,32,9,17.1,NULL,NULL),(939,32,9,17.6,NULL,NULL),(940,32,9,16.7,NULL,NULL),(941,32,9,24.1,NULL,NULL),(942,32,9,17,NULL,NULL),(943,32,9,24.1,NULL,NULL),(944,32,13,13.7,NULL,NULL),(945,32,13,19.1,NULL,NULL),(946,33,8,18,NULL,NULL),(947,33,8,18,NULL,NULL),(948,33,8,20.6,NULL,NULL),(949,33,3,20.6,NULL,NULL),(950,33,3,20.6,NULL,NULL),(951,33,8,20.6,NULL,NULL),(952,34,4,6.6,NULL,NULL),(953,34,3,10.2,NULL,NULL),(954,34,3,10.5,NULL,NULL),(955,34,7,10.9,NULL,NULL),(956,34,7,10.9,NULL,NULL),(957,34,5,8.8,NULL,NULL),(958,34,5,8.6,NULL,NULL),(959,35,6,6.9,NULL,NULL),(960,35,6,6.9,NULL,NULL),(961,36,1,12.5,NULL,NULL),(962,36,1,11.3,NULL,NULL),(963,36,1,11.3,NULL,NULL),(964,36,3,8.7,NULL,NULL),(965,36,7,8.7,NULL,NULL),(966,36,3,9.6,NULL,NULL),(967,36,7,9.6,NULL,NULL),(968,36,2,10.4,NULL,NULL),(969,36,2,13,NULL,NULL),(970,36,2,12,NULL,NULL),(971,36,2,13.3,NULL,NULL),(972,36,1,10.9,NULL,NULL),(973,36,1,12,NULL,NULL),(974,36,1,13.3,NULL,NULL),(975,36,1,14.7,NULL,NULL),(976,36,3,12.6,NULL,NULL),(977,36,7,12.6,NULL,NULL),(978,36,3,14.2,NULL,NULL),(979,36,7,14.2,NULL,NULL),(980,37,1,12.7,NULL,NULL),(981,37,3,10.6,NULL,NULL),(982,37,3,10.6,NULL,NULL),(983,37,7,10.3,NULL,NULL),(984,37,7,10.6,NULL,NULL),(985,37,7,9.5,NULL,NULL),(986,37,7,10.4,NULL,NULL),(987,37,7,10.1,NULL,NULL),(988,37,3,9.3,NULL,NULL),(989,37,3,10.3,NULL,NULL),(990,37,3,10.2,NULL,NULL),(991,37,3,10.4,NULL,NULL),(992,38,1,14.2,NULL,NULL),(993,38,8,12.1,NULL,NULL),(994,38,2,9.5,NULL,NULL),(995,38,2,11.1,NULL,NULL),(996,38,2,5.5,NULL,NULL),(997,38,2,5.8,NULL,NULL),(998,38,3,9.1,NULL,NULL),(999,38,3,8.6,NULL,NULL),(1000,38,3,10.8,NULL,NULL),(1001,38,3,10.8,NULL,NULL),(1002,38,7,9.4,NULL,NULL),(1003,38,7,8.9,NULL,NULL),(1004,38,7,11.6,NULL,NULL),(1005,38,7,11.2,NULL,NULL),(1006,38,7,10.9,NULL,NULL),(1007,38,1,13.9,NULL,NULL),(1008,38,1,15.6,NULL,NULL),(1009,38,1,11.8,NULL,NULL),(1010,38,1,14.2,NULL,NULL),(1011,38,1,7.8,NULL,NULL),(1012,38,2,4.7,NULL,NULL),(1013,38,3,4.5,NULL,NULL),(1014,38,15,5.3,NULL,NULL),(1015,38,1,10.9,NULL,NULL),(1016,38,1,12.1,NULL,NULL),(1017,38,1,11.1,NULL,NULL),(1018,38,1,12.3,NULL,NULL),(1019,38,1,17.3,NULL,NULL),(1020,38,1,19,NULL,NULL),(1021,38,13,11.8,NULL,NULL),(1022,38,13,12.8,NULL,NULL),(1023,38,13,13.8,NULL,NULL),(1024,38,10,12.3,NULL,NULL),(1025,38,10,11.4,NULL,NULL),(1026,38,10,13,NULL,NULL),(1027,38,10,13,NULL,NULL),(1028,38,10,14.7,NULL,NULL),(1029,38,10,15.3,NULL,NULL),(1030,38,9,15.9,NULL,NULL),(1031,38,9,17.6,NULL,NULL),(1032,38,9,16.7,NULL,NULL),(1033,38,9,18.4,NULL,NULL),(1034,38,1,11.4,NULL,NULL),(1035,38,1,12.6,NULL,NULL),(1036,38,1,11.6,NULL,NULL),(1037,38,1,12.9,NULL,NULL),(1038,38,3,8,NULL,NULL),(1039,38,3,7.8,NULL,NULL),(1040,39,5,11.3,NULL,NULL),(1041,39,5,11.7,NULL,NULL),(1042,39,5,10.9,NULL,NULL),(1043,39,5,11.3,NULL,NULL),(1044,39,3,11,NULL,NULL),(1045,39,3,11.5,NULL,NULL),(1046,39,3,14.3,NULL,NULL),(1047,39,5,10.9,NULL,NULL),(1048,39,3,10.4,NULL,NULL),(1049,39,3,11.3,NULL,NULL),(1050,39,3,12.3,NULL,NULL),(1051,39,3,7.9,NULL,NULL),(1052,39,3,7.9,NULL,NULL),(1053,39,7,10.4,NULL,NULL),(1054,39,7,11.3,NULL,NULL),(1055,39,7,8.2,NULL,NULL),(1056,39,7,7.9,NULL,NULL),(1057,39,3,10,NULL,NULL),(1058,39,3,11.3,NULL,NULL),(1059,39,3,10.1,NULL,NULL),(1060,39,3,10.6,NULL,NULL),(1061,39,3,10.4,NULL,NULL),(1062,39,3,11.2,NULL,NULL),(1063,39,3,10.4,NULL,NULL),(1064,39,3,11.3,NULL,NULL),(1065,39,3,7.9,NULL,NULL),(1066,39,3,7.9,NULL,NULL),(1067,39,2,11,NULL,NULL),(1068,39,2,11.5,NULL,NULL),(1069,39,2,12.3,NULL,NULL),(1070,39,2,8.1,NULL,NULL),(1071,39,2,8,NULL,NULL),(1072,39,13,13.7,NULL,NULL),(1073,39,1,11.1,NULL,NULL),(1074,39,1,13.5,NULL,NULL),(1075,39,1,11.2,NULL,NULL),(1076,39,1,13.8,NULL,NULL),(1077,39,1,12.7,NULL,NULL),(1078,40,3,11.5,NULL,NULL),(1079,40,3,11.6,NULL,NULL),(1080,40,5,13.3,NULL,NULL),(1081,40,3,11.9,NULL,NULL),(1082,40,3,12.8,NULL,NULL),(1083,40,2,11.8,NULL,NULL),(1084,40,2,12.8,NULL,NULL),(1085,40,1,12.7,NULL,NULL),(1086,40,1,13.1,NULL,NULL),(1087,40,1,13.6,NULL,NULL),(1088,40,1,12.7,NULL,NULL),(1089,40,1,13.1,NULL,NULL),(1090,40,1,13.6,NULL,NULL),(1091,40,1,14.5,NULL,NULL),(1092,40,1,14.8,NULL,NULL);
/*!40000 ALTER TABLE `fuel_consumption` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fuel_type`
--

DROP TABLE IF EXISTS `fuel_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fuel_type` (
  `fuel_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `fuel_consumption` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`fuel_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fuel_type`
--

LOCK TABLES `fuel_type` WRITE;
/*!40000 ALTER TABLE `fuel_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `fuel_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transmission`
--

DROP TABLE IF EXISTS `transmission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transmission` (
  `transmission_id` int unsigned NOT NULL AUTO_INCREMENT,
  `transmission` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`transmission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transmission`
--

LOCK TABLES `transmission` WRITE;
/*!40000 ALTER TABLE `transmission` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmission` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-06-12 11:26:23
