db_fuzzy.sql

/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 10.4.18-MariaDB : Database - db_fuzzy
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_fuzzy` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `db_fuzzy`;

/*Table structure for table `ci_sessions` */

DROP TABLE IF EXISTS `ci_sessions`;

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Table structure for table `ci_settings` */

DROP TABLE IF EXISTS `ci_settings`;

CREATE TABLE `ci_settings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `key` varchar(32) NOT NULL,
  `content` varchar(600) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

/*Data for the table `ci_settings` */

insert  into `ci_settings`(`id`,`key`,`content`) values 
(1,'current_theme_name','made'),
(2,'web_name','Pemilihan Smartphone'),
(3,'web_phone_number',''),
(4,'web_email',''),
(5,'web_tagline',''),
(6,'web_logo','logo.png'),
(7,'web_description',''),
(8,'web_address','');

/*Table structure for table `tb_admin` */

DROP TABLE IF EXISTS `tb_admin`;

CREATE TABLE `tb_admin` (
  `adm_id` varchar(30) NOT NULL,
  `adm_nama` varchar(40) NOT NULL,
  `adm_password` varchar(191) NOT NULL,
  `adm_nohp` varchar(20) NOT NULL,
  PRIMARY KEY (`adm_id`),
  UNIQUE KEY `adm_nohp` (`adm_nohp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tb_admin` */

insert  into `tb_admin`(`adm_id`,`adm_nama`,`adm_password`,`adm_nohp`) values 
('admin123','Administrator Web','$2y$10$Pp21XE3jIVWYUaxFQ8W81Obar3rW6aj8Iz/v0UrIEiff.OuYy0Wuq','');

/*Table structure for table `tb_laptop` */

DROP TABLE IF EXISTS `tb_laptop`;

CREATE TABLE `tb_laptop` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Merek` varchar(9) DEFAULT NULL,
  `Harga` int(11) DEFAULT NULL,
  `Kapasitas_Hardisk` int(11) DEFAULT NULL,
  `RAM` int(11) DEFAULT NULL,
  `Kecepatan_Processor` int(11) DEFAULT NULL,
  `Dimensi Layar` decimal(10,2) DEFAULT NULL,
  `Berat` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8;

/*Data for the table `tb_laptop` */

insert  into `tb_laptop`(`Id`,`Merek`,`Harga`,`Kapasitas_Hardisk`,`RAM`,`Kecepatan_Processor`,`Dimensi Layar`,`Berat`) values 
(1,'Apple',21895893,128,8,2300,13.30,1.37),
(2,'Apple',14692275,128,8,1800,13.30,1.34),
(3,'HP',9397800,256,8,2500,15.60,1.86),
(4,'Apple',41472083,512,16,2700,15.40,1.83),
(5,'Apple',29478038,256,8,3100,13.30,1.37),
(6,'Acer',6537600,500,4,3000,15.60,1.00),
(7,'Apple',34975670,256,16,2200,15.40,2.04),
(8,'Apple',18937793,256,8,1800,13.30,1.34),
(9,'Asus',24434280,512,16,1800,14.00,1.30),
(10,'Acer',12584880,256,8,1600,14.00,1.60),
(11,'HP',6437902,500,4,2500,15.60,1.86),
(12,'HP',5638517,500,4,2000,15.60,1.86),
(13,'Apple',39878870,256,16,2800,15.40,1.83),
(14,'Dell',8154022,256,4,2000,15.60,2.20),
(15,'Apple',20632666,256,8,1200,12.00,0.92),
(16,'Apple',24819181,256,8,2300,13.30,1.37),
(17,'Dell',12176280,256,8,2700,15.60,2.20),
(18,'Apple',46711152,512,16,2900,15.40,1.83),
(19,'Lenovo',8155656,1000,8,2400,15.60,2.20),
(20,'Dell',16000776,128,8,1600,13.30,1.22),
(21,'Asus',3136414,32,2,1440,11.60,0.98),
(22,'Lenovo',16327656,1128,8,2500,15.60,2.50),
(23,'HP',4658040,500,4,1500,15.60,1.86),
(24,'Dell',13385736,256,8,1600,13.30,1.62),
(25,'HP',10770696,256,8,2000,15.60,1.91),
(26,'Dell',6842252,1000,4,2000,15.60,2.30),
(27,'Apple',17962056,128,8,1600,13.30,1.35),
(28,'Dell',13075200,256,8,1600,15.60,2.20),
(29,'Dell',21214512,512,8,1900,15.60,1.88),
(30,'HP',14644224,1000,8,1600,17.30,2.50),
(31,'Chuwi',4004117,64,4,1440,15.60,1.89),
(32,'Asus',3252456,32,2,1500,14.00,1.65),
(33,'HP',7175016,500,4,2500,17.30,2.71),
(34,'Dell',30546936,512,16,1800,13.30,1.20),
(35,'Apple',16311312,256,8,1600,13.30,1.35),
(36,'Lenovo',4069656,64,4,1100,14.00,1.44),
(37,'Acer',5998248,1000,4,2700,15.60,2.10),
(38,'Dell',16000776,1128,8,1600,17.30,2.80),
(39,'HP',7987149,1000,4,2500,15.60,1.86),
(40,'HP',14366376,256,8,1600,15.60,2.10),
(41,'Asus',6357816,1000,4,2000,15.60,2.00),
(42,'Dell',24499656,1256,16,2800,15.60,2.65),
(43,'Asus',8547749,1000,8,2500,15.60,2.30),
(44,'Acer',11146608,256,4,1600,15.60,2.20),
(45,'Dell',16327656,1000,12,1600,17.30,2.77),
(46,'Apple',23192136,256,8,2000,13.30,1.37),
(47,'Lenovo',6030936,128,4,2000,15.60,2.20),
(48,'Asus',21230856,1256,8,3000,17.30,3.20),
(49,'Dell',10443816,256,4,2500,15.60,2.30),
(50,'Asus',7616304,1000,4,1100,17.30,2.80),
(51,'Lenovo',5213736,64,4,1440,10.10,69.00),
(52,'Acer',13745304,256,8,1800,15.60,2.20),
(53,'HP',6512921,256,4,2500,15.60,1.86),
(54,'HP',18027432,512,8,1800,13.30,1.49),
(55,'Acer',6276096,1000,4,2400,15.60,2.40),
(56,'Dell',12548923,256,8,1800,15.60,2.13),
(57,'HP',7175016,128,4,2000,15.60,1.91),
(58,'Asus',9580689,256,4,2500,15.60,2.00),
(59,'MSI',40026456,2256,16,2800,17.30,2.43),
(60,'Asus',6782760,256,4,2000,15.60,2.00),
(61,'Dell',21230856,2256,16,1800,17.30,2.80),
(62,'Dell',14366376,256,8,1600,14.00,1.70),
(63,'Lenovo',9790056,256,8,2700,14.00,1.70),
(64,'Asus',15379704,256,8,1600,14.00,1.40),
(65,'HP',11277360,256,8,2500,15.60,1.86),
(66,'Asus',32410152,512,16,2800,15.60,1.80),
(67,'HP',7169949,500,4,2000,15.60,1.86),
(68,'HP',3742776,32,4,1600,14.00,1.44),
(69,'Lenovo',8972856,1000,4,2500,15.60,1.90),
(70,'Asus',15510456,1000,12,2800,17.30,3.00),
(71,'Dell',15608520,256,8,1800,13.30,1.40),
(72,'Dell',14219280,256,8,1800,15.60,2.20),
(73,'MSI',17896680,1128,8,2500,17.30,2.70),
(74,'Acer',6357816,1000,8,2000,14.00,2.10),
(75,'Asus',15510456,1000,8,2800,15.60,2.20),
(76,'Lenovo',8482536,2000,8,2500,15.60,2.20),
(77,'Dell',13974120,1128,4,1800,15.60,2.02),
(78,'Acer',8662320,1000,4,2700,15.60,2.20),
(79,'HP',15968088,1128,8,1600,17.30,2.50),
(80,'Dell',17915639,256,8,1300,15.60,1.88),
(81,'Apple',24679440,512,8,1600,12.00,0.92),
(82,'HP',14055840,256,8,1600,14.00,1.63),
(83,'Lenovo',6521256,128,4,2500,15.60,2.20),
(84,'Acer',6455880,1000,4,3000,15.60,2.10),
(85,'Dell',22048056,1128,16,2800,15.60,2.65),
(86,'HP',11424456,256,8,1800,15.60,1.83),
(87,'HP',9789893,256,8,2500,15.60,1.96),
(88,'Asus',23682456,1128,16,2800,15.60,2.20),
(89,'Dell',26951256,256,8,1800,13.30,1.21),
(90,'Dell',11424456,256,8,3000,15.60,2.45),
(91,'Acer',11261016,1000,8,1800,15.60,2.20),
(92,'HP',19563768,512,16,1800,13.30,1.49),
(93,'Dell',19531080,256,8,2500,15.60,2.65),
(94,'Asus',17144856,256,8,2700,14.00,1.25),
(95,'Acer',13843368,256,8,1600,13.30,1.50),
(96,'Dell',9804766,1000,8,2700,15.60,2.20),
(97,'Dell',7926840,256,4,2000,15.60,2.20),
(98,'Asus',9430488,256,6,2400,15.60,2.00),
(99,'HP',20413656,1128,12,2800,15.60,2.62),
(100,'HP',11751336,256,8,2700,15.60,1.91),
(101,'HP',5704056,500,4,1500,15.60,2.10),
(102,'Dell',10574568,1000,8,1600,15.60,2.20),
(103,'HP',18288936,256,8,2700,13.30,1.38),
(104,'Microsoft',21900960,256,8,2500,13.50,1.25),
(105,'HP',10770696,256,6,2500,14.00,1.58),
(106,'Lenovo',6766416,1000,4,2000,15.60,1.85),
(107,'Asus',19498392,256,8,2700,14.00,3.00),
(108,'MSI',21230856,1256,16,2800,15.60,2.20),
(109,'Lenovo',24189120,256,8,2700,14.00,1.58),
(110,'Asus',20626128,1256,16,1800,15.60,1.50),
(111,'Dell',22538376,256,8,2400,13.30,1.23),
(112,'Lenovo',22865256,256,8,2500,13.30,1.37),
(113,'HP',11800368,500,4,1600,14.00,1.63),
(114,'Dell',26624376,256,8,1600,13.30,1.21),
(115,'HP',22865093,256,8,1600,13.30,1.26),
(116,'HP',17716896,512,8,1800,14.00,1.63),
(117,'Dell',18474114,1256,8,1800,15.60,2.16),
(118,'Asus',9218016,1000,4,2000,17.30,2.00),
(119,'Asus',18272592,256,8,1800,15.60,1.70),
(120,'Acer',7828776,1000,6,1800,15.60,2.10),
(121,'MSI',36635076,2256,16,2400,15.60,1.80),
(122,'Lenovo',10280376,256,8,2500,15.60,2.20),
(123,'HP',20773224,512,16,1800,17.30,2.50),
(124,'Acer',7371144,256,4,3000,15.60,2.10),
(125,'HP',4233096,500,4,1600,15.60,1.86),
(126,'HP',13271328,1000,8,1600,14.00,1.63),
(127,'Asus',4543469,64,4,1500,14.00,1.65),
(128,'Dell',22816224,2256,16,1800,17.30,2.80),
(129,'HP',15167232,256,8,1600,17.30,2.50),
(130,'Dell',10443653,1000,8,2500,15.60,2.36),
(131,'Dell',7338456,1000,4,2000,15.60,2.20),
(132,'Acer',14448096,256,8,1800,14.00,1.60),
(133,'Dell',9348768,256,4,2700,15.60,2.20),
(134,'HP',9773712,1000,8,2700,15.60,2.05),
(135,'HP',16147872,256,8,1800,14.00,1.63),
(136,'Lenovo',4124572,1000,4,1100,15.60,1.90),
(137,'HP',15330672,1128,8,2500,17.30,3.00),
(138,'Lenovo',8155656,1000,4,2500,15.60,2.20),
(139,'HP',11424456,256,4,2500,13.30,1.32),
(140,'Acer',10705320,1000,4,2700,17.30,3.00),
(141,'Lenovo',18240231,256,8,1600,14.00,1.75),
(142,'Lenovo',14202936,256,8,2800,15.60,2.40),
(143,'Toshiba',9839088,500,4,2300,15.60,2.10),
(144,'HP',6030936,256,4,2500,15.60,1.86),
(145,'Asus',17962056,256,8,1800,14.00,1.25),
(146,'HP',32916816,512,8,1200,12.50,0.97),
(147,'Asus',5622336,1000,4,1100,15.60,2.00),
(148,'MSI',33161976,1256,16,2800,17.30,2.90),
(149,'Acer',7305768,1000,4,2000,15.60,2.10),
(150,'Dell',20413656,512,16,2800,15.60,2.56),
(151,'Asus',4800000,256,4,1900,11.60,2.00),
(152,'Asus',9050000,256,8,2600,14.00,2.20),
(153,'Asus',5450000,256,4,2600,15.60,2.50),
(154,'Asus',7100000,512,8,2800,14.00,2.00),
(155,'Asus',6650000,512,8,2800,14.00,2.80),
(156,'Asus',7350000,512,8,3100,15.60,2.20),
(157,'Asus',7150000,512,4,3100,15.60,1.09),
(158,'Asus',14000000,512,12,3200,14.20,2.50),
(159,'Asus',12150000,512,8,3200,14.00,2.00),
(160,'Asus',12900000,512,8,3200,15.60,2.00),
(161,'Asus',13500000,512,8,3200,14.00,2.30),
(162,'Asus',13600000,512,8,3100,14.00,2.10),
(163,'Asus',11450000,512,8,3200,14.00,2.20),
(164,'Asus',13150000,512,8,3200,14.00,2.30),
(165,'Asus',14250000,512,8,3200,15.60,2.10),
(166,'HP',4700000,256,4,1800,14.00,1.08),
(167,'HP',11450000,512,8,2500,14.00,2.10),
(168,'HP',6800000,512,4,2100,14.00,2.00),
(169,'HP',10900000,512,8,2400,14.00,2.20),
(170,'HP',13600000,512,16,2500,14.00,2.10),
(171,'HP',13950000,512,16,2500,13.30,2.20),
(172,'HP',13150000,512,8,2500,14.00,2.50),
(173,'HP',12000000,512,16,2100,15.60,2.20),
(174,'HP',11950000,512,16,2100,15.60,2.10),
(175,'HP',14300000,512,8,2300,15.60,2.40),
(176,'HP',15800000,512,8,2500,16.60,2.50),
(177,'HP',16400000,512,8,3100,15.60,2.00),
(178,'HP',17650000,512,16,3100,15.60,2.10),
(179,'HP',21850000,512,16,3100,15.60,2.80),
(180,'Lenovo',5450000,256,4,1800,14.00,1.58),
(181,'Acer',4850000,256,4,1800,14.00,1.25),
(182,'Acer',6000000,512,4,2400,14.00,2.00),
(183,'Acer',6300000,256,8,2500,14.00,2.10),
(184,'Acer',6600000,512,4,2700,14.00,1.88),
(185,'Acer',7200000,512,8,2700,14.00,2.50),
(186,'Acer',7350000,512,4,2700,14.00,2.00),
(187,'Acer',7850000,512,8,2700,14.00,2.10),
(188,'Acer',9400000,512,8,3100,15.60,2.20),
(189,'Acer',10500000,512,8,3100,14.00,2.50),
(190,'Acer',12000000,512,16,3100,14.00,1.58),
(191,'Acer',11900000,512,16,2700,14.00,2.00),
(192,'Acer',12750000,512,16,3100,14.00,2.50),
(193,'Acer',12200000,512,8,3100,14.00,2.20),
(194,'Acer',14300000,512,8,2500,15.60,2.10),
(195,'Acer',20900000,1000,16,3200,15.60,2.80),
(196,'Acer',11950000,512,16,2500,14.00,2.00),
(197,'Acer',11950000,512,16,2500,14.00,2.00),
(198,'Acer',12300000,512,8,2100,14.00,2.50),
(199,'Acer',14950000,512,16,2100,14.00,2.50),
(200,'Acer',13000000,512,8,2100,15.60,2.50),
(201,'Lenovo',4600000,256,8,1800,14.00,1.88),
(202,'Lenovo',5100000,512,4,1800,14.00,1.58),
(203,'Lenovo',7700000,512,8,2400,14.00,2.00),
(204,'Lenovo',7750000,512,8,2800,14.00,2.00),
(205,'Lenovo',10900000,512,8,2700,14.00,2.80),
(206,'Lenovo',12650000,512,8,2700,14.00,2.80),
(207,'Lenovo',14800000,512,8,2500,14.00,2.80),
(208,'Lenovo',15700000,512,8,2700,13.30,2.00),
(209,'Lenovo',10500000,512,8,3100,14.00,2.00),
(210,'Lenovo',13950000,512,8,3100,14.00,2.20),
(211,'Lenovo',12250000,512,8,3100,14.00,2.20),
(212,'Merek',0,0,0,0,0.00,0.00);

/*Table structure for table `tb_smartphone` */

DROP TABLE IF EXISTS `tb_smartphone`;

CREATE TABLE `tb_smartphone` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `nama` varchar(34) DEFAULT NULL,
  `brand` varchar(10) DEFAULT NULL,
  `kec_prosesor` double DEFAULT NULL,
  `core_prosesor` int(13) DEFAULT NULL,
  `ram` int(5) DEFAULT NULL,
  `mem_internal` int(12) DEFAULT NULL,
  `kam_utama` double DEFAULT NULL,
  `kam_sekunder` double DEFAULT NULL,
  `baterai` int(7) DEFAULT NULL,
  `so` varchar(11) DEFAULT NULL,
  `uk_layar` double DEFAULT NULL,
  `harga` int(8) DEFAULT NULL,
  `performa` int(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=424 DEFAULT CHARSET=utf8;

/*Data for the table `tb_smartphone` */

insert  into `tb_smartphone`(`id`,`nama`,`brand`,`kec_prosesor`,`core_prosesor`,`ram`,`mem_internal`,`kam_utama`,`kam_sekunder`,`baterai`,`so`,`uk_layar`,`harga`,`performa`) values 
(1,'iPhone 11 Pro Max','Apple',2.65,6,4000,64,12,12,3969,'iOS',6.5,18999000,459713),
(2,'iPhone 11','Apple',2.65,6,4000,64,12,12,3110,'iOS',6.1,7999999,419453),
(3,'Apple iPhone XR','Apple',2.49,6,3000,64,12,7,2942,'iOS',6.1,9099800,341196),
(4,'Apple iPhone XS Max','Apple',2.49,6,4000,64,12,7,2658,'iOS',6.5,13999800,353210),
(5,'Apple iPhone XS','Apple',2.49,6,4000,64,12,7,2658,'iOS',5.8,11999800,346379),
(6,'Apple iPhone 8','Apple',2.09,6,2000,64,12,7,1821,'iOS',4.7,7399800,237594),
(7,'Apple iPhone 8 Plus','Apple',2.09,6,3000,64,12,7,2691,'iOS',5.5,9400000,396963),
(8,'Apple iPhone X','Apple',2.39,6,3000,64,12,7,2716,'iOS',5.8,13999800,233100),
(9,'Apple iPhone 7 Plus','Apple',2.34,4,3000,32,12,7,2900,'iOS',5.5,6999800,396963),
(10,'Apple iPhone 7','Apple',2.34,4,2000,32,12,7,1960,'iOS',4.7,5599800,240017),
(11,'Apple iPhone 6s Plus','Apple',1.8,1,2000,16,12,5,2750,'iOS',5.5,5198000,175000),
(12,'Apple iPhone SE','Apple',2.66,1,2000,16,12,1.2,1624,'iOS',4,3399800,579472),
(13,'Apple iPhone 6s','Apple',1.84,2,2000,16,12,5,1715,'iOS',4.7,4599800,175000),
(14,'Apple iPhone 6 Plus','Apple',1.8,1,1000,16,8,1.2,2915,'iOS',5.5,4799800,102508),
(15,'Apple iPhone 6','Apple',1.84,2,1000,16,8,1.2,1810,'iOS',4.7,3199800,102509),
(16,'Apple iPhone 5c','Apple',1.3,2,1000,8,8,1.2,1507,'iOS',4,1699800,27524),
(17,'iPhone 11 Pro','Apple',2.65,6,4000,64,12,12,3046,'iOS',5.8,19380000,515327),
(18,'Asus ROG Phone 2','Asus',2.96,8,8000,128,48,24,6000,'Android',6.59,7599800,480020),
(19,'Asus ROG Phone','Asus',2.96,8,8000,128,12,8,4000,'Android',6,13999800,304183),
(20,'Asus ZenFone Max Pro M1','Asus',1.8,8,3000,32,13,8,5000,'Android',5.99,1998000,116618),
(21,'Asus ZenFone 5Z (ZS620KL)','Asus',2.7,8,4000,64,12,8,3300,'Android',6.2,3799800,274499),
(22,'Asus ZenFone 3 Deluxe (ZS570KL)','Asus',2.15,4,6000,256,23,8,3000,'Android',5.7,8999800,135000),
(23,'Asus 6Z','Asus',2.84,8,6000,64,48,48,5000,'Android',6.4,5599800,435000),
(24,'Asus ZenFone Max Pro M2','Asus',2.2,8,3000,32,12,13,5000,'Android',6.26,2399800,143000),
(25,'Asus ZenFone Zoom S','Asus',2,8,4000,64,12,13,5000,'Android',5.5,5399800,62000),
(26,'Asus ZenFone 3S Max','Asus',1.5,8,3000,32,13,8,5000,'Android',5.2,2999800,36500),
(27,'Asus ZenFone AR','Asus',2.35,4,8000,128,23,8,3300,'Android',5.7,9999800,165000),
(28,'Asus ZenFone 3 (ZE552KL)','Asus',2,8,4000,64,16,8,3000,'Android',5.5,2999800,62193),
(29,'Asus ZenFone Selfie','Asus',1.7,8,2000,16,13,13,3000,'Android',5.5,2999800,39483),
(30,'Asus ZenFone Max M2','Asus',1.8,8,3000,32,13,8,4000,'Android',6.26,1499800,104300),
(31,'Asus ZenFone Lite L1 (ZA551KL)','Asus',1.4,8,2000,16,13,5,3000,'Android',5.45,999800,42100),
(32,'Asus ZenFone Max M1 (ZB556KL)','Asus',1.4,8,3000,32,13,8,4000,'Android',5.45,1199800,57999),
(33,'Asus ZenFone 4 Selfie Pro','Asus',2,8,4000,64,16,12,3000,'Android',5.5,5199800,61758),
(34,'Asus ZenFone 3 Max (ZC553KL)','Asus',1.4,8,2000,32,16,8,4100,'Android',5.5,1719800,56813),
(35,'Asus ZenFone 3 Laser','Asus',1.4,8,4000,32,13,8,3000,'Android',5.5,1099800,37851),
(36,'Asus ZenFone Max','Asus',1.2,4,2000,16,13,5,5000,'Android',5.5,999800,57999),
(37,'Asus ZenFone 2 Deluxe','Asus',1.8,4,4000,64,13,5,3000,'Android',5.5,3399800,41380),
(38,'Asus ZenFone 2 Laser (ZE550KL)','Asus',1.2,4,2000,16,13,5,3000,'Android',5.5,2599800,52924),
(39,'Asus ZenFone Zoom','Asus',2.5,4,4000,64,13,5,3000,'Android',5.5,3199800,57678),
(40,'Asus ZenFone 6','Asus',2.84,2,2000,16,13,2,3300,'Android',6,1778200,435000),
(41,'Asus ZenFone C (ZC451CG)','Asus',1.2,2,1000,8,5,0.3,2100,'Android',4.5,1099800,18072),
(42,'Asus ZenFone Live','Asus',1.4,4,2000,16,13,5,2650,'Android',5,919800,25200),
(43,'Asus ZenFone 4','Asus',2.2,1,4000,64,12,8,3300,'Android',5.5,1299800,71200),
(44,'Asus ZenFone 4 Selfie DC (ZD553KL)','Asus',1.4,8,4000,64,16,20,3000,'Android',5.5,1399600,38688),
(45,'Asus ZenFone 4 Selfie','Asus',1.4,4,4000,32,16,12,3000,'Android',5.5,1289800,38688),
(46,'Asus ZenFone Go 5,5 (ZB552KL)','Asus',1.2,4,2000,16,13,5,3000,'Android',5.5,1222000,25209),
(47,'Asus ZenFone Go 5,0 LTE (ZB500KL)','Asus',1.2,4,2000,16,13,5,2600,'Android',5,999800,23543),
(48,'Asus ZenFone Go (ZB450KL)','Asus',1.2,4,1000,8,8,2,2070,'Android',4.5,899800,32010),
(49,'Asus ZenFone 3 Max (ZC520TL)','Asus',1.25,4,2000,16,13,5,4100,'Android',5.2,2798000,36870),
(50,'Asus ZenFone Go 4,5 (ZB452KG)','Asus',1.2,4,1000,8,5,0.3,2070,'Android',4.5,799800,20664),
(51,'Asus Zenfone Go 5,0 LTE','Asus',1.2,4,2000,16,8,5,2500,'Android',5,998000,18900),
(52,'Asus ZenPad C 7,0 (Z170MG)','Asus',1.3,4,1000,8,5,0.3,3450,'Android',7,1239800,19515),
(53,'Asus ZenFone 2 Laser (ZE601KL)','Asus',1.7,8,3000,16,13,5,3000,'Android',6,1799800,36478),
(54,'Asus ZenFone 2 Laser (ZE500KL)','Asus',1.2,4,2000,8,13,5,2070,'Android',5,1198000,23897),
(55,'BlackBerry Priv','BlackBerry',1.8,6,3000,32,18,2,3410,'Android',5.4,3999800,45880),
(56,'BlackBerry Passport','BlackBerry',2.2,4,3000,32,13,2,3450,'BlackBerry',4.5,3199800,37894),
(57,'BlackBerry KEY2 LE','BlackBerry',1.8,8,4000,64,13,8,3000,'Android',4.5,4598000,115000),
(58,'BlackBerry DTEK50','BlackBerry',1.5,8,3000,16,13,8,2610,'Android',5.2,2399800,35232),
(59,'BlackBerry Q5','BlackBerry',1.2,2,2000,8,5,2,2180,'BlackBerry',3.1,2160000,16745),
(60,'BlackBerry Q10','BlackBerry',1.5,1,2000,16,8,2,2100,'BlackBerry',3.1,1979800,3248),
(61,'BlackBerry Z10','BlackBerry',1.5,2,2000,16,8,2,1800,'BlackBerry',4.2,1100000,3268),
(62,'BlackBerry Leap','BlackBerry',1.5,2,2000,16,8,2,2800,'BlackBerry',5,1440000,3271),
(63,'BlackBerry Classic','BlackBerry',1.5,2,2000,16,8,2,2515,'BlackBerry',3.5,2779800,3307),
(64,'BlackBerry Z3','BlackBerry',1.2,2,1000,8,5,1.1,2500,'BlackBerry',5,3800000,15734),
(65,'BlackBerry Z30','BlackBerry',1.7,2,2000,16,8,2,2880,'BlackBerry',5,1660000,3076),
(66,'BlackBerry Curve 9220','BlackBerry',0.8,1,512,512,2,0,1450,'BlackBerry',2.44,1399800,0),
(67,'BlackBerry 9720','BlackBerry',0.8,1,512,512,5,0,1450,'BlackBerry',2.8,1500000,0),
(68,'BlackBerry Evolve','BlackBerry',1.8,8,4000,64,13,16,4000,'Android',5.99,2799800,58000),
(69,'BlackBerry KEY2','BlackBerry',2.2,8,4000,64,12,8,3500,'Android',4.5,3998800,84291),
(70,'BlackBerry Motion','BlackBerry',2,8,4000,32,12,8,4000,'Android',5.5,5999800,60222),
(71,'BlackBerry DTEK60','BlackBerry',2.2,4,4000,32,21,8,3000,'Android',5.5,3399800,99399),
(72,'Google Pixel 3 XL','Google',2.5,8,4000,64,12.2,8,3430,'Android',6.3,9598000,256805),
(73,'Google Pixel 3','Google',2.5,8,4000,64,12.2,8,2915,'Android',5.5,7599800,256805),
(74,'Google Pixel XL','Google',2.15,4,4000,32,12.3,8,3450,'Android',5.5,6198000,145000),
(75,'Google Pixel 3a XL','Google',2.2,8,4000,64,12.2,8,3700,'Android',6,6999800,159000),
(76,'Google Pixel 3a','Google',2,8,4000,64,12.2,8,3000,'Android',5.6,6199800,167000),
(77,'Google Pixel 2 XL','Google',2.35,8,4000,64,12.2,8,3520,'Android',6,2598800,159036),
(78,'Google Pixel 2','Google',2.35,8,4000,64,12.2,8,2700,'Android',5,1998800,159036),
(79,'Google Pixel 4 XL','Google',2.84,8,6000,64,16,8,3700,'Android',6.3,16780000,425000),
(80,'Google Pixel 4','Google',2.84,8,6000,64,16,8,2800,'Android',5.7,13900000,425000),
(81,'Google Pixel','Google',21.5,4,4000,32,12.3,8,2770,'Android',5,4459800,145387),
(82,'Huawei P30 Pro','Huawei',2.6,8,8000,256,40,32,4200,'Android',6.47,10856000,406000),
(83,'Huawei Mate 20 Pro','Huawei',2.6,8,6000,128,40,24,4200,'Android',6.39,12798000,310512),
(84,'Huawei P20 Pro','Huawei',2.36,8,4000,64,40,24,4000,'Android',6.1,9998000,211347),
(85,'Google Nexus 6P','Huawei',2,8,3000,32,12.3,8,3450,'Android',5.7,8599600,56709),
(86,'Huawei P9','Huawei',2.5,8,3000,32,12,8,3000,'Android',5.2,7999800,96000),
(87,'Huawei Nova 3i','Huawei',2.2,8,4000,128,16,24,3340,'Android',6.3,4399800,151000),
(88,'Huawei Nova 3','Huawei',2.4,8,6000,128,16,24,3750,'Android',6.3,3199800,213380),
(89,'Huawei P20 Lite','Huawei',2.36,8,4000,64,16,24,3000,'Android',5.84,2560000,74919),
(90,'Huawei Mate 30 Pro','Huawei',2.86,8,8000,128,40,32,4500,'Android',6.53,15459800,457000),
(91,'Huawei Y9 Prime 2019','Huawei',2.2,8,4000,128,16,16,4000,'Android',6.59,2890000,158000),
(92,'Huawei Holly 4 Plus','Huawei',1.4,4,3000,32,12,8,4000,'Android',5.5,2998000,43500),
(93,'Huawei Mate 9','Huawei',2.36,8,4000,64,20,8,4000,'Android',5.9,10796600,139000),
(94,'Infinix Hot S3','Infinix',1.4,8,3000,32,13,20,4000,'Android',5.65,1999800,36237),
(95,'Infinix Zero 5 Pro','Infinix',2.6,8,6000,128,12,16,4350,'Android',5.98,3180000,71000),
(96,'Infinix Hot 8','Infinix',2,8,4000,64,13,8,5000,'Android',6.52,1600000,76000),
(97,'Infinix Hot 7','Infinix',1.3,8,4000,64,13,13,4000,'Android',6.19,1998000,21000),
(98,'Infinix Hot 7 Pro','Infinix',2.39,8,6000,64,13,13,4000,'Android',6.19,2199800,73000),
(99,'Infinix S4','Infinix',2,8,3000,32,13,32,4000,'Android',6.21,1599800,78000),
(100,'Infinix Smart 3 Plus','Infinix',2,4,2000,32,13,8,3500,'Android',6.21,1399800,56000),
(101,'Infinix Note 5 Stylus','Infinix',2,8,4000,64,16,16,4000,'Android',5.93,3199800,62000),
(102,'Infinix Hot S3X','Infinix',1.4,8,3000,32,13,16,4000,'Android',6.2,2199800,45096),
(103,'Infinix Note 5','Infinix',2,8,3000,32,12,16,4500,'Android',5.99,1170000,47833),
(104,'Infinix S5 Lite','Infinix',2,8,4000,64,16,16,4000,'Android',6.5,1799800,92000),
(105,'Infinix S5','Infinix',2,8,4000,64,16,32,4000,'Android',6.6,1799800,92000),
(106,'Infinix Smart 2','Infinix',1.5,4,2000,16,13,8,3050,'Android',5.45,799800,47799),
(107,'Infinix Hot 6 Pro','Infinix',1.4,4,3000,32,13,5,4000,'Android',5.99,1799800,31000),
(108,'Infinix Zero 5','Infinix',2.6,8,6000,64,12,16,4350,'Android',5.98,2599800,71000),
(109,'Infinix Hot 4 Pro','Infinix',1.25,4,3000,16,13,5,4000,'Android',5.5,1499800,29503),
(110,'Infinix Note 4','Infinix',1.3,4,3000,32,13,8,4300,'Android',5.7,1799800,22143),
(111,'Lenovo K8 Plus','Lenovo',2.6,8,3000,32,13,8,4000,'Android',5.2,1398000,61119),
(112,'Lenovo K8 Note','Lenovo',2.3,10,3000,32,13,13,4000,'Android',5.5,1459800,59218),
(113,'Lenovo Z2 Plus','Lenovo',2.15,4,3000,32,13,8,3500,'Android',5,2299800,127906),
(114,'Lenovo K6 Power','Lenovo',1.4,8,3000,32,13,8,4000,'Android',5,1700000,35787),
(115,'Lenovo Zuk Z1','Lenovo',2.5,4,3000,64,13,8,4100,'Android',5.5,1499800,38254),
(116,'Lenovo Vibe P1','Lenovo',1.5,8,2000,32,13,5,4900,'Android',5.5,3199800,28000),
(117,'Lenovo Vibe S1','Lenovo',1.7,8,3000,32,13,8,2420,'Android',5,2198000,47000),
(118,'Lenovo K3 Note','Lenovo',1.7,8,2000,16,13,5,2900,'Android',5.5,1999800,46000),
(119,'Lenovo Vibe Shot','Lenovo',1.7,8,3000,32,16,8,2900,'Android',5,1959800,38000),
(120,'Lenovo Vibe Z2 Pro','Lenovo',2.5,4,3000,32,16,5,4000,'Android',6,5999800,36267),
(121,'Lenovo K9','Lenovo',2,8,3000,32,13,13,3000,'Android',5.7,1179800,75300),
(122,'Lenovo P2','Lenovo',2,8,3000,32,13,5,5100,'Android',5.5,3399800,59564),
(123,'Lenovo K6 Note','Lenovo',1.4,8,3000,32,16,8,4000,'Android',5.5,1778000,45000),
(124,'Lenovo Phab 2 Plus','Lenovo',1.3,8,3000,32,13,8,4050,'Android',6.4,1999800,37000),
(125,'Lenovo Vibe K5','Lenovo',1.4,8,2000,16,13,5,2750,'Android',5,1199800,35000),
(126,'Lenovo Vibe K5 Plus','Lenovo',1.5,8,2000,16,13,5,2750,'Android',5,1599800,31298),
(127,'Lenovo Vibe K4 Note','Lenovo',1.5,8,3000,16,13,5,3300,'Android',5.5,1798000,38000),
(128,'Lenovo A6000 Plus','Lenovo',1.2,4,2000,16,8,2,2300,'Android',5,1279800,21313),
(129,'Lenovo A7000','Lenovo',1.5,8,2000,8,8,5,2900,'Android',5.5,1333200,41774),
(130,'Lenovo A6000','Lenovo',1.2,4,1000,8,8,2,2300,'Android',5,1000000,20489),
(131,'Lenovo S660','Lenovo',1.3,4,1000,8,8,0.3,3000,'Android',4.7,1340000,17274),
(132,'Lenovo P780','Lenovo',1.2,4,1000,4,8,0.3,4000,'Android',5,3082000,14236),
(133,'Lenovo Vibe X2','Lenovo',2,8,2000,32,13,5,2300,'Android',5,3499800,60000),
(134,'Lenovo S860','Lenovo',1.3,4,2000,16,8,1.5,4000,'Android',5.3,3749600,15004),
(135,'Lenovo K10 Plus','Lenovo',1.8,8,4000,64,13,16,4050,'Android',6.22,2199800,101855),
(136,'Lenovo A5','Lenovo',1.5,4,2000,16,13,8,4000,'Android',5.45,1060000,35644),
(137,'Lenovo K8','Lenovo',2.3,8,3000,32,13,8,4000,'Android',5.2,1408000,59218),
(138,'Lenovo Vibe B','Lenovo',1,4,1000,8,5,2,2000,'Android',4.5,1290000,20000),
(139,'Lenovo A7700','Lenovo',1,4,2000,16,8,2,2900,'Android',5.5,1398000,23500),
(140,'Lenovo A6600 Plus','Lenovo',1,4,2000,16,8,2,2300,'Android',5,1460000,23233),
(141,'Lenovo A6600','Lenovo',1,4,1000,16,8,2,2300,'Android',5,1490000,31829),
(142,'Lenovo Vibe K5 Note','Lenovo',1.8,8,3000,32,13,8,3500,'Android',5.5,1598000,49586),
(143,'Lenovo Phab 2','Lenovo',1.3,4,3000,32,13,5,4050,'Android',6.4,1799800,36708),
(144,'Lenovo Phab 2 Pro','Lenovo',1.8,8,4000,64,16,8,4050,'Android',6.4,4599800,36708),
(145,'Lenovo Vibe C','Lenovo',1.1,4,1000,8,5,2,2300,'Android',5,900000,3173),
(146,'Lenovo Vibe P1 Turbo','Lenovo',1.6,8,3000,32,13,5,5000,'Android',5.5,1535800,31340),
(147,'Lenovo K5 Note','Lenovo',1.8,8,2000,16,13,8,3500,'Android',5.5,1798000,50000),
(148,'Lenovo A7000 Turbo','Lenovo',1.7,8,2000,16,13,5,2900,'Android',5.5,2800000,40039),
(149,'Lenovo A1000','Lenovo',1.3,4,1000,8,5,0.3,2000,'Android',4,709800,16449),
(150,'Lenovo A6000 Shot','Lenovo',1.2,4,2000,16,13,5,2300,'Android',5,1198000,20489),
(151,'Lenovo Vibe P1m','Lenovo',1,4,2000,16,8,5,3900,'Android',5,1399800,19000),
(152,'Lenovo A2010','Lenovo',1,4,1000,8,5,2,2000,'Android',4.5,1200000,24383),
(153,'OnePlus 7T Pro McLaren Edition','OnePlus',2.96,8,12000,256,48,16,4085,'Android',6.67,11799600,495701),
(154,'OnePlus 7T','OnePlus',2.96,8,8000,128,48,16,3800,'Android',6.55,6986000,487810),
(155,'OnePlus 7T Pro','OnePlus',2.96,8,8000,256,48,16,4085,'Android',6.67,10598000,477166),
(156,'OnePlus 7 Pro','OnePlus',2.84,8,6000,128,48,16,4000,'Android',6.67,7999000,371812),
(157,'OnePlus 6T','OnePlus',2.8,8,6000,128,16,16,3700,'Android',6.41,6399800,297029),
(158,'OnePlus 6','OnePlus',2.8,8,6000,64,16,16,3300,'Android',6.28,6999800,263931),
(159,'OnePlus 3T','OnePlus',2.35,4,6000,64,16,16,3400,'Android',5.5,3999800,145000),
(160,'OnePlus 3','OnePlus',2.15,4,6000,64,16,8,3000,'Android',5.5,4599800,142406),
(161,'OnePlus 7','OnePlus',2.84,8,6000,128,48,16,3700,'Android',6.41,5999800,369292),
(162,'OnePlus 5T','OnePlus',2.45,8,6000,64,16,16,3300,'Android',6.01,5699800,187566),
(163,'OnePlus 5','OnePlus',2.45,8,6000,64,16,16,3300,'Android',5.5,3499800,183038),
(164,'OnePlus One','OnePlus',2.5,4,3000,16,13,5,3100,'Cyanogen',5.5,4399800,46219),
(165,'Oppo K3','Oppo',2.2,8,6000,64,16,16,3765,'Android',6.5,4798000,171577),
(166,'Oppo Reno 10x Zoom','Oppo',2.84,8,6000,128,48,16,4065,'Android',6.6,7398000,421577),
(167,'Oppo Reno 2Z','Oppo',2.2,8,8000,256,48,16,4000,'Android',6.53,4620000,217093),
(168,'Oppo A9','Oppo',2,8,4000,128,16,16,4020,'Android',6.53,2398000,155118),
(169,'Oppo K1','Oppo',2.2,8,4000,64,16,25,3600,'Android',6.41,1998000,127618),
(170,'Oppo R17 Pro','Oppo',2.2,8,8000,128,12,25,3700,'Android',6.4,4259800,171584),
(171,'Oppo Find X','Oppo',2.8,8,8000,256,16,25,3730,'Android',6.42,11818000,298166),
(172,'Oppo F7','Oppo',2,8,4000,64,16,25,3400,'Android',6.23,3798000,149210),
(173,'Oppo F5','Oppo',2.5,8,4000,32,16,20,3200,'Android',6,2099800,68931),
(174,'Oppo F3 Plus','Oppo',1.95,8,4000,64,16,16,4000,'Android',6,2798000,92852),
(175,'Oppo F1','Oppo',1.7,8,3000,16,13,8,2500,'Android',5,1799800,35677),
(176,'Oppo F15','Oppo',2.1,8,8000,128,48,16,4000,'Android',6.4,3738000,195381),
(177,'Oppo A9 2020','Oppo',2,8,4000,128,48,16,5000,'Android',6.5,2946000,155118),
(178,'Oppo A1k','Oppo',2,8,2000,32,8,5,4000,'Android',6.1,1334000,83667),
(179,'Oppo A5s','Oppo',2.3,8,2000,32,13,8,4230,'Android',6.2,1587000,100722),
(180,'Oppo F9 Pro','Oppo',2,8,6000,64,16,25,3500,'Android',6.3,3598000,137691),
(181,'Oppo F9','Oppo',2,8,4000,64,16,16,3500,'Android',6.3,2398800,126339),
(182,'Oppo A83','Oppo',2.3,8,2000,16,13,8,3180,'Android',5.7,1359800,80000),
(183,'Oppo F3','Oppo',1.5,8,4000,64,13,16,3200,'Android',5.5,2398000,47384),
(184,'Oppo A57','Oppo',1.4,8,3000,32,13,16,2900,'Android',5.2,2400000,42000),
(185,'Oppo F1s','Oppo',1.5,8,3000,32,13,16,3075,'Android',5.5,3198000,47742),
(186,'Oppo F1 Plus','Oppo',2,8,4000,64,13,16,2850,'Android',5.5,3598000,50974),
(187,'Oppo N1 Mini','Oppo',1.6,4,2000,16,13,0,2140,'Android',5,1998000,23000),
(188,'Oppo R1','Oppo',1.3,4,1000,16,8,5,2410,'Android',5,2347000,18409),
(189,'Oppo Reno 2F','Oppo',2.1,8,8000,128,48,16,4000,'Android',6.53,4180000,186219),
(190,'Oppo Reno','Oppo',2.3,8,8000,128,48,16,3765,'Android',6.4,5398000,176509),
(191,'Oppo R15 Pro','Oppo',2.2,8,6000,128,20,20,3400,'Android',6.28,2859800,134239),
(192,'Oppo R17','Oppo',2,8,8000,128,16,25,3500,'Android',6.4,3598000,155388),
(193,'Oppo A3s','Oppo',1.8,8,2000,16,13,8,4230,'Android',6.2,1490000,73851),
(194,'Oppo A5','Oppo',1.8,8,4000,32,13,8,4230,'Android',6.2,1798000,151776),
(195,'Oppo A83 (2018)','Oppo',2.3,8,2000,16,13,8,3180,'Android',5.7,1898000,80000),
(196,'Oppo A71 (2018)','Oppo',1.8,8,3000,16,13,5,3000,'Android',5.2,1599800,57570),
(197,'Oppo A71','Oppo',1.5,8,2000,16,13,5,3000,'Android',5.2,1698000,70116),
(198,'Oppo A37','Oppo',1.2,4,2000,16,8,5,2630,'Android',5,1733200,28000),
(199,'Oppo Neo 7','Oppo',1.2,4,1000,16,8,5,2420,'Android',5,1640000,21313),
(200,'Realme X2 Pro','Realme',2.96,8,6000,64,64,16,4000,'Android',6.5,5599800,471779),
(201,'Realme X','Realme',2.2,8,4000,128,48,16,3765,'Android',6.53,2999800,156669),
(202,'Realme 3 Pro','Realme',2.2,8,4000,64,16,25,4045,'Android',6.3,2799800,159114),
(203,'Realme C3','Realme',2,8,3000,32,12,5,5000,'Android',6.52,1399800,148177),
(204,'Realme 5i','Realme',2,8,4000,64,12,8,5000,'Android',6.52,1799800,148115),
(205,'Realme 5s','Realme',2,8,4000,64,48,13,5000,'Android',6.5,1999800,144911),
(206,'Realme X2','Realme',2.2,8,4000,64,64,32,4000,'Android',6.4,3399800,266028),
(207,'Realme XT','Realme',2.3,8,4000,64,64,16,4000,'Android',6.4,2999800,211277),
(208,'Realme 5 Pro','Realme',2.3,8,4000,64,48,16,4035,'Android',6.3,2399800,181883),
(209,'Realme 5','Realme',2,8,3000,32,12,13,5000,'Android',6.5,1720000,148115),
(210,'Realme U1','Realme',2.1,8,3000,32,13,25,3500,'Android',6.3,1799800,145021),
(211,'Realme 2 Pro','Realme',2,8,4000,64,16,16,3500,'Android',6.3,2354000,132931),
(212,'Realme 1','Realme',2,8,3000,32,13,8,3410,'Android',6,2059800,140263),
(213,'Realme 3i','Realme',2,8,3000,32,13,13,4230,'Android',6.2,1399800,133123),
(214,'Realme C2','Realme',2,8,2000,16,13,5,4000,'Android',6.1,1199800,73559),
(215,'Realme 3','Realme',2,8,3000,32,13,13,4230,'Android',6.2,1698000,140118),
(216,'Realme C1','Realme',1.8,8,2000,16,13,5,4230,'Android',6.2,1598000,73689),
(217,'Realme 2','Realme',1.8,8,3000,32,13,8,4230,'Android',6.2,1778000,75744),
(218,'Samsung Galaxy Note 10+','Samsung',2.73,8,12000,256,12,10,4300,'Android',6.8,15939800,466272),
(219,'Samsung Galaxy Note 9','Samsung',2.8,8,6000,128,12,8,4000,'Android',6.4,11399800,401884),
(220,'Samsung Galaxy S9+','Samsung',2.7,8,6000,64,12,8,3500,'Android',6.2,5999800,379763),
(221,'Samsung Galaxy S9','Samsung',2.7,8,4000,64,12,8,3000,'Android',5.8,5399800,368733),
(222,'Samsung Galaxy Note 8','Samsung',2.3,8,6000,64,12,8,3300,'Android',6.3,9999800,169420),
(223,'Samsung Galaxy S8+','Samsung',2.3,8,4000,64,12,8,3500,'Android',6.2,6000000,200784),
(224,'Samsung Galaxy S8','Samsung',2.35,8,4000,64,12,8,3000,'Android',5.8,5398800,232537),
(225,'Samsung Galaxy C9 Pro','Samsung',1.95,8,6000,64,16,16,4000,'Android',6,3399800,73000),
(226,'Samsung Galaxy S7 Edge','Samsung',2.15,8,4000,32,12,5,3600,'Android',5.5,7999200,112338),
(227,'Samsung Galaxy S7','Samsung',2.3,8,4000,32,12,5,3000,'Android',5.1,4799800,134828),
(228,'Samsung Galaxy A8','Samsung',2.2,8,2000,32,16,5,3050,'Android',5.7,1459800,122400),
(229,'Samsung Galaxy S6','Samsung',2.1,8,3000,32,16,5,2550,'Android',5.1,5199800,82000),
(230,'Samsung Galaxy S10 Lite','Samsung',2.84,8,8000,128,48,32,4500,'Android',6.7,7999800,452117),
(231,'Samsung Galaxy Note 10 Lite','Samsung',2.7,8,6000,128,12,32,4500,'Android',6.7,7799800,321581),
(232,'Samsung Galaxy M30s','Samsung',2.3,8,4000,64,48,16,6000,'Android',6.4,2599800,135678),
(233,'Samsung Galaxy A50s','Samsung',2.3,8,4000,128,48,32,4000,'Android',6.4,3330000,176588),
(234,'Samsung Galaxy M40','Samsung',2,8,6000,128,32,16,3500,'Android',6.3,3375800,227344),
(235,'Samsung Galaxy A70','Samsung',2,8,6000,128,32,32,4500,'Android',6.7,4459800,176833),
(236,'Samsung Galaxy M20','Samsung',1.8,8,3000,32,13,8,5000,'Android',6.3,1999800,108577),
(237,'Samsung Galaxy M30','Samsung',1.8,8,3000,32,13,16,5000,'Android',6.4,1899800,106880),
(238,'Samsung Galaxy A9 (2018)','Samsung',2.2,8,6000,128,24,24,3800,'Android',6.3,4400000,117139),
(239,'Samsung Galaxy A7 (2018)','Samsung',2.2,8,4000,64,24,24,3300,'Android',6,3298000,122673),
(240,'Samsung Galaxy On Max','Samsung',2.3,8,4000,32,13,13,3300,'Android',5.7,1978000,28312),
(241,'Samsung Galaxy C7 Pro','Samsung',2.2,1,4000,64,16,16,3300,'Android',5.7,3399800,60000),
(242,'Samsung Galaxy J7 Prime','Samsung',1.6,8,3000,16,13,8,3300,'Android',5.5,3199000,45234),
(243,'Samsung Galaxy A5 (2016)','Samsung',1.6,8,2000,16,13,5,2900,'Android',5.2,3998000,41430),
(244,'Samsung Galaxy S6 Edge+','Samsung',2.1,8,4000,32,16,5,3000,'Android',5.7,3599800,140567),
(245,'Samsung Galaxy Note 5','Samsung',2.1,8,4000,32,16,5,3000,'Android',5.7,2999800,84000),
(246,'Samsung Galaxy S6 Edge','Samsung',2.1,8,3000,32,16,5,2600,'Android',5.1,5199800,68127),
(247,'Samsung Galaxy Note 4','Samsung',1.9,4,3000,32,16,3.7,3220,'Android',5.7,5580000,52635),
(248,'Samsung Galaxy Note Edge','Samsung',2.7,4,3000,32,16,3.7,3000,'Android',5.6,5990000,65000),
(249,'Samsung Galaxy S5','Samsung',2.5,8,2000,16,16,2,2800,'Android',5.1,6799800,43000),
(250,'Samsung Galaxy Grand 2','Samsung',1.2,4,1000,8,8,1.9,2600,'Android',5.2,3199800,17000),
(251,'Samsung Galaxy Note 3','Samsung',2.3,8,3000,32,13,2,3200,'Android',5.7,10130000,44210),
(252,'Samsung Galaxy S III','Samsung',1.4,4,1000,16,8,1.9,2100,'Android',4.8,1199800,5438),
(253,'Samsung Galaxy S4','Samsung',1.6,8,2000,16,13,2,2600,'Android',5,11583000,33000),
(254,'Samsung Galaxy M10s','Samsung',1.6,8,3000,32,13,8,4000,'Android',6.4,1699800,116000),
(255,'Samsung Galaxy J8','Samsung',1.8,8,4000,64,16,16,3500,'Android',6,3099800,70397),
(256,'Samsung Galaxy J6','Samsung',1.6,8,3000,32,13,8,3000,'Android',5.6,1898000,56475),
(257,'Samsung Galaxy A6+','Samsung',1.8,8,4000,64,16,24,3500,'Android',6,3199800,60184),
(258,'Samsung Galaxy A8+ (2018)','Samsung',2.2,8,6000,64,16,16,3500,'Android',6,3380000,116440),
(259,'Samsung Galaxy A7 (2017)','Samsung',1.9,8,3000,32,16,16,3600,'Android',5.7,5180000,61811),
(260,'Samsung Galaxy A5 (2017)','Samsung',1.9,8,3000,32,16,16,3000,'Android',5.2,3799800,60476),
(261,'Samsung Galaxy Alpha','Samsung',1.8,8,2000,32,12,2.1,1860,'Android',4.7,1999800,51000),
(262,'Samsung Galaxy Note 3 Neo','Samsung',1.3,6,2000,16,8,2,3100,'Android',5.5,2250000,31228),
(263,'Samsung Galaxy Y Pro Duos','Samsung',0.8,1,384,0,3.2,0.3,1350,'Android',2.6,1111000,2012),
(264,'Samsung Galaxy Mega 5,8','Samsung',1.4,2,1000,8,8,1.9,2600,'Android',5.8,1399800,9125),
(265,'Samsung Galaxy M10','Samsung',1.6,8,2000,16,13,5,3400,'Android',6.22,1399800,63935),
(266,'Samsung Galaxy J6+','Samsung',1.4,4,4000,64,13,8,3300,'Android',6,2399800,43635),
(267,'Samsung Galaxy J4+','Samsung',1.4,4,2000,32,13,5,3300,'Android',6,1899800,42405),
(268,'Samsung Galaxy J2 Core','Samsung',1.4,4,1000,8,8,5,2600,'Android',5,1238000,35524),
(269,'Samsung Galaxy On7 Prime','Samsung',1.6,8,3000,32,13,13,3300,'Android',5.5,2198000,46935),
(270,'Samsung Galaxy S4 Zoom','Samsung',1.5,2,1000,8,16,1.9,2330,'Android',4.3,3198000,9530),
(271,'Samsung Galaxy Pocket','Samsung',0.8,1,289,3,2,0,1200,'Android',2.8,638000,4300),
(272,'Samsung Galaxy Grand Duos','Samsung',1.2,2,1000,8,8,2,2100,'Android',5,1799800,1111),
(273,'Samsung Galaxy S20+','Samsung',2.84,8,8000,128,12,10,4500,'Android',6.7,14799800,503288),
(274,'Samsung Galaxy S20 Ultra','Samsung',2.73,8,12000,128,108,40,5000,'Android',6.9,18599800,511288),
(275,'Samsung Galaxy Z Flip','Samsung',2.95,8,8000,256,12,10,3300,'Android',6.7,34998000,468775),
(276,'Samsung Galaxy S20','Samsung',2.73,8,8000,128,12,10,4000,'Android',6.2,13399800,512775),
(277,'Samsung Galaxy A70s','Samsung',2,8,6000,128,64,32,4500,'Android',6.7,5199800,175477),
(278,'Samsung Galaxy A20s','Samsung',1.8,8,3000,32,13,8,4000,'Android',6.5,2199800,85425),
(279,'Samsung Galaxy A30s','Samsung',1.8,8,4000,64,25,16,4000,'Android',6.4,2796000,117622),
(280,'Samsung Galaxy A10s','Samsung',2,8,2000,32,13,8,4000,'Android',6.2,1699800,79833),
(281,'Samsung Galaxy Note 10','Samsung',2.73,8,8000,256,12,10,3500,'Android',6.3,13999800,466272),
(282,'Samsung Galaxy A80','Samsung',2.2,8,8000,128,48,0,3700,'Android',6.7,7198000,216110),
(283,'Samsung Galaxy A2 Core','Samsung',1.6,8,1000,16,5,5,2600,'Android',5,1058000,46000),
(284,'Samsung Galaxy A20','Samsung',1.6,8,3000,32,13,8,4000,'Android',6.4,1980000,90211),
(285,'Samsung Galaxy Fold','Samsung',2.84,8,12000,512,16,10,4380,'Android',7.3,32999800,445125),
(286,'Samsung Galaxy A8 Star','Samsung',2.2,8,6000,64,16,24,3700,'Android',6.28,4160000,141222),
(287,'Samsung Galaxy On8 (2018)','Samsung',1.8,8,4000,64,16,16,3500,'Android',6,3998000,58000),
(288,'Samsung Galaxy On6','Samsung',1.6,8,4000,64,13,8,3000,'Android',5.6,3520000,37492),
(289,'Samsung Galaxy J4','Samsung',1.4,4,2000,16,13,5,3000,'Android',5.5,1384800,56108),
(290,'Samsung Galaxy A6','Samsung',1.6,8,4000,32,16,16,3000,'Android',5.6,2599800,38125),
(291,'Samsung Galaxy J2 (2018)','Samsung',1.4,4,2000,16,8,5,2600,'Android',5,1359800,31000),
(292,'Samsung Galaxy J7 Duo','Samsung',2.2,8,4000,32,13,8,3000,'Android',5.5,2128000,97636),
(293,'Samsung Galaxy J7 Prime 2','Samsung',1.6,8,3000,32,13,13,3300,'Android',5.5,2100000,38174),
(294,'Samsung Galaxy J2 (2017)','Samsung',1.3,4,1000,8,5,2,2000,'Android',4.7,1200000,19253),
(295,'Samsung Galaxy J7 Nxt','Samsung',1.6,8,2000,16,13,5,3000,'Android',5.5,2198000,53896),
(296,'Samsung Galaxy J7 Max','Samsung',2.3,8,4000,32,13,13,3300,'Android',5.7,2209200,28312),
(297,'Samsung Galaxy J7 Pro','Samsung',1.6,8,3000,64,13,13,3600,'Android',5.5,3380000,48000),
(298,'Samsung Z4','Samsung',1.5,4,1000,8,5,5,1050,'Tizen',4.5,958000,17546),
(299,'Samsung Galaxy J2 Ace','Samsung',1.5,1,1000,8,8,5,2600,'Android',5,1198000,28638),
(300,'Samsung Galaxy On Nxt','Samsung',1.6,8,3000,16,13,8,3300,'Android',5.5,2240000,42118),
(301,'Samsung Galaxy On8','Samsung',1.6,8,3000,16,13,5,3300,'Android',5.5,1599800,58000),
(302,'Samsung Galaxy J5 Prime','Samsung',1.4,4,2000,16,13,5,2400,'Android',5,2499800,37000),
(303,'Samsung Galaxy Folder 2','Samsung',1.4,4,2000,16,8,5,1950,'Android',3.8,3398000,36368),
(304,'Samsung Z2','Samsung',1.5,4,1000,8,5,0.3,1500,'Tizen',4,719800,14529),
(305,'Samsung Galaxy J2 Pro','Samsung',1.4,4,2000,16,8,5,2600,'Android',5,2096000,18797),
(306,'Samsung Galaxy On7 Pro','Samsung',1.2,4,2000,16,13,5,3000,'Android',5.5,1198000,21620),
(307,'Samsung Galaxy On5 Pro','Samsung',1.3,4,2000,16,8,5,2600,'Android',5,1296000,23343),
(308,'Samsung Galaxy J2 (2016)','Samsung',1.5,4,1000,8,8,5,2600,'Android',5,1198000,66108),
(309,'Samsung Galaxy J3 Pro','Samsung',1.2,4,2000,16,8,5,2600,'Android',5,1659800,29000),
(310,'Samsung Galaxy A9 Pro','Samsung',2.2,8,4000,32,16,8,5000,'Android',6,3996000,73592),
(311,'Samsung Galaxy J7 (2016)','Samsung',1.6,8,2000,16,13,5,3300,'Android',5.5,2690000,45185),
(312,'Samsung Galaxy J5 (2016)','Samsung',1.2,4,2000,16,13,5,3100,'Android',5.2,1999800,22134),
(313,'Samsung Galaxy A7 (2016)','Samsung',1.6,8,3000,16,13,5,3300,'Android',5.5,1999800,38404),
(314,'Samsung Galaxy J3 (6)','Samsung',1.2,4,1000,8,8,5,2600,'Android',5,999800,24700),
(315,'Samsung Galaxy On7','Samsung',1.2,4,1000,8,13,5,3000,'Android',5.5,1995400,59564),
(316,'Samsung Galaxy On5','Samsung',1.3,4,1000,8,8,5,2600,'Android',5,931000,18000),
(317,'Samsung Z3','Samsung',1.3,4,1000,8,8,5,2600,'Tizen',5,998000,18173),
(318,'Samsung Galaxy J1 Ace','Samsung',1.2,2,512,4,5,2,1800,'Android',4.3,860000,14529),
(319,'Vivo V17','Vivo',2,8,8000,128,48,32,4500,'Android',6.44,4230000,178463),
(320,'Vivo U20','Vivo',2,8,4000,64,16,16,5000,'Android',6.53,2198000,189355),
(321,'Vivo V17 Pro','Vivo',2,8,8000,128,48,32,4100,'Android',6.44,5244000,179166),
(322,'Vivo Z1x','Vivo',2.3,8,4000,128,48,32,4500,'Android',6.38,3198000,186499),
(323,'Vivo Z1 Pro','Vivo',2.3,8,4000,64,16,32,5000,'Android',6.53,2598000,188244),
(324,'Vivo V15 Pro','Vivo',2,8,6000,128,48,32,3700,'Android',6.39,3594600,181480),
(325,'Vivo V9 Pro','Vivo',2.2,8,4000,64,13,16,3260,'Android',6.3,3298000,97000),
(326,'Vivo V11 Pro','Vivo',2.2,8,6000,64,12,25,3400,'Android',6.41,2998000,127961),
(327,'Vivo Nex','Vivo',2.2,8,8000,128,12,8,4000,'Android',6.59,5999800,287985),
(328,'Vivo X21','Vivo',2.2,8,6000,64,12,12,3200,'Android',6.28,3658000,138210),
(329,'Vivo S1 Pro','Vivo',2,8,8000,128,48,32,4500,'Android',6.38,3719800,176442),
(330,'Vivo U10','Vivo',2,8,3000,32,13,8,5000,'Android',6.35,1798000,168654),
(331,'Vivo Y17','Vivo',2.3,8,4000,128,13,20,5000,'Android',6.35,2298000,98444),
(332,'Vivo S1','Vivo',2.1,8,4000,128,16,32,4500,'Android',6.38,2995800,38933),
(333,'Vivo V15','Vivo',2.1,8,6000,64,12,32,4000,'Android',6.53,2998000,138933),
(334,'Vivo V9','Vivo',2.2,8,4000,64,16,24,3260,'Android',6.3,2748000,67000),
(335,'Vivo V7','Vivo',1.8,8,4000,32,16,24,3000,'Android',5.7,2798000,73255),
(336,'Vivo V7+','Vivo',1.8,8,4000,64,16,24,3225,'Android',5.99,2198000,56389),
(337,'Vivo V5s','Vivo',1.5,8,4000,64,13,20,3000,'Android',5.5,2598000,42299),
(338,'Vivo V5 Plus','Vivo',2,8,4000,64,16,20,3055,'Android',5.5,2500000,62065),
(339,'Vivo V5','Vivo',1.5,8,4000,32,13,20,3000,'Android',5.5,3308200,41025),
(340,'Vivo V3Max','Vivo',1.8,8,4000,32,13,8,3000,'Android',5.5,3595800,75000),
(341,'Vivo Y15','Vivo',2,4,512,4,5,2,1900,'Android',4.5,1307800,80335),
(342,'Vivo Y66','Vivo',1.4,8,3000,32,13,16,3000,'Android',5.5,2199800,40571),
(343,'Vivo Y55s','Vivo',1.4,4,3000,16,13,5,2730,'Android',5.2,2198000,32000),
(344,'Vivo V3','Vivo',1.5,8,3000,32,13,8,2550,'Android',5,2996000,34999),
(345,'Vivo V1Max','Vivo',1.5,8,2000,16,13,5,2720,'Android',5.5,2600000,30654),
(346,'Vivo Y19','Vivo',2,8,4000,128,16,16,5000,'Android',6.53,2798000,178335),
(347,'Vivo Y12','Vivo',2,8,3000,64,8,8,5000,'Android',6.35,1910000,73288),
(348,'Vivo Y91i','Vivo',1.95,8,2000,16,13,5,4030,'Android',6.22,1359800,88000),
(349,'Vivo Y91','Vivo',1.95,8,2000,32,13,8,4030,'Android',6.22,1669800,76383),
(350,'Vivo Y95','Vivo',1.95,8,4000,64,13,20,4030,'Android',6.22,2099800,87833),
(351,'Vivo Y93','Vivo',1.95,8,3000,64,13,8,4030,'Android',6.2,1990000,88706),
(352,'Vivo V11','Vivo',2,8,6000,64,16,25,3315,'Android',6.3,2845800,145377),
(353,'Vivo Y83 Pro','Vivo',2,8,4000,64,13,8,3260,'Android',6.22,2790000,78000),
(354,'Vivo Y71i','Vivo',1.4,4,2000,16,8,5,3285,'Android',6,1500000,37322),
(355,'Vivo Z10','Vivo',1.8,8,4000,32,16,24,3225,'Android',6,1598800,58000),
(356,'Vivo Y81','Vivo',2,8,3000,32,13,5,3260,'Android',6.22,1958000,70000),
(357,'Vivo Y83','Vivo',2,8,4000,32,13,8,3260,'Android',6.22,2079800,85499),
(358,'Vivo Y53i','Vivo',1.4,4,2000,16,8,5,2500,'Android',5,1541200,31000),
(359,'Vivo V9 Youth','Vivo',1.8,8,4000,32,16,16,3260,'Android',6.3,1798000,76528),
(360,'Vivo Y71','Vivo',1.4,4,3000,16,13,5,3360,'Android',6,1700000,32000),
(361,'Vivo Y53','Vivo',1.4,4,2000,16,8,5,2500,'Android',5,1698000,31000),
(362,'Vivo Y69','Vivo',1.5,8,3000,32,13,16,3000,'Android',5.5,1900000,32018),
(363,'Vivo Y55L','Vivo',1.4,8,2000,16,8,5,2730,'Android',5.2,2090000,35698),
(364,'Vivo Y21L','Vivo',1.2,4,1000,16,5,2,2000,'Android',4.5,1420000,20515),
(365,'Vivo X7','Vivo',1.8,8,4000,64,13,16,3000,'Android',5.2,1999800,81000),
(366,'Vivo Y31L','Vivo',1.2,4,1000,16,8,5,2200,'Android',4.7,1719800,169774),
(367,'Vivo Y51L','Vivo',1.2,4,2000,16,8,5,2350,'Android',5,1819800,176355),
(368,'Vivo Y15S','Vivo',2.3,4,1000,8,5,2,1900,'Android',4.5,999800,121590),
(369,'Vivo Y27L','Vivo',1.2,4,1000,16,8,5,2260,'Android',4.7,1800200,21278),
(370,'Vivo V1','Vivo',1.2,4,2000,16,13,5,2300,'Android',5,3060000,22115),
(371,'Xiaomi Redmi K20 Pro','Xiaomi',2.84,8,6000,128,48,20,4000,'Android',6.39,4638000,388446),
(372,'Xiaomi Redmi K20','Xiaomi',2.2,8,6000,64,48,20,4000,'Android',6.39,3856400,209539),
(373,'Redmi Note 7 Pro','Xiaomi',2,8,4000,64,48,13,4000,'Android',6.3,1959800,181664),
(374,'Redmi Note 5 Pro','Xiaomi',1.8,8,4000,64,12,20,4000,'Android',5.99,1869800,108776),
(375,'Xiaomi Mi 5','Xiaomi',1.8,4,3000,32,16,4,3000,'Android',5.15,4999800,131648),
(376,'Xiaomi Redmi Note','Xiaomi',1.7,8,2000,8,13,5,3100,'Android',5.5,1599800,64537),
(377,'Redmi Note 8 Pro','Xiaomi',2.05,8,6000,64,64,20,4500,'Android',6.53,2799800,288911),
(378,'Xiaomi Mi A3','Xiaomi',2,8,4000,64,48,32,4030,'Android',6.08,2369000,147114),
(379,'Redmi Note 7S','Xiaomi',2.2,8,3000,32,48,13,4000,'Android',6.3,1729800,141951),
(380,'Redmi Note 7','Xiaomi',2.2,8,3000,32,12,13,4000,'Android',6.3,1939800,138441),
(381,'Xiaomi Redmi 7','Xiaomi',1.8,8,2000,16,12,8,4000,'Android',6.26,1466400,99554),
(382,'Xiaomi Redmi Note 6 Pro','Xiaomi',1.8,8,4000,64,12,20,4000,'Android',6.26,1916000,94706),
(383,'Xiaomi Mi A2','Xiaomi',2.2,8,4000,64,12,20,3000,'Android',5.99,1798000,143277),
(384,'Xiaomi Mi MIX 2','Xiaomi',2.45,8,6000,64,12,5,3400,'Android',5.99,5999800,180675),
(385,'Mi A1','Xiaomi',2,8,4000,32,12,5,3080,'Android',5.5,1999800,64523),
(386,'Redmi 5','Xiaomi',1.8,8,2000,16,12,5,3300,'Android',5.7,1299800,56883),
(387,'Redmi Note 5','Xiaomi',1.8,8,3000,32,12,5,4000,'Android',5.99,1739800,108776),
(388,'Xiaomi Mi Max 2','Xiaomi',2,8,4000,32,12,5,5300,'Android',6.44,1799800,60292),
(389,'Xiaomi Redmi 4A','Xiaomi',1.4,4,2000,16,13,5,3120,'Android',5,1399800,35060),
(390,'Xiaomi Redmi 4','Xiaomi',2,8,2000,16,13,5,4100,'Android',5,1799800,37550),
(391,'Xiaomi Redmi Note 4','Xiaomi',2,8,2000,32,13,5,4100,'Android',5.5,1998000,61477),
(392,'Xiaomi Redmi 3S Prime','Xiaomi',1.4,8,3000,32,13,5,4100,'Android',5,1600000,41968),
(393,'Xiaomi Mi Max','Xiaomi',1.8,6,3000,32,16,5,4850,'Android',6.44,2398000,60292),
(394,'Xiaomi Redmi Note 3','Xiaomi',1.4,6,2000,16,16,5,4050,'Android',5.5,1379800,47201),
(395,'Xiaomi Mi 4i','Xiaomi',1.7,8,2000,16,13,5,3120,'Android',5,2599800,40253),
(396,'Xiaomi Mi 4','Xiaomi',2.5,4,3000,16,13,8,3080,'Android',5,1597400,44072),
(397,'Xiaomi Mi 3','Xiaomi',2.3,4,2000,16,13,2,3050,'Android',5,2799800,55200),
(398,'Redmi 8A','Xiaomi',1.95,8,2000,32,12,8,5000,'Android',6.22,1299800,88112),
(399,'Redmi Note 8','Xiaomi',2,8,3000,32,48,13,4000,'Android',6.3,1839000,167833),
(400,'Redmi 8','Xiaomi',1.95,8,4000,64,12,8,5000,'Android',6.22,1599800,75188),
(401,'Redmi 7A','Xiaomi',1.95,8,2000,16,12,5,4000,'Android',5.45,1099800,80388),
(402,'Xiaomi Redmi Y3','Xiaomi',1.8,8,3000,32,12,32,4000,'Android',6.26,1599800,104342),
(403,'Redmi Go','Xiaomi',1.4,4,1000,8,8,5,3000,'Android',5,899800,33199),
(404,'Xiaomi Redmi 6 Pro','Xiaomi',2,8,3000,32,12,5,4000,'Android',5.84,1658000,87111),
(405,'Xiaomi Redmi 6A','Xiaomi',2,4,2000,16,13,5,3000,'Android',5.45,1139800,55399),
(406,'Xiaomi Redmi Y2','Xiaomi',2,8,3000,32,12,16,3080,'Android',5.99,1599800,61000),
(407,'Redmi 6','Xiaomi',2,8,3000,32,12,5,3000,'Android',5.45,1436000,70311),
(408,'Redmi Y1','Xiaomi',1.4,8,2000,16,13,16,3080,'Android',5.5,1698000,40212),
(409,'Redmi 5A','Xiaomi',1.4,4,2000,16,13,5,3000,'Android',5,1439800,32266),
(410,'Xiaomi Redmi 2 Prime','Xiaomi',1.2,4,2000,16,8,2,2200,'Android',4.7,1399800,24000),
(411,'Xiaomi Redmi 2','Xiaomi',1.2,4,1000,8,8,2,2200,'Android',4.7,1079800,23559),
(412,'Xiaomi Redmi 1S','Xiaomi',1.6,4,1000,8,8,1.6,2000,'Android',4.7,1199800,21467),
(413,'Redmi 8A Dual','Xiaomi',1.95,8,2000,32,13,8,5000,'Android',6.22,1299800,74199),
(414,'Redmi Y1 Lite','Xiaomi',1.4,4,2000,16,13,5,3080,'Android',5.5,1199800,31000),
(415,'Xiaomi Mi Max Prime','Xiaomi',1.4,6,4000,128,16,5,4850,'Android',6.44,3999800,97223),
(416,'Xiaomi Redmi 3S','Xiaomi',1.4,8,2000,16,13,5,4100,'Android',5,1300000,37647),
(417,'Xiaomi Redmi Note Prime','Xiaomi',1.2,4,2000,16,13,5,3100,'Android',5.5,1799800,48022);

/*Table structure for table `view_derajat` */

DROP TABLE IF EXISTS `view_derajat`;

/*!50001 DROP VIEW IF EXISTS `view_derajat` */;
/*!50001 DROP TABLE IF EXISTS `view_derajat` */;

/*!50001 CREATE TABLE  `view_derajat`(
 `id` int(6) ,
 `nama` varchar(34) ,
 `kec_prosesor` double ,
 `kec_prosesor_pelan` double ,
 `kec_prosesor_sedang` double ,
 `kec_prosesor_cepat` double ,
 `core_prosesor` int(13) ,
 `core_prosesor_biasa` decimal(17,4) ,
 `core_prosesor_sedang` decimal(17,4) ,
 `core_prosesor_bagus` decimal(17,4) ,
 `ram` int(5) ,
 `ram_kecil` decimal(15,4) ,
 `ram_sedang` decimal(15,4) ,
 `ram_besar` decimal(15,4) ,
 `mem_internal` int(12) ,
 `mem_internal_kecil` decimal(16,4) ,
 `mem_internal_sedang` decimal(16,4) ,
 `mem_internal_besar` decimal(16,4) ,
 `kam_utama` double ,
 `kam_utama_rendah` double ,
 `kam_utama_sedang` double ,
 `kam_utama_besar` double ,
 `kam_sekunder` double ,
 `kam_sekunder_rendah` double ,
 `kam_sekunder_sedang` double ,
 `kam_sekunder_besar` double ,
 `baterai` int(7) ,
 `baterai_kecil` decimal(15,4) ,
 `baterai_sedang` decimal(15,4) ,
 `baterai_besar` decimal(15,4) ,
 `so` varchar(11) ,
 `so_android` int(1) ,
 `so_ios` int(1) ,
 `so_lainnya` int(1) ,
 `uk_layar` double ,
 `uk_layar_kecil` double ,
 `uk_layar_sedang` double ,
 `uk_layar_besar` double ,
 `harga` int(8) ,
 `harga_murah` decimal(15,4) ,
 `harga_sedang` decimal(15,4) ,
 `harga_mahal` decimal(15,4) ,
 `performa` int(8) ,
 `performa_rendah` decimal(15,4) ,
 `performa_menengah` decimal(15,4) ,
 `performa_tinggi` decimal(15,4) 
)*/;

/*View structure for view view_derajat */

/*!50001 DROP TABLE IF EXISTS `view_derajat` */;
/*!50001 DROP VIEW IF EXISTS `view_derajat` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_derajat` AS (select `tb_smartphone`.`id` AS `id`,`tb_smartphone`.`nama` AS `nama`,`tb_smartphone`.`kec_prosesor` AS `kec_prosesor`,case when `tb_smartphone`.`kec_prosesor` <= 1.5 then 1 when `tb_smartphone`.`kec_prosesor` >= 2 then 0 when `tb_smartphone`.`kec_prosesor` > 1.5 and `tb_smartphone`.`kec_prosesor` < 2 then (2 - `tb_smartphone`.`kec_prosesor`) / 0.5 end AS `kec_prosesor_pelan`,case when `tb_smartphone`.`kec_prosesor` <= 1.5 or `tb_smartphone`.`kec_prosesor` >= 2.5 then 0 when `tb_smartphone`.`kec_prosesor` > 1.5 and `tb_smartphone`.`kec_prosesor` <= 2 then (`tb_smartphone`.`kec_prosesor` - 1.5) / 0.5 when `tb_smartphone`.`kec_prosesor` > 2 and `tb_smartphone`.`kec_prosesor` < 2.5 then (2.5 - `tb_smartphone`.`kec_prosesor`) / 0.5 end AS `kec_prosesor_sedang`,case when `tb_smartphone`.`kec_prosesor` <= 2 then 0 when `tb_smartphone`.`kec_prosesor` >= 2.5 then 1 when `tb_smartphone`.`kec_prosesor` > 2 and `tb_smartphone`.`kec_prosesor` < 2.5 then (`tb_smartphone`.`kec_prosesor` - 2) / 0.5 end AS `kec_prosesor_cepat`,`tb_smartphone`.`core_prosesor` AS `core_prosesor`,case when `tb_smartphone`.`core_prosesor` <= 2 then 1 when `tb_smartphone`.`core_prosesor` >= 4 then 0 when `tb_smartphone`.`core_prosesor` > 2 and `tb_smartphone`.`core_prosesor` < 4 then (4 - `tb_smartphone`.`core_prosesor`) / 2 end AS `core_prosesor_biasa`,case when `tb_smartphone`.`core_prosesor` <= 2 or `tb_smartphone`.`core_prosesor` >= 8 then 0 when `tb_smartphone`.`core_prosesor` > 2 and `tb_smartphone`.`core_prosesor` <= 4 then (`tb_smartphone`.`core_prosesor` - 2) / 4 when `tb_smartphone`.`core_prosesor` > 4 and `tb_smartphone`.`core_prosesor` < 8 then (8 - `tb_smartphone`.`core_prosesor`) / 4 end AS `core_prosesor_sedang`,case when `tb_smartphone`.`core_prosesor` <= 4 then 0 when `tb_smartphone`.`core_prosesor` >= 8 then 1 when `tb_smartphone`.`core_prosesor` > 4 and `tb_smartphone`.`core_prosesor` < 8 then (`tb_smartphone`.`core_prosesor` - 4) / 4 end AS `core_prosesor_bagus`,`tb_smartphone`.`ram` AS `ram`,case when `tb_smartphone`.`ram` <= 2000 then 1 when `tb_smartphone`.`ram` >= 4000 then 0 when `tb_smartphone`.`ram` > 2000 and `tb_smartphone`.`ram` < 4000 then (4000 - `tb_smartphone`.`ram`) / 2000 end AS `ram_kecil`,case when `tb_smartphone`.`ram` <= 4000 then 0 when `tb_smartphone`.`ram` >= 6000 then 1 when `tb_smartphone`.`ram` > 4000 and `tb_smartphone`.`ram` < 6000 then (`tb_smartphone`.`ram` - 4000) / 2000 end AS `ram_sedang`,case when `tb_smartphone`.`ram` <= 2000 or `tb_smartphone`.`ram` >= 6000 then 0 when `tb_smartphone`.`ram` > 2000 and `tb_smartphone`.`ram` <= 4000 then (`tb_smartphone`.`ram` - 2000) / 2000 when `tb_smartphone`.`ram` > 4000 and `tb_smartphone`.`ram` < 6000 then (6000 - `tb_smartphone`.`ram`) / 2000 end AS `ram_besar`,`tb_smartphone`.`mem_internal` AS `mem_internal`,case when `tb_smartphone`.`mem_internal` <= 16 then 1 when `tb_smartphone`.`mem_internal` >= 32 then 0 when `tb_smartphone`.`mem_internal` > 16 and `tb_smartphone`.`mem_internal` < 32 then (32 - `tb_smartphone`.`mem_internal`) / 16 end AS `mem_internal_kecil`,case when `tb_smartphone`.`mem_internal` <= 16 or `tb_smartphone`.`mem_internal` >= 64 then 0 when `tb_smartphone`.`mem_internal` >= 16 and `tb_smartphone`.`mem_internal` <= 32 then (`tb_smartphone`.`mem_internal` - 16) / 16 when `tb_smartphone`.`mem_internal` >= 32 and `tb_smartphone`.`mem_internal` <= 64 then (64 - `tb_smartphone`.`mem_internal`) / 32 end AS `mem_internal_sedang`,case when `tb_smartphone`.`mem_internal` <= 32 then 0 when `tb_smartphone`.`mem_internal` >= 64 then 1 when `tb_smartphone`.`mem_internal` > 32 and `tb_smartphone`.`mem_internal` < 64 then (`tb_smartphone`.`mem_internal` - 32) / 32 end AS `mem_internal_besar`,`tb_smartphone`.`kam_utama` AS `kam_utama`,case when `tb_smartphone`.`kam_utama` <= 12 then 1 when `tb_smartphone`.`kam_utama` >= 30 then 0 when `tb_smartphone`.`kam_utama` > 12 and `tb_smartphone`.`kam_utama` < 30 then (30 - `tb_smartphone`.`kam_utama`) / 18 end AS `kam_utama_rendah`,case when `tb_smartphone`.`kam_utama` <= 12 or `tb_smartphone`.`kam_utama` >= 48 then 0 when `tb_smartphone`.`kam_utama` >= 12 and `tb_smartphone`.`kam_utama` <= 30 then (`tb_smartphone`.`kam_utama` - 12) / 18 when `tb_smartphone`.`kam_utama` >= 30 and `tb_smartphone`.`kam_utama` <= 48 then (48 - `tb_smartphone`.`kam_utama`) / 18 end AS `kam_utama_sedang`,case when `tb_smartphone`.`kam_utama` <= 30 then 0 when `tb_smartphone`.`kam_utama` >= 48 then 1 when `tb_smartphone`.`kam_utama` > 30 and `tb_smartphone`.`kam_utama` < 48 then (`tb_smartphone`.`kam_utama` - 30) / 18 end AS `kam_utama_besar`,`tb_smartphone`.`kam_sekunder` AS `kam_sekunder`,case when `tb_smartphone`.`kam_sekunder` <= 1 then 1 when `tb_smartphone`.`kam_sekunder` >= 6 then 0 when `tb_smartphone`.`kam_sekunder` > 1 and `tb_smartphone`.`kam_sekunder` < 6 then (6 - `tb_smartphone`.`kam_sekunder`) / 5 end AS `kam_sekunder_rendah`,case when `tb_smartphone`.`kam_sekunder` <= 5 or `tb_smartphone`.`kam_sekunder` >= 16 then 0 when `tb_smartphone`.`kam_sekunder` >= 5 and `tb_smartphone`.`kam_sekunder` <= 8 then (`tb_smartphone`.`kam_sekunder` - 5) / 3 when `tb_smartphone`.`kam_sekunder` >= 8 and `tb_smartphone`.`kam_sekunder` <= 16 then (16 - `tb_smartphone`.`kam_sekunder`) / 8 end AS `kam_sekunder_sedang`,case when `tb_smartphone`.`kam_sekunder` <= 13 then 0 when `tb_smartphone`.`kam_sekunder` >= 24 then 1 when `tb_smartphone`.`kam_sekunder` > 13 and `tb_smartphone`.`kam_sekunder` < 24 then (`tb_smartphone`.`kam_sekunder` - 13) / 11 end AS `kam_sekunder_besar`,`tb_smartphone`.`baterai` AS `baterai`,case when `tb_smartphone`.`baterai` <= 3000 then 1 when `tb_smartphone`.`baterai` >= 4000 then 0 when `tb_smartphone`.`baterai` > 3000 and `tb_smartphone`.`baterai` < 4000 then (4000 - `tb_smartphone`.`baterai`) / 1000 end AS `baterai_kecil`,case when `tb_smartphone`.`baterai` <= 3000 or `tb_smartphone`.`baterai` >= 5000 then 0 when `tb_smartphone`.`baterai` >= 3000 and `tb_smartphone`.`baterai` <= 4000 then (`tb_smartphone`.`baterai` - 3000) / 1000 when `tb_smartphone`.`baterai` >= 4000 and `tb_smartphone`.`baterai` <= 5000 then (5000 - `tb_smartphone`.`baterai`) / 1000 end AS `baterai_sedang`,case when `tb_smartphone`.`baterai` <= 4000 then 0 when `tb_smartphone`.`baterai` >= 5000 then 1 when `tb_smartphone`.`baterai` > 4000 and `tb_smartphone`.`baterai` < 5000 then (`tb_smartphone`.`baterai` - 4000) / 1000 end AS `baterai_besar`,`tb_smartphone`.`so` AS `so`,case `tb_smartphone`.`so` when 'Android' then 1 else 0 end AS `so_android`,case `tb_smartphone`.`so` when 'iOS' then 1 else 0 end AS `so_ios`,case when `tb_smartphone`.`so` in ('Android','iOS') then 0 else 1 end AS `so_lainnya`,`tb_smartphone`.`uk_layar` AS `uk_layar`,case when `tb_smartphone`.`uk_layar` <= 6 then 1 when `tb_smartphone`.`uk_layar` >= 6.5 then 0 when `tb_smartphone`.`uk_layar` > 6 and `tb_smartphone`.`uk_layar` < 6.5 then (6.5 - `tb_smartphone`.`uk_layar`) / 0.5 end AS `uk_layar_kecil`,case when `tb_smartphone`.`uk_layar` <= 6 or `tb_smartphone`.`uk_layar` >= 7 then 0 when `tb_smartphone`.`uk_layar` >= 6 and `tb_smartphone`.`uk_layar` <= 6.5 then (`tb_smartphone`.`uk_layar` - 6) / 0.5 when `tb_smartphone`.`uk_layar` >= 6.5 and `tb_smartphone`.`uk_layar` <= 7 then (7 - `tb_smartphone`.`uk_layar`) / 0.5 end AS `uk_layar_sedang`,case when `tb_smartphone`.`uk_layar` <= 6.5 then 0 when `tb_smartphone`.`uk_layar` >= 7 then 1 when `tb_smartphone`.`uk_layar` > 6.5 and `tb_smartphone`.`uk_layar` < 7 then (`tb_smartphone`.`uk_layar` - 6.5) / 0.5 end AS `uk_layar_besar`,`tb_smartphone`.`harga` AS `harga`,case when `tb_smartphone`.`harga` <= 1500000 then 1 when `tb_smartphone`.`harga` >= 3000000 then 0 when `tb_smartphone`.`harga` > 1500000 and `tb_smartphone`.`harga` < 3000000 then (3000000 - `tb_smartphone`.`harga`) / 1500000 end AS `harga_murah`,case when `tb_smartphone`.`harga` <= 1500000 or `tb_smartphone`.`harga` >= 4500000 then 0 when `tb_smartphone`.`harga` >= 1500000 and `tb_smartphone`.`harga` <= 3000000 then (`tb_smartphone`.`harga` - 1500000) / 1500000 when `tb_smartphone`.`harga` >= 3000000 and `tb_smartphone`.`harga` <= 4500000 then (4500000 - `tb_smartphone`.`harga`) / 1500000 end AS `harga_sedang`,case when `tb_smartphone`.`harga` <= 3000000 then 0 when `tb_smartphone`.`harga` >= 4500000 then 1 when `tb_smartphone`.`harga` > 3000000 and `tb_smartphone`.`harga` < 4500000 then (`tb_smartphone`.`harga` - 3000000) / 1500000 end AS `harga_mahal`,`tb_smartphone`.`performa` AS `performa`,case when `tb_smartphone`.`performa` <= 54000 then 1 when `tb_smartphone`.`performa` >= 266000 then 0 when `tb_smartphone`.`performa` > 54000 and `tb_smartphone`.`performa` < 266000 then (266000 - `tb_smartphone`.`performa`) / 212000 end AS `performa_rendah`,case when `tb_smartphone`.`performa` <= 250000 or `tb_smartphone`.`performa` >= 380000 then 0 when `tb_smartphone`.`performa` >= 250000 and `tb_smartphone`.`performa` <= 300000 then (`tb_smartphone`.`performa` - 250000) / 50000 when `tb_smartphone`.`performa` >= 300000 and `tb_smartphone`.`performa` <= 380000 then (380000 - `tb_smartphone`.`performa`) / 80000 end AS `performa_menengah`,case when `tb_smartphone`.`performa` <= 370000 then 0 when `tb_smartphone`.`performa` >= 420000 then 1 when `tb_smartphone`.`performa` > 370000 and `tb_smartphone`.`performa` < 420000 then (`tb_smartphone`.`performa` - 370000) / 50000 end AS `performa_tinggi` from `tb_smartphone`) */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;