How will you read columns (lastname, firstname, department) and rows (department='Accounting' from table EMPLOYEE? SELECT FROM FirstName, LastName, Department FROM EMPLOYEE WHERE Department = 'Accounting': O SELECT FirstName, LastName, Department FROM EMPLOYEE; O SELECT FirstName, LastName, Department FROM ACCOUNTING; SELECT FirstName, LastName, Department FROM EMPLOYEE WHERE Department = 'Accounting': D Question 7 10 pts How will you read columns (lastname, firstname, department) and rows department='Accounting' from table EMPLOYEE and sort the result by lastname in alphabetical order? SELECT FirstName, LastName, Department FROM EMPLOYEE WHERE department='Accounting': SELECT FirstName, LastName, Department FROM EMPLOYEE WHERE department="Accounting' ORDER BY lastname desc: SELECT FirstName, LastName, Department FROM EMPLOYEE WHERE department="Accounting' ORDER BY lastname; SELECT FirstName, LastName, Department FROM EMPLOYEE WHERE department='Accounting' SORT BY lastname asc; Question 8 10 pts How do you count the number of employees in each department from table EMPLOYEE? Hint: use group by O SELECT Count(*) AS NumberOfEmployees FROM EMPLOYEE; SELECT Department, Count(*) AS NumberOfEmployees FROM EMPLOYEE; SELECT Count(*) AS NumberOfEmployees FROM EMPLOYEE GROUP BY Department: SELECT Department, Count(*) AS NumberOfEmployees FROM EMPLOYEE GROUP BY Department; Question 9 10 pts How do you insert new data to table DEPARTMENT? INSERT INTO DEPARTMENT VALUES(.....) INSERT DEPARTMENT INTO VALUES(.....) INSERT TO DEPARTMENT VALUES(.....) INSERT DEPARTMENT VALUES(.....) Question 10 10 pts How do you select distinct department name from table PROJECT? SELECT Department FROM PROJECT; O SELECT UNIQUE Department FROM PROJECT; SELECT DISTINCT Department FROM PROJECT; O SELECT INDIVIDUAL Department FROM PROJECT