ребятки
для закрытия сессии надо сделать это задание
сможет кто помочь
в базах данных не шарю вообще

create database library;

use library;

create table author_book(
id_book int(10) AUTO_INCREMENT,
author_surname varchar(255) NOT NULL,
book_name varchar(255) NOT NULL
PRIMARY KEY(id_book));

create table count_books(
id int(10) AUTO_INCREMENT
id_book int(10) NOT NULL,
author_surname varchar(255) NOT NULL,
book_name varchar(255) NOT NULL,
count_books int(10) NOT NULL,
count_issued_books int(10) NOT NULL,
PRIMARY KEY(id)
FOREIGN KEY (id_book) REFERENCES author_book(id_book));

INSERT INTO author_book VALUES ('Howard Phillips Lovecraft', 'The Call of Cthulhu');
INSERT INTO author_book VALUES ('Howard Phillips Lovecraft', 'At the Mountains of Madness');
INSERT INTO author_book VALUES ('Howard Phillips Lovecraft', 'Dagon');
INSERT INTO author_book VALUES ('Howard Phillips Lovecraft', 'The Shadow over Innsmouth');
INSERT INTO author_book VALUES ('Howard Phillips Lovecraft', 'The Dream-Quest of Unknown Kadath');
INSERT INTO author_book VALUES ('Erich Maria Remarque', 'Im Westen nichts Neues');
INSERT INTO author_book VALUES ('Andrzej Sapkowski', 'Miecz przeznaczenia');
INSERT INTO author_book VALUES ('Edgar Allan Poe', 'The Narrative of Arthur Gordon Pym of Nantucket');
INSERT INTO author_book VALUES ('Kurt Vonnegut', 'Player Piano');

INSERT INTO count_books VALUES (1,'Howard Phillips Lovecraft', 'The Shadow over Innsmouth', 10, 12);

select *
from count_books
where (author_surname='Howard Phillips Lovecraft') and (count_issued_books > 5)