SQLize Online / PHPize Online  /  SQLtest Online

-- Roxell Brill Activity CREATE TABLE tblTeenagers ([Nickname]varchar(10), [Birthdate] date,[Gender]varchar(6), [Age]int); INSERT INTO tblTeenagers ([Nickname], [Birthdate], [Gender],[Age]) VALUES ('Lucas', '30/03/2002', 'Male', 18), ('Petra', '22/07/2001', 'Female', 19), ('JC', '25/01/2002', 'Male', 18), ('Mateo', '14/02/2000', 'Male', NULL), ('Pablo', '24/08/2003', 'Male', 17), ('Mar', '25/07/2001', 'Female', 19), ('Belle', '01/01/2000', NULL, 20), ('Zai', '09/04/2000', NULL, 20); DELETE FROM tblTeenagers WHERE Nickname = 'Belle';