CREATE DATABASE IF NOT EXISTS data_cleaning;
USE data_cleaning;

CREATE TABLE clientes (
    id INT PRIMARY KEY,
    nombre VARCHAR(100),
    email VARCHAR(150),
    telefono VARCHAR(50),
    ciudad VARCHAR(100),
    fecha_registro VARCHAR(50)
);

show tables;

INSERT INTO clientes (id, nombre, email, telefono, ciudad, fecha_registro) VALUES
(1, 'juan perez', 'JUAN@GMAIL.COM', '11-5555-5555', 'bs as', '2024/01/01 12:00:00'),
(2, '  Maria   Gomez ', 'maria@@hotmail.com', '1155554444', 'CABA', '01-02-24'),
(3, '—', '', '555-8888', 'buenos aires', NULL),
(4, 'Pedro Lopez', 'pedro.lopez@gmail,com', '(011)4444-3333', 'bs.as', '2024-03-10'),
(5, 'ana   lopez', 'ANA.LOPEZ@YAHOO.COM', '11 4444 2222', 'Bs As', '2024-01-05'),
(6, 'CARLOS   Mendez', 'carlos.mendez@hotmail,com', '11-3333-1111', 'caba', '2024/2/10'),
(7, 'luisa fernandez', 'LUISA@GMAIL', '4444-9999', 'buenos aires', '3-4-24'),
(8, '   martin  rojas', 'martin@@gmail.com', '15-5555-3333', 'bs as', '2024/04/03 10:20:00'),
(9, 'santiago torres', 'santiago.torres@gmail,com', '1155-222-333', 'C.A.B.A', '2024-05-01'),
(10, 'rocio   beltran', 'rocio.beltran@gmail.com', ' 1155443322 ', 'Bs.As', '2024-01-20'),
(11, 'Diego Perez', 'DIEGO@GMAIL.COM', '11 4444 5555', 'bs as', '01/01/24'),
(12, '   mariela  suarez', 'mariela.suarez@hotmail', '(011) 2222-3333', 'caba', '2024/02/03'),
(13, 'roberto', 'roberto@@gmail.com', '4444 1111', 'buenos aires', '2024-03-05'),
(14, 'sara  lopez', 'SARA.LOPEZ@YAHOO,COM', '11-2222-2222', 'bs as', '2024/03/15'),
(15, 'lucas   gomez', 'lucas_gomez@gmail', '44442222', 'CABA', '3/5/24'),
(16, 'Agustina', 'agustina@yahoo,com', '(011)5555 7777', 'bs.as', '2024-05-01'),
(17, 'pablo torres', 'pablo@@hotmail.com', '1155332233', 'buenos aires', '2024-06-01'),
(18, '   sofia', 'SOFIA@GMAIL.COM', '11 5555 4444', 'bs as', '2024/06/15'),
(19, 'marcos', 'marcos@@gmail.com', '4444-2222', 'caba', '2024-07-01'),
(20, '—', 'invalid.com', '5555-3333', 'bs as', '2024-07-10'),
(21, 'ana perez', 'ana.perez@gmail,com', '15-3333-4444', 'bs.as', '04/04/24'),
(22, 'pedro', 'pedro@gmail', '4444 3333', 'bs as', '2024/04/20'),
(23, 'claudia', 'claudia@@yahoo.com', '(011)1111-2222', 'CABA', '2024/05/10'),
(24, 'martina', 'martina.gmail.com', '2222-3333', 'buenos aires', '2024-06-11'),
(25, 'leo ', 'LEO@HOTMAIL,COM', '(11)4444-5555', 'bs as', '6/12/24'),
(26, ' carla', 'carla@GMAIL.COM', '11-7777-8888', 'bs.as', '2024/07/15'),
(27, 'jose', 'jose@@hotmail.com', '4444-8888', 'CABA', '2024-08-01'),
(28, 'laura', 'laura@hotmail', '1155447766', 'buenos aires', '2024/08/15'),
(29, 'maria', 'maria@gmail', '(011)4444 2222', 'bs as', '2024-09-10'),
(30, 'roberto ', 'roberto.gmail.com', '5555-4444', 'caba', '2024-10-01'),
(31,'julian mendez','julian@@gmail.com','11 3333-4444','Bs As','2024/03/01'),
(32,' angelica','ANGELICA@HOTMAIL','5555 1111','buenos aires','04/04/24'),
(33,'marco','marco.gmail.com','4444-5555','caba','2024-05-21'),
(34,'carina','carina@@yahoo.com','15-2222-3333','bs as','2024/06/17'),
(35,'luciana','luciana@GMAIL,COM','4444-0000','bs.as','2024-05-11'),
(36,'nahuel','nahuel@hotmail','1155443322','Bs As','2024/07/19'),
(37,'walter','walter@@gmail.com','(011) 5555 6666','caba','2024-08-22'),
(38,'marta','marta.gmail.com','5555 2222','bs as','2024/09/12'),
(39,'carlos','carlos@@hotmail.com','4444-9999','buenos aires','2024/10/25'),
(40,'estela','ESTELA@GMAIL','44447777','bs.as','2024/01/15'),
(41,'victoria','victoria@@gmail.com','11-1111-2222','bs as','2024/02/28'),
(42,'oscar','OSCAR@HOTMAIL,COM','555 6666','caba','2024/03/14'),
(43,'ramiro','ramiro.gmail.com','(011) 44443333','bs as','2024-05-20'),
(44,'alejandra','alejandra@@yahoo.com','5555-2222','CABA','2024/04/20'),
(45,'luis','luis@gmail','1155445566','buenos aires','2024/04/19'),
(46,'gustavo','gustavo@@gmail.com','2222 3333','bs.as','2024/05/09'),
(47,'emilia','emilia@HOTMAIL','4444-7777','bs as','2024/08/18'),
(48,'andrea','andrea@@gmail.com','1155667788','caba','2024/05/06'),
(49,'julieta','julieta.gmail.com','15 9999 3333','bs as','2024-06-08'),
(50,'patricia','patricia@@gmail.com','(011)22223333','bs.as','2024/07/03'),
(51,'marcela','marcela@hotmail','44441111','bs as','2024/08/01'),
(52,'fernando','fernando@@gmail.com','11112222','buenos aires','2024/08/02'),
(53,'tomas','tomas.gmail.com','(011)9999-8888','caba','2024/08/03'),
(54,'natalia','natalia@@GMAIL.COM','1144445555','bs.as','2024/08/04'),
(55,'rodrigo','rodrigo@GMAIL','1155332211','CABA','2024/08/05'),
(56,'martin','martin@@hotmail.com','44445555','bs as','2024/08/06'),
(57,'dario','dario.gmail.com','(011) 2222-1111','buenos aires','2024/08/07'),
(58,'lorena','lorena@@GMAIL.COM','5555 3333','bs as','2024/08/08'),
(59,'leticia','leticia@hotmail','1177774444','bs.as','2024/08/09'),
(60,'sofia','sofia@@gmail.com','4444-8888','caba','2024/08/10'),
(61,'alejandro','alejandro@gmail','4444 2222','bs as','2024/08/11'),
(62,'mario','mario@@gmail.com','1155443344','buenos aires','2024/08/12'),
(63,'fatima','fatima.GMAIL.COM','44443322','bs.as','2024/08/13'),
(64,'veronica','veronica@@hotmail.com','(011)55554444','caba','2024/08/14'),
(65,'julia','julia.gmail.com','44440000','bs as','2024/08/15'),
(66,'camila','camila@@gmail.com','15-2222-3333','CABA','2024/08/16'),
(67,'elias','elias@hotmail','4444-4444','bs.as','2024/08/17'),
(68,'daniel','daniel@@GMAIL.COM','(011)44445555','bs as','2024/08/18'),
(69,'ignacio','ignacio@gmail,com','5555 6666','buenos aires','2024/08/19'),
(70,'alejo','alejo@@gmail.com','9999 1111','bs.as','2024/08/20'),
(71,'cintia','cintia@gmail','44447777','caba','2024/08/21'),
(72,'florencia','florencia@@hotmail.com','1155667788','bs as','2024/08/22'),
(73,'micaela','micaela.gmail.com','(011)33334444','bs.as','2024/08/23'),
(74,'axel','axel@@gmail.com','7777 2222','buenos aires','2024/08/24'),
(75,'joel','joel@GMAIL','44445555','bs as','2024/08/25'),
(76,'marina','marina@@hotmail.com','22223333','bs.as','2024/08/26'),
(77,'hector','hector.gmail.com','(011) 77774444','caba','2024/08/27'),
(78,'ricardo','ricardo@@gmail.com','44448888','buenos aires','2024/08/28'),
(79,'viviana','viviana@hotmail','44447788','bs.as','2024/08/29'),
(80,'noelia','noelia@@gmail.com','(011) 22220000','bs as','2024/08/30'),
(81,'valentin','valentin@gmail','1155663322','bs.as','2024/09/01'),
(82,'paula','paula@@hotmail.com','44441122','caba','2024/09/02'),
(83,'federico','federico.gmail.com','22220000','bs as','2024/09/03'),
(84,'gisela','gisela@@gmail.com','6666 4444','buenos aires','2024/09/04'),
(85,'maxi','maxi@hotmail','44448899','bs.as','2024/09/05'),
(86,'sebastian','sebastian@@gmail.com','1155332255','CABA','2024/09/06'),
(87,'tamara','tamara.gmail.com','(011)33335555','bs as','2024/09/07'),
(88,'antonella','antonella@@gmail.com','1155445566','bs.as','2024/09/08'),
(89,'andres','andres@gmail','44447711','buenos aires','2024/09/09'),
(90,'ernesto','ernesto@@hotmail.com','44443311','caba','2024/09/10'),
(91,'lola','lola.gmail.com','(011) 88889999','bs as','2024/09/11'),
(92,'julio','julio@@gmail.com','44446666','bs.as','2024/09/12'),
(93,'damian','damian@hotmail','44448811','CABA','2024/09/13'),
(94,'ruben','ruben@@gmail.com','55553333','buenos aires','2024/09/14'),
(95,'ines','ines.gmail.com','1155334411','bs.as','2024/09/15'),
(96,'omar','omar@@hotmail.com','(011)77774411','bs as','2024/09/16'),
(97,'mica','mica@gmail','44441100','caba','2024/09/17'),
(98,'nicolas','nicolas@@gmail.com','1155223344','bs as','2024/09/18'),
(99,'celeste','celeste.gmail.com','55552222','bs.as','2024/09/19'),
(100,'ramon','ramon@@hotmail.com','44447733','buenos aires','2024/09/20');
