Database construction: Populate the tables of the database and submit the SQL source code with the snapshots of their results

Simple Quarries: design at least 10 simple queries at least one for each table

Designing Views: make at least three VIEWs by using join queries and advanced queries as much as you can.

In general, use the necessary keywords such as DISTINCT, and grouping/sorting commands to produce professional report results for queries. The query results should show records in tables with meaningful titles and proper format

My tables (on my SQL Workbench):

create database cp363finaldatabase; CREATE TABLE Organizations( organization_id INT PRIMARY KEY AUTO_INCREMENT, \#primary key that will auto increment org_name VARCHAR(80) NOT NULL UNIQUE, \#organization name w/ constraints of being unique and not null org_address TEXT, org_desc TEXT, org_networth DECIMAL (10,2), payment_cycle DATE NOT NULL ); CREATE TABLE Employee( employee_id INT PRIMARY KEY AUTO_INCREMENT, emp_firstName VARCHAR(50) NOT NULL, emp_lastName VARCHAR(50) NOT NULL, emp_address TEXT NOT NULL, emp_phone VARCHAR(15) NOT NULL, emp_username VARCHAR(50) NOT NULL UNIQUE, emp_email VARCHAR(50) NOT NULL UNIQUE, emp_password VARCHAR(50) NOT NULL