--Q1
CREATE TABLE book_table (
    book_id INT COMMENT '書籍ID',
    book_name VARCHAR(50) COMMENT '書籍名',
    author_name VARCHAR(50) COMMENT '著者',
    price INT COMMENT '価格',
    sales_flag INT COMMENT '販売有無'
);

--Q2
INSERT INTO book_table VALUES (10001, 'TwoPeace', '三田英一郎', 420, 1);
INSERT INTO book_table VALUES (10002, '名探偵金田二', '青山ふみや', 460, 1);
INSERT INTO book_table VALUES (20001, '坊ちゃま', '冬目漱岩', 460, 1);
INSERT INTO book_table VALUES (30001, '西方見聞録', '不明', 1000, 1);
INSERT INTO book_table VALUES (40010, '吾輩は犬である', '冬目漱岩', 420, 1);

--Q3
SELECT book_name, author_name FROM book_table;

--Q4
UPDATE book_table SET author_name = 'マール＝コー＝ポロ', sales_flag = 0 WHERE book_id = 30001;
SELECT * FROM book_table;

--Q5
SELECT * FROM book_table WHERE sales_flag = 1;

--Q6
SELECT * FROM book_table WHERE author_name = '冬目漱岩' AND price = 420;

--Q7
DELETE FROM book_table WHERE book_id = 20001;
SELECT * FROM book_table;
