03_insert_data.sql

/* 
===========================================================================================
Script Name: Script2_3_Insert
Authors: Dimitrios Chasanidis, Konstantina Tzeikou, Panteleimon Skenderoglou, Thomas Kanoutas 
Date: 22-01-2025
Description: 
    This script contains INSERT statements to populate sample data into the following tables:
    - OWNERS: Data regarding property owners.
    - APARTMENTS: Information about apartments associated with owners.
    - TENANTS: Tenant details and the number of tenants per unit.
    - RENTALS: Rental agreements between tenants and apartments.
    - REVIEWS: Reviews given by tenants about their rental apartments.

===========================================================================================
Tables Affected:
    1) APARTMENTS
    2) OWNERS
    3) RENTALS
    4) REVIEWS
    5) TENANTS
    
===========================================================================================
Notes:
    1) The data inserted is purely sample data and has been selected in a way to serve better
       all the queries performed in Script2_5_Query
    2) On this Script, two different methodologies for inserting data have been presented.
       However, one of them should be followed to populate the tables with data.
===========================================================================================
*/

-- METHODOLOGY 1: Insert data with the use of columns list

--Sample data for OWNERS Table
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)
VALUES(1, 'GRIGORIOS', 'VASILEIOU', 'GRIGORIOS.VASILEIOUR@EMAIL.COM', 'ATHENS', TO_DATE('02-JAN-1970','DD-MON-YYYY'), 123456789, '45 ELEPTHERIOU VENIZELOU ST.');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)
VALUES(2, 'MARIA', 'PAPADOPOULOU', 'MARIA.PAPADOPOULOU@EMAIL.COM', 'THESSALONIKI', TO_DATE('05-DEC-1990', 'DD-MON-YYYY'), 987654321, '13 ARISTOTELOUS ST.');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)
VALUES(3, 'DIMITRIS', 'MYLONAS', 'DIMITRIS.MYLONAS@EMAIL.COM', 'KASTORIA', TO_DATE('27-APR-1995','DD-MON-YYYY'), 456789123, '19 AGIOU DIMITRIOU ST');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)
VALUES(4, 'SOPHIA', 'KAPETANEA', 'SOPHIA.KAPETANEA@EMAIL.COM', 'THESSALONIKI', TO_DATE('27-JUN-2000', 'DD-MON-YYYY'), 789123456, '30 NIKIS ST.');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)	
VALUES(5, 'GEORGIOS', 'THEOFANIDIS', 'GEORGIOS.THEOFANIDIS@EMAIL.COM', 'ATHENS', TO_DATE('02-FEB-1988','DD-MON-YYYY'), 654321987, '40 EGNATIAS ST.');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)	
VALUES(6, 'DIMITRA', 'MICHAILIDOU', 'DIMITRA.MICHAILIDOU@EMAIL.COM', 'IOANNINA', TO_DATE('04-MAY-1975','DD-MON-YYYY'), 321548765, '10 AGIOU GEORGIOU ST.');
INSERT INTO owners (O_ID, O_NAME, O_SURNAME, EMAIL, CITY, D_OF_BIRTH, TIN, O_ADR)	
VALUES(7, 'VASILIS', 'KARAGEORGIOU', 'VASILIS.KARAGEORGIOU@EMAIL.COM', 'THESSALONIKI', TO_DATE('29-JAN-1984', 'DD-MON-YYYY'), 112345678, '18 IPPOKRATOUS ST.');

--Sample data for APARTMENTS table
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(1, 2, 'AGIAS SOFIAS STREET', 4, 54623, 'THESSALONIKI', 1, 25);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(2, 1, 'SAINT GEORGE STREET', 36, 11471, 'ATHENS', 4, 15);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(3, 3, 'VENIZELOU STREET', 32, 52100, 'KASTORIA', 2, 24);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(4, 2, 'AISXYLOY STREET', 7, 54634, 'THESSALONIKI', 1, 18);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(5, 1, '3RD SEPTEMVRIOU STREET', 99, 10434, 'ATHENS', 6, 17.5);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(6, 5, 'MEGALOU ALEXANDROU STREET', 63, 45333, 'IOANNINA', 3, 8.60);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(7, 2, 'ACHIROPIITOU STREET', 5, 54635, 'THESSALONIKI', 4, 16.8);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(8, 6, 'VENIZELOU STREET', 19, 65403, 'KAVALA', 1, 10);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(9, 7, 'AIAKIDON STREET', 24, 45500, 'IOANNINA', 2, 12.6);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(10, 5, 'IASONOS STREET', 56, 10442, 'ATHENS', 5, 21);
INSERT INTO apartments (APT_ID, O_ID, STREET, STR_NUMBER, POSTAL_CODE, CITY, FLOOR, PRICE)
VALUES(11, 6, 'ARISTOTELOUS STREET', 22, 55521, 'THESSALONIKI', 3, 32);

--Sample data for TENANTS table
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)
VALUES(1, 'ANDREAS', 'XENAKIS', 'M', 'ANDREAS.XENAKIS@EMAIL.COM', TO_DATE('04-JUL-2000', 'DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(2, 'JAMES', 'ANDERSON', 'M', 'JAMES.ANDERSON@EMAIL.COM', TO_DATE('29-AUG-1987','DD-MON-YYYY'), 'ENGLAND', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(3, 'ELENI', 'KARAPETROU', 'F', 'ELENI.KARAPETROU@EMAIL.COM', TO_DATE('04-DEC-1999', 'DD-MON-YYYY'), 'GREECE', 3);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(4, 'EMILY', 'ANDREWS', 'F', 'EMILY.JOHNSON@EMAIL.COM', TO_DATE('17-FEB-1996', 'DD-MON-YYYY'), 'FRANCE', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(5, 'JACK','TAYLOR', 'M', 'JACK.TAYLOR@EMAIL.COM', TO_DATE('24-JUL-1998', 'DD-MON-YYYY'), 'AMERICA', 2);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(6, 'CHRISTOS', 'MAKRIS', 'M', 'CHRISTOS.MAKRIS@EMAIL.COM', TO_DATE('09-JAN-1988','DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(7, 'GRACE', 'HARRIS', 'F', 'GRACE.HARRIS@EMAIL.COM', TO_DATE('18-NOV-1995','DD-MON-YYYY'), 'NETHERLANDS', 4);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(8, 'IOANNA', 'GALANI', 'F', 'IOANNA.GALANI@EMAIL.COM', TO_DATE('03-OCT-2001', 'DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(9, 'DIMITRIS', 'STAVRAKIS', 'M', 'DIMITRIS.STAVRAKIS@EMAIL.COM', TO_DATE('06-SEP-1997', 'DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(10, 'WILLIAM', 'BROWN', 'M', 'WILLIAM.BROWN@EMAIL.COM', TO_DATE('27-JUN-1987','DD-MON-YYYY'), 'IRELAND', 2);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(11, 'CHARLOTTE', 'WILSON', 'F', 'CHARLOTTE.WILSON@EMAIL.COM', TO_DATE('13-SEP-1988', 'DD-MON-YYYY'), 'GERMANY', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(12, 'ROWAN', 'TAYLOR', 'O', 'ROWAN.TAYLOR@EMAIL.COM', TO_DATE('23-JAN-2002', 'DD-MON-YYYY'), 'GERMANY', 4);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(13, 'ALEXANDROS', 'PAPADOPOULOS', 'M', 'ALEX.PAPADOPOULOS@EMAIL.COM', TO_DATE('20-MAY-1977', 'DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(14, 'NIKOLAS', 'PETROU', 'M', 'NICK.PETROU@EMAIL.COM', TO_DATE('08-JUN-1991','DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants (T_ID, T_NAME, T_SURNAME, T_GENDER, EMAIL, D_OF_BIRTH, COUNTRY, N_OF_TENANTS)	
VALUES(15, 'OLIVIA', 'WILLIAMS', 'F', 'OLIVIA.WILLIAMS@EMAIL.COM', TO_DATE('30-DEC-1992', 'DD-MON-YYYY'), 'ENGLAND', 1);

--Sample data for RENTALS table
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)
VALUES(1, 1, 12, TO_DATE('01-JUN-2023', 'DD-MON-YYYY'), TO_DATE('01-JUN-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(2, 2, 1, TO_DATE('01-AUG-2022', 'DD-MON-YYYY'), TO_DATE('01-SEP-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(3, 3, 4, TO_DATE('05-FEB-2021', 'DD-MON-YYYY'), TO_DATE('05-JAN-2022', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(4, 3, 5, TO_DATE('07-FEB-2022', 'DD-MON-YYYY'), TO_DATE('23-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(5, 4, 14, TO_DATE('29-APR-2022', 'DD-MON-YYYY'), TO_DATE('03-FEB-2023', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(6, 5, 11, TO_DATE('08-OCT-2020', 'DD-MON-YYYY'), TO_DATE('06-JUN-2021', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(7, 6, 15, TO_DATE('09-APR-2021', 'DD-MON-YYYY'), TO_DATE('08-APR-2022', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(8, 7, 6, TO_DATE('15-AUG-2022', 'DD-MON-YYYY'), TO_DATE('15-AUG-2023', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(9, 4, 8, TO_DATE('27-JUL-2023', 'DD-MON-YYYY'), TO_DATE('27-AUG-2023', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(10, 9, 11, TO_DATE('09-JUN-2020', 'DD-MON-YYYY'), TO_DATE('11-NOV-2020', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(11, 10, 3, TO_DATE('24-NOV-2023', 'DD-MON-YYYY'), TO_DATE('24-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(12, 7, 7, TO_DATE('01-SEP-2024', 'DD-MON-YYYY'), TO_DATE('15-NOV-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(13, 5, 2, TO_DATE('24-JUL-2021', 'DD-MON-YYYY'), TO_DATE('24-JUL-2023', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(14, 9, 9, TO_DATE('28-OCT-2023', 'DD-MON-YYYY'), TO_DATE('28-SEP-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(15, 3, 2, TO_DATE('20-JAN-2020', 'DD-MON-YYYY'), TO_DATE('21-SEP-2020', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(16, 6, 4, TO_DATE('15-AUG-2024', 'DD-MON-YYYY'), TO_DATE('15-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals (RENTAL_ID, APT_ID, T_ID, START_DATE, END_DATE)	
VALUES(17, 4, 11, TO_DATE('01-FEB-2024', 'DD-MON-YYYY'), TO_DATE('14-SEP-2024', 'DD-MON-YYYY'));

--Sample data for REVIEWS table
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)
VALUES(1, 1, 12, TO_DATE('02-JUN-2024', 'DD-MON-YYYY'), 4, 'VERY CLEAN');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(2, 2, 1, TO_DATE('03-SEP-2024', 'DD-MON-YYYY'), 3, 'GREAT LOCATION, CLEAN SPACE, BUT THE NOISE FROM THE STREET CAN BE A BIT MUCH AT NIGHT.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(3, 3, 4, TO_DATE('08-JAN-2022', 'DD-MON-YYYY'), 5, 'CLEAN AND WELL-MAINTAINED. PERFECT FOR A SMALL FAMILY.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(4, 4, 14, TO_DATE('04-FEB-2023', 'DD-MON-YYYY'), 2, 'DECENT SPACE FOR THE PRICE, BUT THE HEATING SYSTEM ISN’T VERY RELIABLE.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(5, 5, 11, TO_DATE('08-JUL-2020', 'DD-MON-YYYY'), 4, 'CLOSE TO PUBLIC TRANSPORT AND PARKS. GREAT FOR COMMUTERS.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(6, 6, 15, TO_DATE('19-APR-2022', 'DD-MON-YYYY'), 0, 'THE HEATING DOESN’T WORK PROPERLY, AND THE APARTMENT IS FREEZING IN WINTER.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(7, 7, 6, TO_DATE('20-AUG-2023', 'DD-MON-YYYY'), 1, 'THE RENT KEEPS GOING UP EVERY YEAR, BUT NOTHING IS EVER FIXED OR UPGRADED.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(8, 8, 8, TO_DATE('30-SEP-2023', 'DD-MON-YYYY'), 4, 'MODERN APARTMENT WITH NICE FINISHES, BUT THE BUILDING LACKS AN ELEVATOR.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(9, 9, 11, TO_DATE('12-NOV-2020', 'DD-MON-YYYY'), 5, 'WELL-LOCATED AND CLOSE TO MY WORKPLACE. VERY CONVENIENT.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(10, 10, 3, TO_DATE('30-DEC-2024', 'DD-MON-YYYY'), 3, 'GOOD VALUE FOR MONEY, BUT THE BATHROOM NEEDS UPDATING.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(11, 3, 5, TO_DATE('24-DEC-2024', 'DD-MON-YYYY'), 5, 'SPACIOUS BEDROOMS AND PLENTY OF STORAGE. A GREAT RENTAL OPTION.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(12, 4, 13, TO_DATE('03-APR-2023', 'DD-MON-YYYY'), 3, 'GREAT LOCATION, BUT THE PLUMBING SYSTEM REQUIRES FREQUENT REPAIRS.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(13, 7, 7, TO_DATE('17-NOV-2024', 'DD-MON-YYYY'), 3, 'THE APARTMENT IS BRIGHT AND SPACIOUS, BUT THE BUILDING IS A BIT OLD.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(14, 8, 10, TO_DATE('05-OCT-2024', 'DD-MON-YYYY'), 2, 'THE APARTMENT IS WELL-LIT AND AIRY, BUT THE RENT IS A BIT HIGH FOR THE SIZE.');
INSERT INTO reviews (REVIEW_ID, APT_ID, T_ID, REVIEW_DATE, STAR_RATING, REVIEW_TXT)	
VALUES(15, 5, 2, TO_DATE('29-SEP-2024', 'DD-MON-YYYY'), 2, 'THE NEIGHBORS ARE LOUD, AND THE WALLS ARE SO THIN THAT IT’S IMPOSSIBLE TO SLEEP.');


-- METHODOLOGY 2: Insert data without the use of columns list
-- At this point, we would like to mention that Metholody 1 is preferred
-- for better clarity and code explainability.

-- Sample data for OWNERS Table
INSERT INTO owners 
VALUES(1, 'GRIGORIOS', 'VASILEIOU', 'GRIGORIOS.VASILEIOUR@EMAIL.COM', 'ATHENS', TO_DATE('02-JAN-1970','DD-MON-YYYY'), 123456789, '45 ELEPTHERIOU VENIZELOU ST.');
INSERT INTO owners 
VALUES(2, 'MARIA', 'PAPADOPOULOU', 'MARIA.PAPADOPOULOU@EMAIL.COM', 'THESSALONIKI', TO_DATE('05-DEC-1990', 'DD-MON-YYYY'), 987654321, '13 ARISTOTELOUS ST.');
INSERT INTO owners 
VALUES(3, 'DIMITRIS', 'MYLONAS', 'DIMITRIS.MYLONAS@EMAIL.COM', 'KASTORIA', TO_DATE('27-APR-1995','DD-MON-YYYY'), 456789123, '19 AGIOU DIMITRIOU ST');
INSERT INTO owners 
VALUES(4, 'SOPHIA', 'KAPETANEA', 'SOPHIA.KAPETANEA@EMAIL.COM', 'THESSALONIKI', TO_DATE('27-JUN-2000', 'DD-MON-YYYY'), 789123456, '30 NIKIS ST.');
INSERT INTO owners 
VALUES(5, 'GEORGIOS', 'THEOFANIDIS', 'GEORGIOS.THEOFANIDIS@EMAIL.COM', 'ATHENS', TO_DATE('02-FEB-1988','DD-MON-YYYY'), 654321987, '40 EGNATIAS ST.');
INSERT INTO owners 
VALUES(6, 'DIMITRA', 'MICHAILIDOU', 'DIMITRA.MICHAILIDOU@EMAIL.COM', 'IOANNINA', TO_DATE('04-MAY-1975','DD-MON-YYYY'), 321548765, '10 AGIOU GEORGIOU ST.');
INSERT INTO owners 
VALUES(7, 'VASILIS', 'KARAGEORGIOU', 'VASILIS.KARAGEORGIOU@EMAIL.COM', 'THESSALONIKI', TO_DATE('29-JAN-1984', 'DD-MON-YYYY'), 112345678, '18 IPPOKRATOUS ST.');

-- Sample data for APARTMENTS Table
INSERT INTO apartments 
VALUES(1, 2, 'AGIAS SOFIAS STREET', 4, 54623, 'THESSALONIKI', 1, 25);
INSERT INTO apartments 
VALUES(2, 1, 'SAINT GEORGE STREET', 36, 11471, 'ATHENS', 4, 15);
INSERT INTO apartments 
VALUES(3, 3, 'VENIZELOU STREET', 32, 52100, 'KASTORIA', 2, 24);
INSERT INTO apartments 
VALUES(4, 2, 'AISXYLOY STREET', 7, 54634, 'THESSALONIKI', 1, 18);
INSERT INTO apartments 
VALUES(5, 1, '3RD SEPTEMVRIOU STREET', 99, 10434, 'ATHENS', 6, 17.5);
INSERT INTO apartments 
VALUES(6, 5, 'MEGALOU ALEXANDROU STREET', 63, 45333, 'IOANNINA', 3, 8.60);
INSERT INTO apartments 
VALUES(7, 2, 'ACHIROPIITOU STREET', 5, 54635, 'THESSALONIKI', 4, 16.8);
INSERT INTO apartments 
VALUES(8, 6, 'VENIZELOU STREET', 19, 65403, 'KAVALA', 1, 10);
INSERT INTO apartments 
VALUES(9, 7, 'AIAKIDON STREET', 24, 45500, 'IOANNINA', 2, 12.6);
INSERT INTO apartments 
VALUES(10, 5, 'IASONOS STREET', 56, 10442, 'ATHENS', 5, 21);
INSERT INTO apartments 
VALUES(11, 6, 'ARISTOTELOUS STREET', 22, 55521, 'THESSALONIKI', 3, 32);

-- Sample data for TENANTS Table
INSERT INTO tenants 
VALUES(1, 'ANDREAS', 'XENAKIS', 'M', 'ANDREAS.XENAKIS@EMAIL.COM', TO_DATE('04-JUL-2000', 'DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants 
VALUES(2, 'JAMES', 'ANDERSON', 'M', 'JAMES.ANDERSON@EMAIL.COM', TO_DATE('29-AUG-1987','DD-MON-YYYY'), 'ENGLAND', 1);
INSERT INTO tenants 
VALUES(3, 'ELENI', 'KARAPETROU', 'F', 'ELENI.KARAPETROU@EMAIL.COM', TO_DATE('04-DEC-1999', 'DD-MON-YYYY'), 'GREECE', 3);
INSERT INTO tenants 
VALUES(4, 'EMILY', 'ANDREWS', 'F', 'EMILY.JOHNSON@EMAIL.COM', TO_DATE('17-FEB-1996', 'DD-MON-YYYY'), 'FRANCE', 1);
INSERT INTO tenants 
VALUES(5, 'JACK','TAYLOR', 'M', 'JACK.TAYLOR@EMAIL.COM', TO_DATE('24-JUL-1998', 'DD-MON-YYYY'), 'AMERICA', 2);
INSERT INTO tenants 
VALUES(6, 'CHRISTOS', 'MAKRIS', 'M', 'CHRISTOS.MAKRIS@EMAIL.COM', TO_DATE('09-JAN-1988','DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants 
VALUES(7, 'GRACE', 'HARRIS', 'F', 'GRACE.HARRIS@EMAIL.COM', TO_DATE('18-NOV-1995','DD-MON-YYYY'), 'NETHERLANDS', 4);
INSERT INTO tenants 
VALUES(8, 'IOANNA', 'GALANI', 'F', 'IOANNA.GALANI@EMAIL.COM', TO_DATE('03-OCT-2001', 'DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants 
VALUES(9, 'DIMITRIS', 'STAVRAKIS', 'M', 'DIMITRIS.STAVRAKIS@EMAIL.COM', TO_DATE('06-SEP-1997', 'DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants 
VALUES(10, 'WILLIAM', 'BROWN', 'M', 'WILLIAM.BROWN@EMAIL.COM', TO_DATE('27-JUN-1987','DD-MON-YYYY'), 'IRELAND', 2);
INSERT INTO tenants 
VALUES(11, 'CHARLOTTE', 'WILSON', 'F', 'CHARLOTTE.WILSON@EMAIL.COM', TO_DATE('13-SEP-1988', 'DD-MON-YYYY'), 'GERMANY', 1);
INSERT INTO tenants 
VALUES(12, 'ROWAN', 'TAYLOR', 'O', 'ROWAN.TAYLOR@EMAIL.COM', TO_DATE('23-JAN-2002', 'DD-MON-YYYY'), 'GERMANY', 4);
INSERT INTO tenants 
VALUES(13, 'ALEXANDROS', 'PAPADOPOULOS', 'M', 'ALEX.PAPADOPOULOS@EMAIL.COM', TO_DATE('20-MAY-1977', 'DD-MON-YYYY'), 'GREECE', 1);
INSERT INTO tenants 
VALUES(14, 'NIKOLAS', 'PETROU', 'M', 'NICK.PETROU@EMAIL.COM', TO_DATE('08-JUN-1991','DD-MON-YYYY'), 'GREECE', 2);
INSERT INTO tenants 
VALUES(15, 'OLIVIA', 'WILLIAMS', 'F', 'OLIVIA.WILLIAMS@EMAIL.COM', TO_DATE('30-DEC-1992', 'DD-MON-YYYY'), 'ENGLAND', 1);

-- Sample data for RENTALS Table
INSERT INTO rentals
VALUES(1, 1, 12, TO_DATE('01-JUN-2023', 'DD-MON-YYYY'), TO_DATE('01-JUN-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(2, 2, 1, TO_DATE('01-AUG-2022', 'DD-MON-YYYY'), TO_DATE('01-SEP-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(3, 3, 4, TO_DATE('05-FEB-2021', 'DD-MON-YYYY'), TO_DATE('05-JAN-2022', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(4, 3, 5, TO_DATE('07-FEB-2022', 'DD-MON-YYYY'), TO_DATE('23-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(5, 4, 14, TO_DATE('29-APR-2022', 'DD-MON-YYYY'), TO_DATE('03-FEB-2023', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(6, 5, 11, TO_DATE('08-OCT-2020', 'DD-MON-YYYY'), TO_DATE('06-JUN-2021', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(7, 6, 15, TO_DATE('09-APR-2021', 'DD-MON-YYYY'), TO_DATE('08-APR-2022', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(8, 7, 6, TO_DATE('15-AUG-2022', 'DD-MON-YYYY'), TO_DATE('15-AUG-2023', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(9, 4, 8, TO_DATE('27-JUL-2023', 'DD-MON-YYYY'), TO_DATE('27-AUG-2023', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(10, 9, 11, TO_DATE('09-JUN-2020', 'DD-MON-YYYY'), TO_DATE('11-NOV-2020', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(11, 10, 3, TO_DATE('24-NOV-2023', 'DD-MON-YYYY'), TO_DATE('24-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(12, 7, 7, TO_DATE('01-SEP-2024', 'DD-MON-YYYY'), TO_DATE('15-NOV-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(13, 5, 2, TO_DATE('24-JUL-2021', 'DD-MON-YYYY'), TO_DATE('24-JUL-2023', 'DD-MON-YYYY'));
INSERT INTO rentals 
VALUES(14, 9, 9, TO_DATE('28-OCT-2023', 'DD-MON-YYYY'), TO_DATE('28-SEP-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(15, 3, 2, TO_DATE('20-JAN-2020', 'DD-MON-YYYY'), TO_DATE('21-SEP-2020', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(16, 6, 4, TO_DATE('15-AUG-2024', 'DD-MON-YYYY'), TO_DATE('15-DEC-2024', 'DD-MON-YYYY'));
INSERT INTO rentals
VALUES(17, 4, 11, TO_DATE('01-FEB-2024', 'DD-MON-YYYY'), TO_DATE('14-SEP-2024', 'DD-MON-YYYY'));

-- Sample data for REVIEWS Table
INSERT INTO reviews 
VALUES(1, 1, 12, TO_DATE('02-JUN-2024', 'DD-MON-YYYY'), 4, 'VERY CLEAN');
INSERT INTO reviews
VALUES(2, 2, 1, TO_DATE('03-SEP-2024', 'DD-MON-YYYY'), 3, 'GREAT LOCATION, CLEAN SPACE, BUT THE NOISE FROM THE STREET CAN BE A BIT MUCH AT NIGHT.');
INSERT INTO reviews
VALUES(3, 3, 4, TO_DATE('08-JAN-2022', 'DD-MON-YYYY'), 5, 'CLEAN AND WELL-MAINTAINED. PERFECT FOR A SMALL FAMILY.');
INSERT INTO reviews
VALUES(4, 4, 14, TO_DATE('04-FEB-2023', 'DD-MON-YYYY'), 2, 'DECENT SPACE FOR THE PRICE, BUT THE HEATING SYSTEM ISN’T VERY RELIABLE.');
INSERT INTO reviews
VALUES(5, 5, 11, TO_DATE('08-JUL-2020', 'DD-MON-YYYY'), 4, 'CLOSE TO PUBLIC TRANSPORT AND PARKS. GREAT FOR COMMUTERS.');
INSERT INTO reviews
VALUES(6, 6, 15, TO_DATE('19-APR-2022', 'DD-MON-YYYY'), 0, 'THE HEATING DOESN’T WORK PROPERLY, AND THE APARTMENT IS FREEZING IN WINTER.');
INSERT INTO reviews
VALUES(7, 7, 6, TO_DATE('20-AUG-2023', 'DD-MON-YYYY'), 1, 'THE RENT KEEPS GOING UP EVERY YEAR, BUT NOTHING IS EVER FIXED OR UPGRADED.');
INSERT INTO reviews
VALUES(8, 8, 8, TO_DATE('30-SEP-2023', 'DD-MON-YYYY'), 4, 'MODERN APARTMENT WITH NICE FINISHES, BUT THE BUILDING LACKS AN ELEVATOR.');
INSERT INTO reviews
VALUES(9, 9, 11, TO_DATE('12-NOV-2020', 'DD-MON-YYYY'), 5, 'WELL-LOCATED AND CLOSE TO MY WORKPLACE. VERY CONVENIENT.');
INSERT INTO reviews
VALUES(10, 10, 3, TO_DATE('30-DEC-2024', 'DD-MON-YYYY'), 3, 'GOOD VALUE FOR MONEY, BUT THE BATHROOM NEEDS UPDATING.');
INSERT INTO reviews
VALUES(11, 3, 5, TO_DATE('24-DEC-2024', 'DD-MON-YYYY'), 5, 'SPACIOUS BEDROOMS AND PLENTY OF STORAGE. A GREAT RENTAL OPTION.');
INSERT INTO reviews
VALUES(12, 4, 13, TO_DATE('03-APR-2023', 'DD-MON-YYYY'), 3, 'GREAT LOCATION, BUT THE PLUMBING SYSTEM REQUIRES FREQUENT REPAIRS.');
INSERT INTO reviews
VALUES(13, 7, 7, TO_DATE('17-NOV-2024', 'DD-MON-YYYY'), 3, 'THE APARTMENT IS BRIGHT AND SPACIOUS, BUT THE BUILDING IS A BIT OLD.');
INSERT INTO reviews
VALUES(14, 8, 10, TO_DATE('05-OCT-2024', 'DD-MON-YYYY'), 2, 'THE APARTMENT IS WELL-LIT AND AIRY, BUT THE RENT IS A BIT HIGH FOR THE SIZE.');
INSERT INTO reviews
VALUES(15, 5, 2, TO_DATE('29-SEP-2024', 'DD-MON-YYYY'), 2, 'THE NEIGHBORS ARE LOUD, AND THE WALLS ARE SO THIN THAT IT’S IMPOSSIBLE TO SLEEP.');