# Q1
SELECT * FROM EMPLOYEE;
# Q2
SELECT FNAME,LNAME,SALARY,DNO FROM EMPLOYEE;
# Q3
SELECT PNAME, PLOCATION, DNUM FROM PROJECT;
# Q4
SELECT CONCAT(FNAME, ' ', LNAME) AS NAME,SALARY * 0.1 AS Salary FROM EMPLOYEE;
# Q5
SELECT CONCAT(FNAME, ' ', LNAME) AS NAME FROM EMPLOYEE WHERE SALARY > 1000;
# Q6
SELECT CONCAT(FNAME, ' ', LNAME) AS NAME FROM EMPLOYEE WHERE SALARY > 10000;
# Q7
SELECT CONCAT(FNAME, ' ', LNAME) AS NAME , SALARY FROM EMPLOYEE WHERE SEX = 'F';
# Q8 
SELECT DNUMBER, DNAME FROM DEPARTMENT WHERE MGRSSN = '968574';
# Q9
SELECT PNUMBER, PNAME, PLOCATION FROM PROJECT WHERE DNUM = 10;





