CREATE TABLE CLIENT (
    ClientID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
    ClientName VARCHAR(100), 
    Age INTEGER, 
    PostCode VARCHAR(4)
);


INSERT INTO CLIENT (ClientName, Age, PostCode) VALUES
('John Dlamini', 15, '0140'),
('Leo Sithole', 22, '1240'),
('Steve Jacobs', 21, '0125'),
('Pat Khumalo', 23, '1251'),
('Sipho Nkosi', 14, '1240'),
('Musi Mahlangu', 38, '0120'),
('Sibongile Ngcobo', 25, '1240'),
('Lindewe Khoza', 18, '1500'),
('Johannes Botha', 33, '1600'),
('Bongani Radebe', 32, '1500'),
('Caleb Pillay', 31, '1600'),
('Anna Mthembu', 45, '0180'),
('Thabo Baloyi', 37, '0158'),
('Mpho Sithole', 14, '1250'),
('Peter Zwane', 30, '1240'),
('Maria Nkosi', 21, '0152'),
('Samuel Naidoo', 16, '1600'),
('Patricia Williams', 17, '0120'),
('Joseph Mkhize', 31, '0140'),
('Zenele Ndlovu', 42, '0140'),
('Daniel Dlamini', 45, '1500'),
('Jabu Chauke', 35, '1600'),
('Willem du Plessis', 23, '1600'),
('Jan Venter', 31, '1250'),
('Linda Gumede', 13, '0180'),
('Zandile Methembu', 22, '1600'),
('Robert Maseko', 16, '1250'),
('Cynthia Fourie', 18, '1500'),
('Nomsa Baloyi', 14, '1240'),
('Bongiwe Mokoena', 25, '0160'),
('Al Naidoo', 23, '0127'),
('Phindile Ntuli', 15, '0180'),
('Bianca Abrahams', 22, '0160'),
('Freddy Chetty', 17, '0160'),
('Moses Sibisi', 31, '0121'),
('Vusi Khumalo', 13, '1240'),
('Hendrick van Zyl', 27, '0180'),
('Lucky Shabangu', 16, '0123');



CREATE TABLE COUNSELLOR (
    CounsellorID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
    CounsellorName VARCHAR(100), 
    Rate DOUBLE
);


INSERT INTO COUNSELLOR (CounsellorName, Rate) VALUES
('Vernon Booysen', 150),
('Matthew Kunene', 180),
('Heather Modise', 150),
('Siyanda Mabuza', 120),
('Joshua Hendricks', 120),
('Thabo Matlala', 150),
('Michael Mabasa', 180),
('Sibu Ndou', 140),
('Xolani Nzimande', 150),
('Linda September', 120),
('Patrick Ntuli', 0);



CREATE TABLE APPOINTMENT (
  AppointmentID INTEGER NOT NULL primary key
        generated always as identity
        (start with 1, increment by 1), 
  ClientID INTEGER,
  CounsellorID INTEGER,
  AppointmentDate DATE,
  Location VARCHAR(25)
);


INSERT INTO APPOINTMENT (ClientID, CounsellorID, AppointmentDate, Location) VALUES
(1,2,'2020-10-14','Bergsig'),
(3,2,'2020-10-14','Bergsig'),
(11,2,'2020-10-14','Bergsig'),
(34,2,'2020-10-14','Bergsig'),
(2,5,'2020-10-14','Greenside'),
(5,5,'2020-10-14','Greenside'),
(24,5,'2020-10-14','Greenside'),
(29,5,'2020-10-14','Greenside'),
(36,5,'2020-10-14','Greenside'),
(19,1,'2020-10-15','Bergsig'),
(37,1,'2020-10-15','Bergsig'),
(38,1,'2020-10-15','Bergsig'),
(12,2,'2020-10-15','Bergsig'),
(18,2,'2020-10-15','Bergsig'),
(34,2,'2020-10-15','Bergsig'),
(4,7,'2020-10-15','Greenside'),
(15,7,'2020-10-15','Greenside'),
(27,7,'2020-10-15','Greenside'),
(20,2,'2020-10-16','Bergsig'),
(33,2,'2020-10-16','Bergsig'),
(35,2,'2020-10-16','Bergsig'),
(8,4,'2020-10-16','Panorama'),
(2,5,'2020-10-16','Greenside'),
(25,2,'2020-10-19','Bergsig'),
(30,2,'2020-10-19','Bergsig'),
(1,2,'2020-10-20','Bergsig'),
(12,2,'2020-10-20','Bergsig'),
(18,2,'2020-10-20','Bergsig'),
(8,4,'2020-10-20','Panorama'),
(17,4,'2020-10-20','Panorama'),
(23,4,'2020-10-20','Panorama'),
(24,4,'2020-10-20','Panorama'),
(24,5,'2020-10-20','Greenside'),
(29,5,'2020-10-20','Greenside'),
(14,6,'2020-10-20','Greenside'),
(4,7,'2020-10-20','Greenside'),
(1,1,'2020-10-21','Bergsig'),
(3,1,'2020-10-21','Bergsig'),
(6,1,'2020-10-21','Bergsig'),
(12,1,'2020-10-21','Bergsig'),
(19,1,'2020-10-21','Bergsig'),
(9,8,'2020-10-22','Panorama'),
(19,1,'2020-10-23','Bergsig'),
(25,2,'2020-10-23','Bergsig'),
(30,2,'2020-10-23','Bergsig'),
(8,4,'2020-10-23','Panorama'),
(22,4,'2020-10-23','Panorama'),
(9,8,'2020-10-23','Panorama'),
(21,8,'2020-10-23','Panorama'),
(28,8,'2020-10-23','Panorama'),
(18,2,'2020-10-26','Bergsig'),
(30,2,'2020-10-26','Bergsig'),
(8,4,'2020-10-26','Panorama'),
(17,4,'2020-10-26','Panorama'),
(2,5,'2020-10-26','Greenside'),
(24,5,'2020-10-26','Greenside'),
(29,5,'2020-10-26','Greenside'),
(4,7,'2020-10-26','Greenside'),
(15,7,'2020-10-26','Greenside'),
(27,7,'2020-10-26','Greenside'),
(10,10,'2020-10-26','Panorama'),
(22,10,'2020-10-26','Panorama'),
(6,1,'2020-10-27','Bergsig'),
(12,1,'2020-10-27','Bergsig'),
(19,1,'2020-10-27','Bergsig'),
(32,1,'2020-10-27','Bergsig'),
(1,3,'2020-10-27','Bergsig'),
(31,3,'2020-10-27','Bergsig'),
(14,6,'2020-10-27','Greenside'),
(29,6,'2020-10-27','Greenside'),
(4,7,'2020-10-27','Greenside'),
(15,7,'2020-10-27','Greenside'),
(21,8,'2020-10-27','Panorama'),
(10,10,'2020-10-27','Panorama'),
(22,10,'2020-10-27','Panorama'),
(31,3,'2020-10-28','Bergsig');