Answer Happy

Using the same scenario and the database you created in PracticeExercise 4, write at least 15 SQL queries on your populateddatabase.
Submit a Microsoft Word document showing each of your 15 SQLcommands and a screen capture of the results of each command in thedatabase application (i.e Microsoft Access, Oracle, or MySQL,etc.).
Your 15 SQL commands must have Select From Statements includingat least one from the attached document.
MY DATABASE:
CREATE TABLE `company_projects`.`project_budget` (
`project_code` CHAR (5) NULL,
`project_name` VARCHAR(45) NOT NULL,
`project_budget` FLOAT NULL,
PRIMARY KEY (`project_code`)
);
CREATE TABLE `company_projects`.`project_budget` (
`project_code` CHAR (5) NULL,
`project_name` VARCHAR(45) NOT NULL,
`project_budget` FLOAT NULL,
PRIMARY KEY (`project_code`)
);
CREATE TABLE `company_projects`.`employee` (
`employee_id` CHAR(4) NOT NULL,
`employee_name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`employee_id`)
);
CREATE TABLE `company_projects`.`deparment` (
`department_id` CHAR (3) NOT NULL,
`deparment_name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`department_id`)
);
CREATE TABLE `company_projects`.`hourly_rate` (
`deparment_id` CHAR(3),
`hourly_rate` DATETIME NOT NULL,
PRIMARY KEY (`deparment_id`)
);
. SQL Commands to run queries on a database Using the same scenario and the database you created in Practice Exercise 4, write at least 15 SQL queries on your populated database. . Northern Virginia Community College Annandale Campus ITD 256 Advanced Database Management Total: Submit a Microsoft Word document showing each of your 15 SQL commands and a screen capture of the results of each command in the database application (i.e Microsoft Access, Oracle, or MySQL, etc.). Practice Exercise 5 Your 15 SQL commands must have Select From Statements including at least one of the following: WHERE AND/OR IN BETWEEN Relational Operators (>=, <=, <, >, <>) LIKE with Wildcards (*, %, etc.) At least one of: COUNT SUM AVG MIN MAX DISTINCT HAVING GROUP BY ORDER BY Subqueries Joins Grading Rubric: Work is Complete Submitted all the examples of commands required in assignment SQL commands are useful commands SQL commands shows understanding of writing queries 15 Points 15 Points 10 Points 10 Points 50 Points 1 Page