Выберите правильный вариант SQL запроса для создания таблицы book

CREATE TABLE book (isbn INTEGER, name VARCHAR NOT NULL, publication_date DATE NOT NULL, price DECIMAL(10, 2) NOT NULL, author_id BIGINT, CONSTRAINT pkbook PRIMARY KEY(isbn), CONSTRAINT fk_book_author FOREIGN KEY(author_id) REFERENCES author(id))
CREATE TABLE book(isbn INTEGER, name VARCHAR NOT NULL, publication_date DATE NOT NULL, price DECIMAL(10, 2) NOT NULL, CONSTRAINT pkbook PRIMARY KEY(isbn))
CREATE TABLE book(isbn INTEGER, name VARCHAR NOT NULL, publication_date DATE NOT NULL, price DECIMAL(10, 2) NOT NULL, author_id BIGINT, CONSTRAINT pkbook PRIMARY KEY(isbn))
СREATE TABLE book(isbn INTEGER, name VARCHAR NOT NULL, publication_date DATE NOT NULL, price DECIMAL(10, 2) NOT NULL, author_id BIGINT, CONSTRAINT pkbook PRIMARY KEY(isbn), CONSTRAINT fk_book_author FOREIGN KEY(id) REFERENCES author(author_id))

Для просмотра статистики ответов нужно войти.