-- Create a table

CREATE TABLE persoane (
 id INTEGER,
 name TEXT NOT NULL,
 gender TEXT NOT NULL,
 age INTEGER);

-- Insert vaules
INSERT INTO persoane VALUES (1, 'Popa Mihai Consim', 'M', '11');
INSERT INTO persoane VALUES (2, 'Popa Stefan Madalin', 'M', '13');
INSERT INTO persoane VALUES (3, 'Popa Marian Danut', 'M', '51');
INSERT INTO persoane VALUES (4, 'Popa Georgiana Daniela', 'F', '14');
INSERT INTO persoane VALUES (5, 'Popa Nicu', 'M', '3');
INSERT INTO persoane VALUES (6, 'Popa Rely Nicoleta', 'F', '36');

-- Select some values
SELECT * FROM persoane WHERE gender = 'M';