students data (MySQL)

Fork
CREATE TABLE phones (
    id INT PRIMARY KEY,
    brand VARCHAR(50),
    model VARCHAR(100),
    price INT,
    processor VARCHAR(100),
    ram INT,
    storage INT,
    display_size DECIMAL(3,1),
    camera_mp INT,
    battery_mah INT,
    os VARCHAR(50),
    rating DECIMAL(2,1),
    launch_year INT,
    is_5g BOOLEAN,
    color VARCHAR(50)
);

INSERT INTO phones VALUES
(1,'Samsung','Galaxy S24',79999,'Snapdragon 8 Gen 3',8,256,6.2,50,4000,'Android',4.5,2024,TRUE,'Black'),
(2,'Samsung','Galaxy S24+',99999,'Snapdragon 8 Gen 3',12,256,6.7,50,4900,'Android',4.6,2024,TRUE,'Blue'),
(3,'Samsung','Galaxy S24 Ultra',129999,'Snapdragon 8 Gen 3',12,256,6.8,200,5000,'Android',4.8,2024,TRUE,'Titanium Black'),
(4,'Samsung','Galaxy S23',69999,'Snapdragon 8 Gen 2',8,128,6.1,50,3900,'Android',4.5,2023,TRUE,'Green'),
(5,'Samsung','Galaxy S23+',84999,'Snapdragon 8 Gen 2',8,256,6.6,50,4700,'Android',4.5,2023,TRUE,'Cream'),
(6,'Samsung','Galaxy S23 Ultra',109999,'Snapdragon 8 Gen 2',12,256,6.8,200,5000,'Android',4.7,2023,TRUE,'Green'),
(7,'Samsung','Galaxy S22',49999,'Snapdragon 8 Gen 1',8,128,6.1,50,3700,'Android',4.3,2022,TRUE,'Black'),
(8,'Samsung','Galaxy A55',42999,'Exynos 1480',8,128,6.6,50,5000,'Android',4.3,2024,TRUE,'Blue'),
(9,'Samsung','Galaxy A35',33999,'Exynos 1380',8,128,6.6,50,5000,'Android',4.2,2024,TRUE,'Navy'),
(10,'Samsung','Galaxy A54',38999,'Exynos 1380',8,128,6.4,50,5000,'Android',4.2,2023,TRUE,'White'),
(11,'Samsung','Galaxy M55',29999,'Snapdragon 7 Gen 1',8,128,6.7,50,5000,'Android',4.1,2024,TRUE,'Denim'),
(12,'Samsung','Galaxy M35',22999,'Exynos 1380',8,128,6.6,50,6000,'Android',4.2,2024,TRUE,'Dark Blue'),
(13,'Samsung','Galaxy F55',32999,'Snapdragon 7 Gen 1',8,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Apricot'),
(14,'Samsung','Galaxy A25',24999,'Exynos 1280',8,128,6.5,50,5000,'Android',4.0,2023,TRUE,'Blue'),
(15,'Samsung','Galaxy M15',15999,'Dimensity 6100+',6,128,6.5,50,6000,'Android',4.1,2024,TRUE,'Light Blue'),

(16,'Apple','iPhone 15',69999,'A16 Bionic',6,128,6.1,48,3349,'iOS',4.6,2023,TRUE,'Black'),
(17,'Apple','iPhone 15 Plus',79999,'A16 Bionic',6,128,6.7,48,4383,'iOS',4.6,2023,TRUE,'Blue'),
(18,'Apple','iPhone 15 Pro',99999,'A17 Pro',8,128,6.1,48,3274,'iOS',4.7,2023,TRUE,'Natural Titanium'),
(19,'Apple','iPhone 15 Pro Max',119999,'A17 Pro',8,256,6.7,48,4441,'iOS',4.8,2023,TRUE,'Blue Titanium'),
(20,'Apple','iPhone 14',59999,'A15 Bionic',6,128,6.1,12,3279,'iOS',4.5,2022,TRUE,'Blue'),
(21,'Apple','iPhone 14 Plus',69999,'A15 Bionic',6,128,6.7,12,4323,'iOS',4.5,2022,TRUE,'Purple'),
(22,'Apple','iPhone 14 Pro',89999,'A16 Bionic',6,128,6.1,48,3200,'iOS',4.7,2022,TRUE,'Gold'),
(23,'Apple','iPhone 14 Pro Max',99999,'A16 Bionic',6,128,6.7,48,4323,'iOS',4.8,2022,TRUE,'Deep Purple'),
(24,'Apple','iPhone 13',49999,'A15 Bionic',4,128,6.1,12,3240,'iOS',4.5,2021,TRUE,'Midnight'),
(25,'Apple','iPhone 13 Pro',69999,'A15 Bionic',6,128,6.1,12,3095,'iOS',4.6,2021,TRUE,'Sierra Blue'),
(26,'Apple','iPhone 13 Pro Max',79999,'A15 Bionic',6,128,6.7,12,4352,'iOS',4.7,2021,TRUE,'Graphite'),
(27,'Apple','iPhone 13 Mini',54999,'A15 Bionic',4,128,5.4,12,2438,'iOS',4.4,2021,TRUE,'Pink'),
(28,'Apple','iPhone SE 2022',39999,'A15 Bionic',4,64,4.7,12,2018,'iOS',4.2,2022,TRUE,'Red'),
(29,'Apple','iPhone 12',42999,'A14 Bionic',4,64,6.1,12,2815,'iOS',4.3,2020,TRUE,'Blue'),
(30,'Apple','iPhone 12 Mini',39999,'A14 Bionic',4,64,5.4,12,2227,'iOS',4.2,2020,TRUE,'Black'),

(31,'OnePlus','12',64999,'Snapdragon 8 Gen 3',12,256,6.8,50,5400,'Android',4.6,2024,TRUE,'Green'),
(32,'OnePlus','12R',39999,'Snapdragon 8 Gen 2',8,128,6.8,50,5500,'Android',4.5,2024,TRUE,'Blue'),
(33,'OnePlus','11',56999,'Snapdragon 8 Gen 2',8,128,6.7,50,5000,'Android',4.5,2023,TRUE,'Titan Black'),
(34,'OnePlus','11R',39999,'Snapdragon 8+ Gen 1',8,128,6.7,50,5000,'Android',4.4,2023,TRUE,'Galactic Silver'),
(35,'OnePlus','10 Pro',54999,'Snapdragon 8 Gen 1',8,128,6.7,48,5000,'Android',4.3,2022,TRUE,'Emerald Forest'),
(36,'OnePlus','10T',44999,'Snapdragon 8+ Gen 1',8,128,6.7,50,4800,'Android',4.3,2022,TRUE,'Jade Green'),
(37,'OnePlus','Nord 4',29999,'Snapdragon 7+ Gen 3',8,128,6.7,50,5500,'Android',4.4,2024,TRUE,'Mercurial Silver'),
(38,'OnePlus','Nord CE4',24999,'Snapdragon 7 Gen 3',8,128,6.7,50,5500,'Android',4.2,2024,TRUE,'Dark Chrome'),
(39,'OnePlus','Nord CE3',21999,'Snapdragon 782G',8,128,6.7,50,5000,'Android',4.1,2023,TRUE,'Aqua Surge'),
(40,'OnePlus','Nord CE3 Lite',18999,'Snapdragon 695',8,128,6.7,108,5000,'Android',4.0,2023,TRUE,'Pastel Lime'),
(41,'OnePlus','Nord 3',33999,'Dimensity 9000',8,128,6.7,50,5000,'Android',4.3,2023,TRUE,'Misty Green'),
(42,'OnePlus','Nord CE2',19999,'Dimensity 900',6,128,6.4,64,4500,'Android',4.0,2022,TRUE,'Bahama Blue'),
(43,'OnePlus','9 Pro',49999,'Snapdragon 888',8,128,6.7,48,4500,'Android',4.2,2021,TRUE,'Morning Mist'),
(44,'OnePlus','9',39999,'Snapdragon 888',8,128,6.5,48,4500,'Android',4.2,2021,TRUE,'Winter Mist'),
(45,'OnePlus','8T',32999,'Snapdragon 865',8,128,6.5,48,4500,'Android',4.1,2020,TRUE,'Aquamarine'),

(46,'Google','Pixel 9',79999,'Tensor G4',12,128,6.3,50,4700,'Android',4.6,2024,TRUE,'Obsidian'),
(47,'Google','Pixel 9 Pro',99999,'Tensor G4',16,128,6.3,50,4700,'Android',4.7,2024,TRUE,'Hazel'),
(48,'Google','Pixel 9 Pro XL',109999,'Tensor G4',16,128,6.8,50,5060,'Android',4.8,2024,TRUE,'Porcelain'),
(49,'Google','Pixel 8',69999,'Tensor G3',8,128,6.2,50,4575,'Android',4.5,2023,TRUE,'Hazel'),
(50,'Google','Pixel 8 Pro',89999,'Tensor G3',12,128,6.7,50,5050,'Android',4.7,2023,TRUE,'Bay'),
(51,'Google','Pixel 7',49999,'Tensor G2',8,128,6.3,50,4355,'Android',4.4,2022,TRUE,'Snow'),
(52,'Google','Pixel 7 Pro',69999,'Tensor G2',12,128,6.7,50,5000,'Android',4.5,2022,TRUE,'Obsidian'),
(53,'Google','Pixel 7a',39999,'Tensor G2',8,128,6.1,64,4385,'Android',4.3,2023,TRUE,'Charcoal'),
(54,'Google','Pixel 6a',29999,'Tensor',6,128,6.1,12,4410,'Android',4.2,2022,TRUE,'Sage'),
(55,'Google','Pixel 6',44999,'Tensor',8,128,6.4,50,4614,'Android',4.2,2021,TRUE,'Sorta Seafoam'),

(56,'Xiaomi','14',69999,'Snapdragon 8 Gen 3',12,512,6.4,50,4610,'Android',4.6,2024,TRUE,'Black'),
(57,'Xiaomi','14 Civi',42999,'Snapdragon 8s Gen 3',8,256,6.6,50,4700,'Android',4.4,2024,TRUE,'Matcha Green'),
(58,'Xiaomi','13 Pro',79999,'Snapdragon 8 Gen 2',12,256,6.7,50,4820,'Android',4.6,2023,TRUE,'Ceramic White'),
(59,'Xiaomi','13',59999,'Snapdragon 8 Gen 2',8,256,6.4,50,4500,'Android',4.5,2023,TRUE,'Black'),
(60,'Xiaomi','13T Pro',49999,'Dimensity 9200+',12,256,6.7,50,5000,'Android',4.4,2023,TRUE,'Alpine Blue'),
(61,'Xiaomi','12 Pro',59999,'Snapdragon 8 Gen 1',8,256,6.7,50,4600,'Android',4.3,2022,TRUE,'Noir Black'),
(62,'Xiaomi','12',49999,'Snapdragon 8 Gen 1',8,128,6.3,50,4500,'Android',4.2,2022,TRUE,'Blue'),
(63,'Xiaomi','11T Pro',39999,'Snapdragon 888',8,128,6.7,108,5000,'Android',4.2,2021,TRUE,'Celestial Blue'),
(64,'Xiaomi','11 Lite NE',29999,'Snapdragon 778G',6,128,6.6,64,4250,'Android',4.1,2021,TRUE,'Diamond Dazzle'),
(65,'Xiaomi','Redmi Note 13 Pro+',31999,'Dimensity 7200 Ultra',8,256,6.7,200,5000,'Android',4.3,2024,TRUE,'Fusion Black'),
(66,'Xiaomi','Redmi Note 13 Pro',27999,'Snapdragon 7s Gen 2',8,128,6.7,200,5100,'Android',4.2,2024,TRUE,'Lavender Purple'),
(67,'Xiaomi','Redmi Note 13',18999,'Dimensity 6080',6,128,6.7,100,5000,'Android',4.1,2024,TRUE,'Mint Green'),
(68,'Xiaomi','Redmi Note 12 Pro+',29999,'Dimensity 1080',8,256,6.7,200,4980,'Android',4.2,2023,TRUE,'Midnight Black'),
(69,'Xiaomi','Redmi Note 12',17999,'Snapdragon 685',6,128,6.7,50,5000,'Android',4.0,2023,TRUE,'Ice Blue'),
(70,'Xiaomi','Redmi 13C',11999,'Helio G85',6,128,6.7,50,5000,'Android',3.9,2023,FALSE,'Glacier White'),

(71,'Realme','GT 6',40999,'Snapdragon 8s Gen 3',8,256,6.8,50,5500,'Android',4.5,2024,TRUE,'Fluid Silver'),
(72,'Realme','GT 6T',30999,'Snapdragon 7+ Gen 3',8,128,6.8,50,5500,'Android',4.4,2024,TRUE,'Fluid Silver'),
(73,'Realme','GT 5 Pro',54999,'Snapdragon 8 Gen 3',12,256,6.8,50,5400,'Android',4.5,2023,TRUE,'Red Rock'),
(74,'Realme','GT Neo 3',36999,'Dimensity 8100',8,128,6.7,50,5000,'Android',4.3,2022,TRUE,'Nitro Blue'),
(75,'Realme','12 Pro+',29999,'Snapdragon 7s Gen 2',8,128,6.7,50,5000,'Android',4.3,2024,TRUE,'Submarine Blue'),
(76,'Realme','12 Pro',25999,'Snapdragon 6 Gen 1',8,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Navigator Beige'),
(77,'Realme','12+',21999,'Dimensity 7050',8,128,6.7,50,5000,'Android',4.1,2024,TRUE,'Pioneer Green'),
(78,'Realme','11 Pro+',27999,'Dimensity 7050',8,256,6.7,200,5000,'Android',4.2,2023,TRUE,'Sunrise Beige'),
(79,'Realme','11 Pro',23999,'Dimensity 7050',8,128,6.7,100,5000,'Android',4.1,2023,TRUE,'Oasis Green'),
(80,'Realme','Narzo 70 Pro',19999,'Dimensity 7050',8,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Glass Green'),
(81,'Realme','Narzo 70',15999,'Dimensity 7050',6,128,6.7,50,5000,'Android',4.0,2024,TRUE,'Ice Blue'),
(82,'Realme','Narzo 60 Pro',23999,'Dimensity 7050',8,128,6.7,100,5000,'Android',4.1,2023,TRUE,'Mars Orange'),
(83,'Realme','C67 5G',13999,'Dimensity 6100+',6,128,6.7,50,5000,'Android',4.0,2023,TRUE,'Sunny Oasis'),
(84,'Realme','C55',11999,'Helio G88',6,128,6.7,64,5000,'Android',3.9,2023,FALSE,'Sunshower'),
(85,'Realme','C53',9999,'Unisoc T612',6,128,6.7,108,5000,'Android',3.8,2023,FALSE,'Champion Gold'),

(86,'Vivo','X100',63999,'Dimensity 9300',12,256,6.8,50,5400,'Android',4.6,2024,TRUE,'Asteroid Black'),
(87,'Vivo','X100 Pro',89999,'Dimensity 9300',16,512,6.8,50,5400,'Android',4.7,2024,TRUE,'Startrail Blue'),
(88,'Vivo','X90',59999,'Dimensity 9200',8,256,6.8,50,4810,'Android',4.5,2023,TRUE,'Breeze Blue'),
(89,'Vivo','X90 Pro',84999,'Dimensity 9200',12,256,6.8,50,4870,'Android',4.6,2023,TRUE,'Legendary Black'),
(90,'Vivo','V30 Pro',46999,'Dimensity 8200',8,256,6.8,50,5000,'Android',4.4,2024,TRUE,'Andaman Blue'),
(91,'Vivo','V30',33999,'Snapdragon 7 Gen 3',8,128,6.8,50,5000,'Android',4.3,2024,TRUE,'Peacock Green'),
(92,'Vivo','V29',32999,'Snapdragon 778G',8,128,6.8,50,4600,'Android',4.2,2023,TRUE,'Himalayan Blue'),
(93,'Vivo','V27 Pro',37999,'Dimensity 8200',8,128,6.8,50,4600,'Android',4.3,2023,TRUE,'Magic Blue'),
(94,'Vivo','V25 Pro',35999,'Dimensity 1300',8,128,6.6,64,4830,'Android',4.1,2022,TRUE,'Sailing Blue'),
(95,'Vivo','T3 Pro',24999,'Snapdragon 7 Gen 3',8,128,6.8,50,5500,'Android',4.2,2024,TRUE,'Emerald Green'),
(96,'Vivo','T3',21999,'Dimensity 7200',8,128,6.7,50,5000,'Android',4.1,2024,TRUE,'Crystal Flake'),
(97,'Vivo','T2 5G',19999,'Snapdragon 695',6,128,6.4,64,4500,'Android',4.0,2023,TRUE,'Velocity Blue'),
(98,'Vivo','Y200',21999,'Snapdragon 4 Gen 2',8,128,6.7,50,5000,'Android',4.0,2024,TRUE,'Jungle Green'),
(99,'Vivo','Y100',24999,'Snapdragon 695',8,128,6.4,64,4500,'Android',4.0,2023,TRUE,'Pacific Blue'),
(100,'Vivo','Y28',14999,'Snapdragon 4 Gen 2',6,128,6.7,50,6000,'Android',3.9,2024,TRUE,'Glitter Aqua'),

(101,'Oppo','Find X7',69999,'Dimensity 9300',12,256,6.8,50,5000,'Android',4.6,2024,TRUE,'Ocean Blue'),
(102,'Oppo','Find X7 Ultra',99999,'Snapdragon 8 Gen 3',16,512,6.8,50,5000,'Android',4.7,2024,TRUE,'Desert Silver'),
(103,'Oppo','Reno 12 Pro',44999,'Dimensity 7300 Energy',12,256,6.7,50,5000,'Android',4.4,2024,TRUE,'Space Brown'),
(104,'Oppo','Reno 12',37999,'Dimensity 7300 Energy',8,256,6.7,50,5000,'Android',4.3,2024,TRUE,'Black Brown'),
(105,'Oppo','Reno 11 Pro',39999,'Dimensity 8200',12,256,6.7,50,4600,'Android',4.3,2024,TRUE,'Pearl White'),
(106,'Oppo','Reno 11',32999,'Dimensity 7050',8,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Rock Grey'),
(107,'Oppo','Reno 10 Pro+',54999,'Snapdragon 8+ Gen 1',12,256,6.7,64,4700,'Android',4.4,2023,TRUE,'Glossy Purple'),
(108,'Oppo','Reno 10 Pro',39999,'Snapdragon 778G',12,256,6.7,50,4600,'Android',4.2,2023,TRUE,'Glossy Purple'),
(109,'Oppo','Reno 10',29999,'Dimensity 7050',8,256,6.7,64,5000,'Android',4.1,2023,TRUE,'Ice Blue'),
(110,'Oppo','F27 Pro+',27999,'Dimensity 7050',8,128,6.7,64,5000,'Android',4.2,2024,TRUE,'Dusk Pink'),
(111,'Oppo','F25 Pro',23999,'Dimensity 7050',8,128,6.7,64,5000,'Android',4.1,2024,TRUE,'Marble Green'),
(112,'Oppo','A79 5G',19999,'Dimensity 6020',8,128,6.7,50,5000,'Android',4.0,2023,TRUE,'Glowing Green'),
(113,'Oppo','A59 5G',14999,'Dimensity 6020',6,128,6.6,13,5000,'Android',3.9,2023,TRUE,'Starry Black'),
(114,'Oppo','A78 4G',17999,'Snapdragon 680',8,128,6.4,50,5000,'Android',4.0,2023,FALSE,'Aqua Green'),
(115,'Oppo','A58',14999,'Helio G85',6,128,6.7,50,5000,'Android',3.9,2023,FALSE,'Glowing Black'),

(116,'Motorola','Edge 50 Pro',34999,'Snapdragon 7 Gen 3',8,256,6.7,50,4500,'Android',4.4,2024,TRUE,'Luxe Lavender'),
(117,'Motorola','Edge 50 Fusion',22999,'Snapdragon 7s Gen 2',8,128,6.7,50,5000,'Android',4.3,2024,TRUE,'Marshmallow Blue'),
(118,'Motorola','Edge 50 Ultra',59999,'Snapdragon 8s Gen 3',12,512,6.7,50,4500,'Android',4.6,2024,TRUE,'Forest Grey'),
(119,'Motorola','Edge 40 Pro',49999,'Snapdragon 8 Gen 2',12,256,6.7,50,4600,'Android',4.4,2023,TRUE,'Interstellar Black'),
(120,'Motorola','Edge 40',29999,'Dimensity 8020',8,256,6.5,50,4400,'Android',4.2,2023,TRUE,'Nebula Green'),
(121,'Motorola','Edge 30 Pro',39999,'Snapdragon 8 Gen 1',8,128,6.7,50,4800,'Android',4.2,2022,TRUE,'Cosmos Blue'),
(122,'Motorola','Moto G85',17999,'Snapdragon 6s Gen 3',8,128,6.7,50,5000,'Android',4.1,2024,TRUE,'Olive Green'),
(123,'Motorola','Moto G64',14999,'Dimensity 7025',8,128,6.5,50,6000,'Android',4.1,2024,TRUE,'Ice Lilac'),
(124,'Motorola','Moto G54',13999,'Dimensity 7020',8,128,6.5,50,6000,'Android',4.0,2023,TRUE,'Pearl Blue'),
(125,'Motorola','Moto G84',18999,'Snapdragon 695',8,128,6.5,50,5000,'Android',4.1,2023,TRUE,'Viva Magenta'),
(126,'Motorola','Moto G73',18999,'Dimensity 930',8,128,6.5,50,5000,'Android',4.0,2023,TRUE,'Midnight Blue'),
(127,'Motorola','Moto G62',15999,'Snapdragon 695',6,128,6.5,50,5000,'Android',3.9,2022,TRUE,'Frosted Blue'),
(128,'Motorola','Moto G52',13999,'Snapdragon 680',6,128,6.6,50,5000,'Android',4.0,2022,FALSE,'Charcoal Grey'),
(129,'Motorola','Moto G40 Fusion',13999,'Snapdragon 732G',6,128,6.8,64,6000,'Android',3.9,2021,FALSE,'Dynamic Gray'),
(130,'Motorola','Razr 40',69999,'Snapdragon 7 Gen 1',8,256,6.9,64,4200,'Android',4.2,2023,TRUE,'Sage Green'),

(131,'Nothing','Phone 2',44999,'Snapdragon 8+ Gen 1',8,128,6.7,50,4700,'Android',4.4,2023,TRUE,'Dark Grey'),
(132,'Nothing','Phone 2a',23999,'Dimensity 7200 Pro',8,128,6.7,50,5000,'Android',4.3,2024,TRUE,'Black'),
(133,'Nothing','Phone 2a Plus',27999,'Dimensity 7350 Pro',8,256,6.7,50,5000,'Android',4.3,2024,TRUE,'Grey'),
(134,'Nothing','Phone 1',29999,'Snapdragon 778G+',8,128,6.6,50,4500,'Android',4.2,2022,TRUE,'White'),
(135,'Nothing','CMF Phone 1',17999,'Dimensity 7300',6,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Black'),

(136,'iQOO','12',52999,'Snapdragon 8 Gen 3',12,256,6.8,50,5000,'Android',4.6,2023,TRUE,'Legend Edition'),
(137,'iQOO','12 Pro',64999,'Snapdragon 8 Gen 3',16,512,6.8,50,5100,'Android',4.7,2023,TRUE,'Track Black'),
(138,'iQOO','Neo 9 Pro',36999,'Snapdragon 8 Gen 2',8,128,6.8,50,5160,'Android',4.5,2024,TRUE,'Fiery Red'),
(139,'iQOO','Neo 7 Pro',32999,'Snapdragon 8+ Gen 1',8,128,6.8,50,5000,'Android',4.4,2023,TRUE,'Fearless Flame'),
(140,'iQOO','Z9',21999,'Dimensity 7200',8,128,6.7,50,5000,'Android',4.2,2024,TRUE,'Brushed Green'),
(141,'iQOO','Z9x',14999,'Snapdragon 6 Gen 1',6,128,6.7,50,6000,'Android',4.0,2024,TRUE,'Tornado Green'),
(142,'iQOO','Z7 Pro',23999,'Dimensity 7200',8,128,6.8,64,4600,'Android',4.2,2023,TRUE,'Blue Lagoon'),
(143,'iQOO','Z7',18999,'Dimensity 920',6,128,6.4,64,4500,'Android',4.1,2023,TRUE,'Pacific Night'),
(144,'iQOO','Z6 Pro',24999,'Snapdragon 778G',8,128,6.4,64,4700,'Android',4.1,2022,TRUE,'Legion Sky'),
(145,'iQOO','9 Pro',59999,'Snapdragon 8 Gen 1',8,256,6.8,50,4700,'Android',4.3,2022,TRUE,'Legendary Track'),

(146,'Poco','F6',29999,'Snapdragon 8s Gen 3',8,256,6.7,50,5000,'Android',4.4,2024,TRUE,'Black'),
(147,'Poco','F6 Pro',39999,'Snapdragon 8 Gen 2',12,256,6.7,50,5000,'Android',4.5,2024,TRUE,'White'),
(148,'Poco','X6 Pro',26999,'Dimensity 8300 Ultra',8,256,6.7,64,5000,'Android',4.4,2024,TRUE,'Grey'),
(149,'Poco','X6',22999,'Snapdragon 7s Gen 2',8,256,6.7,64,5100,'Android',4.2,2024,TRUE,'Snowstorm White'),
(150,'Poco','X5 Pro',22999,'Snapdragon 778G',6,128,6.7,108,5000,'Android',4.2,2023,TRUE,'Horizon Blue'),
(151,'Poco','X5',18999,'Snapdragon 695',6,128,6.7,48,5000,'Android',4.0,2023,TRUE,'Supernova Green'),
(152,'Poco','M6 Pro',15999,'Helio G99 Ultra',8,128,6.7,64,5000,'Android',4.0,2024,FALSE,'Purple'),
(153,'Poco','M6 5G',12999,'Dimensity 6100+',6,128,6.7,50,5000,'Android',3.9,2023,TRUE,'Orion Blue'),
(154,'Poco','C65',9999,'Helio G85',6,128,6.7,50,5000,'Android',3.8,2023,FALSE,'Pastel Blue'),
(155,'Poco','C55',8999,'Helio G85',6,128,6.7,50,5000,'Android',3.8,2023,FALSE,'Cool Blue'),

(156,'Lava','Agni 3',20999,'Dimensity 7300X',8,256,6.8,50,5000,'Android',4.1,2024,TRUE,'Pristine Black'),
(157,'Lava','Agni 2',19999,'Dimensity 7050',8,256,6.8,50,4700,'Android',4.0,2023,TRUE,'Viridian'),
(158,'Lava','Blaze Curve',17999,'Dimensity 7300',8,128,6.7,64,5000,'Android',4.0,2024,TRUE,'Glass Blue'),
(159,'Lava','Blaze 5G',11999,'Dimensity 700',6,128,6.5,50,5000,'Android',3.8,2022,TRUE,'Green'),
(160,'Lava','Storm 5G',11999,'Dimensity 6080',8,128,6.8,50,5000,'Android',3.9,2023,TRUE,'Thunder Black'),

(161,'Nokia','X30 5G',48999,'Snapdragon 695',8,256,6.4,50,4200,'Android',4.0,2022,TRUE,'Cloudy Blue'),
(162,'Nokia','G60 5G',29999,'Snapdragon 695',6,128,6.6,50,4500,'Android',3.9,2022,TRUE,'Pure Black'),
(163,'Nokia','G42 5G',15999,'Snapdragon 480+',6,128,6.6,50,5000,'Android',3.8,2023,TRUE,'So Pink'),
(164,'Nokia','G21',13999,'Unisoc T606',6,128,6.5,50,5050,'Android',3.7,2022,FALSE,'Nordic Blue'),
(165,'Nokia','C32',9999,'Unisoc SC9863A',4,64,6.5,50,5000,'Android',3.6,2023,FALSE,'Autumn Green'),

(166,'Sony','Xperia 1 V',99999,'Snapdragon 8 Gen 2',12,256,6.5,48,5000,'Android',4.5,2023,TRUE,'Black'),
(167,'Sony','Xperia 5 V',79999,'Snapdragon 8 Gen 2',8,128,6.1,48,5000,'Android',4.4,2023,TRUE,'Black'),
(168,'Sony','Xperia 10 V',39999,'Snapdragon 695',6,128,6.1,48,5000,'Android',4.0,2023,TRUE,'Black'),
(169,'Sony','Xperia 1 IV',99999,'Snapdragon 8 Gen 1',12,256,6.5,12,5000,'Android',4.3,2022,TRUE,'Purple'),
(170,'Sony','Xperia 10 IV',34999,'Snapdragon 695',6,128,6.0,12,5000,'Android',3.9,2022,TRUE,'White'),

(171,'Asus','ROG Phone 8',109999,'Snapdragon 8 Gen 3',16,512,6.8,50,5500,'Android',4.6,2024,TRUE,'Phantom Black'),
(172,'Asus','ROG Phone 8 Pro',119999,'Snapdragon 8 Gen 3',16,512,6.8,50,5500,'Android',4.7,2024,TRUE,'Phantom Black'),
(173,'Asus','Zenfone 11 Ultra',89999,'Snapdragon 8 Gen 3',12,256,6.8,50,5500,'Android',4.5,2024,TRUE,'Eternal Black'),
(174,'Asus','Zenfone 10',69999,'Snapdragon 8 Gen 2',8,128,5.9,50,4300,'Android',4.4,2023,TRUE,'Midnight Black'),
(175,'Asus','ROG Phone 7',74999,'Snapdragon 8 Gen 2',12,256,6.8,50,6000,'Android',4.5,2023,TRUE,'Phantom Black'),

(176,'Honor','200 Pro',57999,'Snapdragon 8s Gen 3',12,512,6.8,50,5200,'Android',4.5,2024,TRUE,'Ocean Cyan'),
(177,'Honor','200',39999,'Snapdragon 7 Gen 3',8,256,6.7,50,5200,'Android',4.3,2024,TRUE,'Black'),
(178,'Honor','90',29999,'Snapdragon 7 Gen 1',8,256,6.7,200,5000,'Android',4.2,2023,TRUE,'Diamond Silver'),
(179,'Honor','X9b',25999,'Snapdragon 6 Gen 1',8,256,6.8,108,5800,'Android',4.1,2024,TRUE,'Sunrise Orange'),
(180,'Honor','X9',19999,'Snapdragon 680',8,128,6.8,64,4800,'Android',4.0,2022,FALSE,'Titanium Silver'),

(181,'Tecno','Phantom V Fold',79999,'Dimensity 9000+',12,256,7.9,50,5000,'Android',4.2,2023,TRUE,'Black'),
(182,'Tecno','Phantom V Flip',49999,'Dimensity 8050',8,256,6.9,64,4000,'Android',4.1,2023,TRUE,'Iconic Black'),
(183,'Tecno','Camon 30 Premier',29999,'Dimensity 8200 Ultimate',12,512,6.8,50,5000,'Android',4.2,2024,TRUE,'Black'),
(184,'Tecno','Camon 30 Pro',24999,'Dimensity 8200',8,256,6.8,50,5000,'Android',4.1,2024,TRUE,'Glass Black'),
(185,'Tecno','Pova 6 Pro',19999,'Dimensity 6080',8,256,6.8,108,6000,'Android',4.0,2024,TRUE,'Comet Green'),

(186,'Infinix','GT 20 Pro',24999,'Dimensity 8200 Ultimate',8,256,6.8,108,5000,'Android',4.2,2024,TRUE,'Mecha Blue'),
(187,'Infinix','GT 10 Pro',19999,'Dimensity 8050',8,256,6.7,108,5000,'Android',4.0,2023,TRUE,'Cyber Black'),
(188,'Infinix','Note 40 Pro+',25999,'Dimensity 7020',12,256,6.8,108,4600,'Android',4.1,2024,TRUE,'Vintage Green'),
(189,'Infinix','Note 40 Pro',21999,'Helio G99 Ultimate',8,256,6.8,108,5000,'Android',4.0,2024,FALSE,'Titan Gold'),
(190,'Infinix','Hot 40 Pro',13999,'Helio G99',8,128,6.8,108,5000,'Android',3.9,2023,FALSE,'Starfall Green'),

(191,'ZTE','Axon 40 Ultra',69999,'Snapdragon 8 Gen 1',8,256,6.8,64,5000,'Android',4.1,2022,TRUE,'Black'),
(192,'ZTE','Axon 50 Ultra',59999,'Snapdragon 8 Gen 2',12,256,6.7,64,5000,'Android',4.2,2023,TRUE,'Black'),
(193,'ZTE','Nubia Z60 Ultra',64999,'Snapdragon 8 Gen 3',12,256,6.8,50,6000,'Android',4.4,2023,TRUE,'Black'),
(194,'ZTE','Nubia RedMagic 9 Pro',69999,'Snapdragon 8 Gen 3',12,256,6.8,50,6500,'Android',4.5,2023,TRUE,'Snowfall'),
(195,'ZTE','Nubia Neo 2 5G',19999,'Unisoc T820',8,256,6.7,50,5200,'Android',4.0,2024,TRUE,'Black'),

(196,'Microsoft','Surface Duo 2',139999,'Snapdragon 888',8,128,8.3,12,4449,'Android',4.0,2021,TRUE,'Obsidian'),
(197,'Huawei','P50 Pro',69999,'Snapdragon 888',8,256,6.6,50,4360,'HarmonyOS',4.2,2021,FALSE,'Golden Black'),
(198,'Huawei','Mate 50 Pro',89999,'Snapdragon 8+ Gen 1',8,256,6.7,50,4700,'HarmonyOS',4.3,2022,FALSE,'Black'),
(199,'HTC','U23 Pro',39999,'Snapdragon 7 Gen 1',8,256,6.7,108,4600,'Android',3.9,2023,TRUE,'Coffee Black'),
(200,'HTC','Desire 22 Pro',29999,'Snapdragon 695',8,128,6.6,64,4520,'Android',3.8,2022,TRUE,'Flowing Black');
UPDATE phones
SET processor = 'acd'
WHERE processor = 'Snapdragon 7 Gen 1';

SELECT model, processor
FROM phones
WHERE processor = 'acd';
Fork
Embed on website
