Good Morning, I need help! The following assignment is based on the database environment created in the Week Four Individual Assignment. Design and

Good Morning, I need help!

The following assignment is based on the database environment created in the Week Four Individual Assignment.

Design and develop the below queries using professional principles and standards:

• A set of SQL Statements that returns all rows and all data for each table in your database
• Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause
• Two SQL Statements that join two or more tables in one query. Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries

.

here are the table i created ...i'm very unfamiliar database creation. i understand how to create the tables but can't figure out how to insert data to generate the reports. Also, the SQL statements i need help on also

Also, i need help with the above statements.

Scripts and Tables:

CREATE TABLE `artmuseum`.`artist` (

 `Artist_ID` INT NOT NULL,

 `Artwork_ID` INT NOT NULL,

 `Artist_name` VARCHAR(45) NOT NULL,

 `Address` VARCHAR(45) NOT NULL,

 `City` VARCHAR(45) NOT NULL,

 `State` VARCHAR(2) NOT NULL,

 `Zip_Code` VARCHAR(5) NOT NULL,

 `Phone_Num` VARCHAR(45) NOT NULL,

 `Email` VARCHAR(45) NOT NULL,

 PRIMARY KEY (`Artist_ID`));

CREATE TABLE `artmuseum`.`artwork` (

 `Artwork_ID` INT NOT NULL,

 `Artist_ID` INT NOT NULL,

 `Departmential_ID` INT NOT NULL,

 `Art_Name` LONGTEXT NOT NULL,

 `Appraise_Val` DECIMAL(45) NOT NULL,

 `Create_Date` DATE NOT NULL);

ADD PRIMARY KEY (`Artwork_ID`)

CREATE TABLE `artmuseum`.`departmental` (

 `Departmental_ID` INT NOT NULL,

 `Artwork_ID` INT NOT NULL,

 `Supervisor` VARCHAR(45) NOT NULL,

 `Employee` VARCHAR(45) NOT NULL,

 `Depart_name` VARCHAR(45) NOT NULL,

 `Art_Catergory` VARCHAR(45) NOT NULL,

  'Art_Location` VARCHAR(45) NOT NULL

 PRIMARY KEY (`Departmental_ID`));

i thank you for your help!