1. Dla kazdego czytelnika podaj liczbe rezerwacji

2. Podaj tych czytelnikow ktorzy wypozyczyli co najmniej 2 ksiazki XD

3. POdaj tych czytelnikow ktorzy posiadaja
  kwote zaleglosci wieksza niz srednia z wszystkich zaleglosci


---------------------------------

INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES ('John Ronald Reuel', 'Tolkien');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES ('Terry', 'Pratchett');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME, INSTITUTION) VALUES ('Michael', 'Example', 'MIT');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME, INSTITUTION) VALUES ('John', 'Smith', 'MIT');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES ('Andrzej', 'Sapkowski');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES
  ('George', 'Orwell');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES
  ('Wislawa', 'Szymborska');
INSERT INTO "AHAWRYLA"."AUTHOR" (FIRST_NAME, LAST_NAME) VALUES
  ('Adam', 'Mickiewicz');

INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('Helion', 'Poland', 'Warsaw');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('Nowa Era', 'Poland', 'Poznan');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('SomePublisher', 'USA', 'New York');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('Good Publishing', 'Canada', 'Toronto');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('XD Books', 'United Kingdom', 'London');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('Penguin Readers', 'Russia', 'Moscow');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('Our Books Are the Best', 'United Kingdom', 'Manchester');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('123 Publishing', 'United Kingdom', 'London');
INSERT INTO PUBLISHER (NAME, LOCATION_COUNTRY, LOCATION_CITY) VALUES
  ('321 Publishing', 'Russia', 'St. Petersburg');

INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED, OVERDUE_FEE) VALUES
    ('Janusz','Kowalski','jankol@gmail.com','Y', 12);
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED, OVERDUE_FEE) VALUES
    ('Mieczyslaw', 'Nowak', 'miecznik@onet.eu', 'N', 18);
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED, OVERDUE_FEE) VALUES
    ('Marcus', 'Smith', 'smithy123@yahoo.co.uk', 'N', 10);
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED, OVERDUE_FEE) VALUES
    ('Dimitry', 'Sovchenko', 'loveputin@gmail.com', 'N', 3);
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED, OVERDUE_FEE) VALUES
    ('Francesco Lorenzo', 'Puciarelli', 'pucia@gmail.it', 'N', 5);
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED) VALUES
    ('Admin', 'Adminovsky', 'admin@library.com', 'Y');
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED) VALUES
    ('Abdul', 'del''Hospital', 'maths@gmail.com', 'N');
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED) VALUES
    ('Juan Pablo', 'Escobar', 'ilikemeth213@gmail.com', 'Y');
INSERT INTO READER (FIRST_NAME, LAST_NAME, EMAIL, PRIVILIGED) VALUES
    ('Stefano', 'Terazzino', 'dance@gmail.com', 'Y');

INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Science', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Fantasy', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Horror', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Greek Drama', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Crime', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('School Books', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Dictionary', 'N');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Restricted', 'Y');
INSERT INTO "AHAWRYLA"."CATEGORY" (CATEGORY_NAME, RESTRICTED) VALUES
('Black Magic', 'Y');