Problem
Aggregate Functions / Joins / Subqueries / Views) Using the database you created (your employee database), create SQL statements (1 per question) to accomplish the following (command and output required)
A. What is the average salary of the employees from CA?
B. What is the sum of the salaries for each state?
C. What is our employee total count for each department?
D. For each employee, list the employee last name with their department name.
E. Make a view of your employee table of only the employees from UT and without the salary column. Call the view emp_UT. Do an select * from this view.
F. A. Make a new table named emp_co_phone with the following columns: phone id int, emp_id int (or whatever data type you used in your employee table), phone_num varchar(25). Put in 3 rows of sample data (give 3 employees company phones).