What is the SQL command to count values in attribute "EYE COLOR" that holds total count in a derived column “EYE COLOR MOSTER TOTAL" of table "MONSTERS" who's "EVIL POWER" is "Glamouring". List the

1. How to delete an existing table "t_person" in SQL? 2. How to use SQL to add a field "p_address" to a table "t_person"?

I want to write the SQL to create the tables for the ERD attached, but I also want to add this to the tables: rental date, due date, and return date so that I can support overdue queries. I also want it so each table has primary keys and foreign keys. I want it so the tables have at least 4 rows of data. How can I do this? Thank you for your help as I learn more about SQL and table creation.

PLZ HELP WITH THE FOLLOWING QUESTION  Using oralce sql or sql live Create a view named all_volunteer that gets details of all volunteers that assigned tasks in the organization. CREATE TABLE Packinglist(   List_ID INT NOT NULL,   Name VARCHAR(50),   Description VARCHAR(100),   PRIMARY KEY(List_ID)); CREATE TABLE Task(   Task_Code INT NOT NULL,   List_ID INT,   Task_Description VARCHAR(100),   Type VARCHAR(30),   Status VARCHAR(20),   PRIMARY KEY(Task_Code),   FOREIGN KEY(List_ID) REFERENCES Packinglist(List_ID)); CREATE TABLE Volunteer(   Vol_ID INT NOT NULL,   Name VARCHAR(50),   Telephone NUMBER,   Address VARCHAR(100),   PRIMARY KEY(Vol_ID)); CREATE TABLE Assignment(   Vol_ID INT,   Task_Code INT,   Start_Time TIME,   End_Time TIME,   PRIMARY KEY(Vol_ID, Task_Code),   FOREIGN KEY(Vol_ID) REFERENCES Volunteer(Vol_ID),   FOREIGN KEY(Task_Code) REFERENCES Task(Task_Code)); CREATE TABLE Package(   Pack_ID INT NOT NULL,   Task_Code INT,   Date DATE,   Weight FLOAT,   PRIMARY…