CREATE TABLE Authors
(
id int,
name varchar(100)
);
CREATE TABLE Books
(
id int,
author_id int,
title varchar(100),
published_date date
);
CREATE TABLE Sales
(
id int,
book_id int,
date date,
price int
);
Q1JFQVRFIFRBQkxFIEF1dGhvcnMKKAppZCBpbnQsCm5hbWUgdmFyY2hhcigxMDApCik7CgpDUkVBVEUgVEFCTEUgQm9va3MKKAppZCBpbnQsCmF1dGhvcl9pZCBpbnQsCnRpdGxlIHZhcmNoYXIoMTAwKSwKcHVibGlzaGVkX2RhdGUgZGF0ZQopOwoKQ1JFQVRFIFRBQkxFIFNhbGVzCigKaWQgaW50LApib29rX2lkIGludCwKZGF0ZSBkYXRlLApwcmljZSBpbnQKKTsK