--問１
CREATE TABLE book_table (
    book_id INT,
    book_name VARCHAR(50),
    author_name VARCHAR(50),
    price INT,
    sales_flag INT
);

--問２
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);

--問３
SELECT book_name,author_name FROM book_table;

--問４
UPDATE book_table 
SET author_name = 'マール＝コー＝ポロ',
    sales_flag = 0
WHERE book_id = 30001;

--問５
SELECT * FROM book_table
WHERE sales_flag = 1;

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

--問７
DELETE FROM book_table
WHERE book_id = 20001;