Database Schema for Regex tutorial

regex_tutorial.sql

CREATE SCHEMA myschooldb;
SET search_path = myschooldb;
  
DROP TABLE IF EXISTS students;
CREATE TABLE students(
	id serial PRIMARY KEY,
	first_name VARCHAR(100) NOT NULL,
	last_name VARCHAR(100) NOT NULL,
	middle_name VARCHAR(100) NULL,
	gender VARCHAR(1) NOT NULL,
	date_of_birth DATE  NOT NULL
);

INSERT INTO students
  ("first_name", "last_name", "middle_name", "gender", "date_of_birth")
VALUES
  ('dike', 'Chijioke', 'Peter', 'M', '2013-06-11'),
  ('Busayo', 'Olabode', 'Timothy', 'M', '2012-05-12'),
  ('Pete', 'Asika', 'Chinedu', 'M', '2012-10-30'),
  ('Reuben', 'Abatti', 'Olayemi', 'M', '2013-02-11'),
  ('Mark', 'Goldberg', 'Scotfield', 'M', '2012-03-02'),
  ('Kunle', 'Ayoola', 'Young', 'M', '2012-05-20'),
  ('Ikenna', 'Azuka', 'Benjamin', 'M', '2012-07-31'),
  ('Paul', 'Fisayo', NULL, 'M', '2012-06-12'), 
  ('Musa', 'Audu', 'Raheem', 'M', '2012-05-28'),
  ('Samuel', 'Osaro', 'Osinhmen', 'M', '2012-11-12'),
  ('Kalu', 'Sunday', 'Chikason', 'M', '2012-08-12'),
  ('David', 'Oyedapo', 'Olamide', 'M', '2012-06-25'),
  ('Musa', 'Mohammed', 'Buhari', 'M', '2012-09-13'),
  ('Felicia', 'Olabode', 'Kemisola', 'F', '2012-04-02'),
  ('Chinwe', 'Dike', 'Cynthia', 'F', '2012-03-01'),
  ('Paul', 'Ighodalo', 'Efe', 'M', '2012-08-31'),
  ('Ayo', 'Rufai', 'Darasimi', 'F', '2013-12-22'),
  ('Bravo', 'Olabode', 'Timothy', 'F', '2011-07-30'),
  ('Lilian', 'Okpe', 'Uche', 'M', '2011-09-22'),
  ('Mercy', 'Chinwo', NULL, 'M', '2012-06-12'),
  ('Tobi', 'Sowore', 'Omoyele', 'M', '2011-06-30'),
  ('Bose', 'Akinyemi', 'Tina', 'F', '2011-08-22'),
  ('Bayo', 'Adeniran', 'Timothy', 'M', '2012-04-12'),
  ('Tobechukwu', 'Irem', 'Samuel', 'M','2011-07-30'),
  ('Goodluck', 'Jonathan', 'Ebele', 'M', '2011-05-02'),
  ('Atiku', 'Abubakar', 'Salau', 'M', '2012-04-12'),
  ('Boyo', 'Sukunmi', 'Gabriel', 'M', '2010-11-12'),
  ('Opeyemi', 'Tinubu', 'Mary', 'F', '2011-12-12'),
  ('Ferdinad', 'Ovie', 'Tega', 'M', '2010-05-31'),
  ('Uloma', 'Kachi', 'Sophia', 'F', '2011-04-30'),
  ('Boniface', 'Okonkwo', 'Daniel', 'M', '2009-12-31'),
  ('Samuel', 'Egot', 'Ufon', 'M', '2011-08-12'),
  ('Mary', 'Chima', 'Eberechi', 'F', '2010-05-21'),
  ('Bode', 'George', 'Oladipupo', 'M', '2011-05-14'),
  ('Akin', 'Alabi', 'Michael', 'M', '2009-05-12'),
  ('Victor', 'Umeh', 'Ofodile', 'M', '2009-11-23'),
  ('Babatope', 'Olabode', 'Timothy', 'F', '2009-06-21'),
  ('Tonte', 'Briggs', 'Lawson', 'M', '2010-07-12'),
  ('Abigail', 'Chidi', 'Kambili', 'F', '2010-05-11'),
  ('Jeffrey', 'Douglas', 'Yaw', 'M', '2009-01-12'),
  ('Rufai', 'Oseni', 'Abraham', 'M', '2009-05-10'),
  ('Remi', 'Tinubu', 'Elizabeth', 'F', '2009-05-12'),
  ('Morenike', 'Abayomi', 'Sarah', 'F', '2010-09-29'),
  ('Samson', 'Ifegwu', 'Ikenna', 'M', '2009-02-14'),
  ('Solomon', 'Lange', 'Dickson', 'M', '2008-05-12'),
  ('Omo', 'Itoro', 'Jasmine', 'F', '2008-03-13'),
  ('Joy', 'Etuk', 'Itunu', 'F', '2011-12-01'),
  ('Ebun', 'Olabode', 'Timothy', 'M', '2009-04-11'),
  ('Editi', 'Effiong', 'Austin', 'M', '2009-02-12'),
  ('Bucknor', 'Akerele', 'Bidemi', 'F', '2009-03-17'),
  ('Adeonipekun', 'Adeyanju', 'Oluyomi', 'M', '2008-03-07'),
  ('Inibehe', 'Effiong', 'Fidelis', 'M', '2009-04-29'),
  ('Demilade', 'Shola', 'Comfort', 'F', '2009-05-01'),
  ('Babajide', 'Sanwoolu', 'Felix', 'M', '2009-06-22'),
  ('Chioma', 'Nnanna', 'Festus', 'F', '2009-07-15'),
  ('Stella', 'Omobude', 'Maris', 'F', '2009-08-17'),
  ('Bibi', 'Walter', 'Tejiri', 'F', '2009-09-10'),
  ('Immaculate', 'Obinna', 'Yewande', 'F', '2008-10-19'),
  ('Bukayo', 'Saka', 'Tom', 'M', '2007-12-16'),
  ('Hafiz', 'Azeez', 'Shittu', 'M', '2009-11-12'),
  ('Musa', 'Mohammed', 'Buhari', 'M', '2012-09-13'),
  ('Yomi', 'Keyamo', 'Rowland', 'M', '2007-03-09'),
  ('Chisom', 'Chidoka', 'Loveth', 'F', '2007-05-12'),
  ('Victor', 'Tokunbo', 'Dare', 'M', '2007-07-10'),
  ('Grace', 'Mark', 'Simon', 'F', '2007-09-11'),
  ('Tomiwa', 'Freedom', 'Obadiah', 'M', '2006-11-18'),
  ('Tom', 'Preye', 'Asari', 'F', '2007-12-17'),
  ('Whitney', 'Adeniran', 'Morayo', 'F', '2007-06-16'),
  ('Mike', 'Bamiloye', 'Adeola', 'M', '2007-08-15'),
  ('Funsho', 'Opeyemi', 'Moses', 'M', '2007-10-01'),
  ('Bukola', 'Wright', 'Ruth', 'F', '2008-02-13'),
  ('Shola', 'Gbadebo', 'Timothy', 'M', '2005-04-12'),
  ('Boboye', 'Akinola', 'Fisayo', 'M', '2008-03-11'),
  ('Ahmed', 'Mohammed', 'AbdulRahaman', 'M', '2012-09-13'),
  ('Peter', 'Amune', 'Imokhe', 'M', '2006-07-22'),
  ('Wellington', 'Sunday', 'Peacemaker', 'M', '2005-08-12'),
  ('Friday', 'Akpan', 'Enobong', 'M', '2006-10-14'),
  ('Patricia', 'Etta', 'Ekaette', 'F', '2006-12-15'),
  ('Daniella', 'Ikpeazu', 'Chioma', 'F', '2006-11-16'),
  ('Peters', 'Rufai', 'Subomi', 'M', '2005-06-16'),
  ('Hadiza', 'Abdulrazak', 'Halima', 'F', '2005-07-30'),
  ('Morayo', 'Olabode', 'Rachel', 'F', '2006-07-21'),
  ('Adesoye', 'Adeniyi', 'Deborah', 'F', '2006-06-09'),
  ('Emeka', 'Emenike', 'Dickson', 'M', '2006-04-08'),
  ('Kosichukwu', 'Oladipupo', 'Adedayo', 'M', '2006-03-07'),
  ('Edwards', 'Gyang', 'Junior', 'M', '2007-01-11');