pls show the command and the screenshot for the output

Show the screenshot of the your Query and index \& view pages. 1. Create the following table "Books". (1 point) Books table has four columns: id, name, category, and price: ICREATE TABLE Boolos 21 3id INT PRIMARY KEY NOT NULL. 4name VARCHAR(50) NOT NULL. 5 5ategory VARCHAR(50) NOT NULL. 6iprice INT NOT NULL 7): 2. Insert the following records in the Books table: 1 INSERT INTO 8ooks VALUES (1, \#ook1', 'Cat1', 1800) : 2 INSERT INTO Books VALUES (2, 'BookZ', 'Cat2', 1500); 3 INSERT INTO Books VALUES (3, Book3, 'Cat3', 2000): 4 INSERT INTO Boolos VALUES (4, 'Book4', 'Cat4', 1300); 5 INSERT INTO Blooks VALUES (5, 'Book5', 'Gat5', 1500); INSERT INTO Blooks VALUES (6, 'Book6', 'Cat6', 5000); INSERT INTO Hooks VALUES (7, 'BookT', 'Cat7', B000); INSERT INTO Books VALUES (8, 'Boolk8, 'Ca19', 5000); INSERT INTO Btooks VALUES (9, "Book9', 'Cat9, 5400); 10 INSERT INTO Books VALUES (10, 'Book10', 'Cat10', 3200); 3. Creates an index named "idx_name" on the "name" column in the "Books table using sQu Query (1 point) 4. Run the following Query: (0.5 point) SELECT * FROM Books WHERE name =800k10; 5. Create the "Explain plan" for the query shown in Question No. 4. (1 point) 6. Run the following query ( 0.5 point) CREATE INDEX idx_category ON Books(UPPER(category)); 7. Create the "Explain plan" for the query shown in Question No. 5. (1 point)