I need help with this sql lab please help me go to http://sqlfiddle.com/Create tables, please do add extra columns of your own choice in each table, insert rows and select rows with differentcriteria as we discussed in the class.Also, implement inner and outer joins on fields of your choice.Send me the screen shots of row selections and inner and outer joins.create table author_tbl(id INT NOT NULL AUTO_INCREMENT,author VARCHAR(40) NOT NULL,PRIMARY KEY ( id ));insert into author_tbl (author) VALUES ('John Smith');insert into author_tbl (author) VALUES ('Melissa Ding');insert into author_tbl (author) VALUES ('Robert Smith');insert into author_tbl (author) VALUES ('Jeena Lui');insert into author_tbl (author) VALUES ('Zoe Sing');insert into author_tbl (author) VALUES ('Tessa Baker');insert into author_tbl (author) VALUES ('Nancy Pelosi');insert into author_tbl (author) VALUES ('Paul Pelosi');insert into author_tbl (author) VALUES ('Smith Smith');insert into author_tbl (author) VALUES ('John Zhang');create table tutorials_tbl(id INT NOT NULL AUTO_INCREMENT,tutorial_title VARCHAR(100) NOT NULL,author_id INT NOT NULL,PRIMARY KEY ( id ),FOREIGN KEY (author_id)); insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Quantum Physics', 'John Smith');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Newtonian Physics', 'Melissa Ding');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Algebra', 'Robert Smith');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Liner Algebra', 'Jeena Lui');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Pre-Calculus', 'Zoe Sing');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Calculus', 'Tessa Baker');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Geomerty', 'Nancy Pelosi');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Number Theory', 'Paul Pelosi');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Discreate', 'Smith Smith');insert into tutorials_tbl (tutorial_title, tutorial_author) VALUES ('Math Statistics', John Zhang');create table address_tbl(id INT NOT NULL AUTO_INCREMENT,id_author INT NOT NULL,address VARCHAR(140),);city VARCHAR(72),state VARCHAR(2),zip VARCHAR(16),PRIMARY KEY ( id )insert into address_tbl (1, tutorial_author) VALUES (1, '123 Omer Street', 'Union City', 'CA', 945333);insert into address_tbl (1, tutorial_author) VALUES (2, '2345 Thurston Street', 'Daily City', 'MD', 945313);insert into address_tbl (1, tutorial_author) VALUES (3, '44123 Isfahan Drive', 'San Jose', 'CA', 945323);insert into address_tbl (1, tutorial_author) VALUES (4, '5423 Barbera Ct', 'Union City', 'CA', 945343);insert into address_tbl (1, tutorial_author) VALUES (5, '3421 Ellis Street', 'Fremont', 'OH', 945353);insert into address_tbl (1, tutorial_author) VALUES (6, '1234 Alec Street', 'San Bruno', 'WA', 945363);insert into address_tbl (1, tutorial_author) VALUES (7, '4567 Mike Road', 'Redwood City', 'CA', 945377);insert into address_tbl (1, tutorial_author) VALUES (8, '7890 Keren Drive', 'San Francisco', 'CA', 945388);insert into address_tbl (1, tutorial_author) VALUES (9, '3245 Fox Street', 'Tracy', 'CA' 945399);insert into address_tbl (1, tutorial_author) VALUES (10, '1789 Zooey Street', 'Modesto', 'CA' 945322);

Question

Accepted Answer

List of tables to be created with data type:- 
Table:- author_tbl
id INT auto_increment
author…