--1 
SELECT * FROM Employee


--2
SELECT Fname,Lname,salary,Dno FROM Employee


--3
SELECT Pname ,Plocation,Dnum FROM Project


--4
SELECT  Fname +' '+ Lname AS [FULL NAME] , .1*(Salary*12) AS [ANNUAL COMM]
FROM Employee


--5
SELECT SSN,Fname+' '+Lname AS NAME FROM Employee WHERE Salary>1000


--6
SELECT SSN,Fname+' '+Lname AS NAME FROM Employee WHERE (Salary*12)>10000


--7
SELECT Fname+' '+Lname AS NAME ,Salary FROM Employee WHERE SEX='F'


--8
SELECT Dnum,Dname FROM Departments WHERE MGRSSN=968574


--9
SELECT pnumber,Pname,Plocation FROM Project WHERE Dnum=10





