INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Wojciech', 'Szczęsny', 'Polkowice', 'Modłowa 5', 666111222, 'wojtek@gmail.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Robert', 'Lewandowski', 'Ławszowa', 'Jaworowa 8', 777112345, 'robercik@interia.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Łukasz', 'Fabiański', 'Świnoujscie', 'Morwowa 8/5', 987234756, 'fabian@op.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Łukasz', 'Piszczek', 'Elbląg', 'Niska 14', 605605605, 'piszczu@gmail.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Kuba', 'Błaszczykowski', 'Kostrzyn', 'Ładna 465', 604604604, 'wojtek@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Artur', 'Borubar', 'Konin', 'Cienka 4', 654123789, 'arturo@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Turbo', 'Grosicki', 'Rzeszów', 'Grupowa 67', 608987456, 'grosik@yahoo.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Luka', 'Mordic', 'Częstochowa', 'Jodłowa 16', 605456999, 'luka@gmail.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Marco', 'Asencio', 'Radom', 'Jodłowa 17', 604777893, 'marco@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Zlatan', 'Ibra', 'Przemyśl', 'Akacjowa 62', 604367256, 'ibra@capgemini.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Gianluigi', 'Buffon', 'Łódź', 'Terenowa 10', 602246603, 'buffon@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Jakub', 'Wawrzyniak', 'Olsztyn', 'Przystankowa 5/6', 602456456, 'goldenball@gmail.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Borys', 'Szyc', 'Giżycko', 'Parkowa 4/5', 604777894, 'borys@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Anna', 'Dmowska', 'Solina', 'Szybowcowa 32', 604367258, 'aniusia@capgemini.com');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Filip', 'Jóźwik', 'Szczecin', 'Konopna 4/20', 602246603, 'jozwik@wp.pl');
INSERT INTO t_client (name, surname, city, street, phone_number, email) VALUES ('Kacper', 'Koprowski', 'Międzyzdroje', 'Morska 43', 602442056, 'loko@gmail.com');

INSERT INTO t_building (description, city, street, has_elevator, number_of_apartments, number_of_floors) VALUES ('najs', 'Wrocław', 'Górnicza 5', true, 6, 3);
INSERT INTO t_building (description, city, street, has_elevator, number_of_apartments, number_of_floors) VALUES ('najs', 'Gorzów', 'Prawnicza 56', false, 6, 3);
INSERT INTO t_building (description, city, street, has_elevator, number_of_apartments, number_of_floors) VALUES ('najs', 'Rawicz', 'Robotnicza 12', true, 6, 3);


INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (85.3, 'Wrocław', 'Górnicza 5/1', 'SOLD', 0, 3, 2, 420000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (64.2, 'Wrocław', 'Górnicza 5/2', 'FREE', 0, 2, 1, 380000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (38.0, 'Wrocław', 'Górnicza 5/3', 'SOLD', 1, 2, 0, 220000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (90.6, 'Wrocław', 'Górnicza 5/4', 'RESERVED', 1, 4, 2, 540000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (76.2, 'Wrocław', 'Górnicza 5/5', 'FREE', 2, 3, 2, 400000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (68.4, 'Wrocław', 'Górnicza 5/6', 'SOLD', 2, 3, 1, 360000, 1);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (78.2, 'Gorzów', 'Prawnicza 56/1', 'FREE', 0, 3, 2, 430000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (74.2, 'Gorzów', 'Prawnicza 56/2', 'SOLD', 0, 3, 2, 410000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (28.2, 'Gorzów', 'Prawnicza 56/3', 'RESERVED', 1, 1, 1, 200000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (46.3, 'Gorzów', 'Prawnicza 56/4', 'FREE', 1, 2, 1, 310000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (52.4, 'Gorzów', 'Prawnicza 56/5', 'SOLD', 2, 3, 1, 360000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (62.4, 'Gorzów', 'Prawnicza 56/6', 'SOLD', 2, 3, 2, 400000, 2);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (92.3, 'Rawicz', 'Robotnicza 12/1', 'RESERVED', 0, 4, 3, 600000, 3);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (80.4, 'Rawicz', 'Robotnicza 12/2', 'SOLD', 0, 4, 2, 500000, 3);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (65.3, 'Rawicz', 'Robotnicza 12/3', 'RESERVED', 1, 3, 2, 400000, 3);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (48.0, 'Rawicz', 'Robotnicza 12/4', 'RESERVED', 1, 3, 1, 350000, 3);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (67.0, 'Rawicz', 'Robotnicza 12/5', 'FREE', 2, 3, 2, 420000, 3);
INSERT INTO t_apartment (size, city, street, apartment_status, floor, room_count, balcony_count, price, building_id) VALUES (70.6, 'Rawicz', 'Robotnicza 12/6', 'SOLD', 2, 4, 1, 470000, 3);