LAB-1

1.

2
SELECT COUNT(DISTINCT Dnumber)
FROM EMPLOYEE_REC E, EMPLOYEE_DEPARTMENT D
WHERE D.Dnumber = E.Dno and E.Salary > 40000;

3
SELECT COUNT(*)
FROM EMPLOYEE_REC
WHERE EMPLOYEE_REC.Dno NOT IN (SELECT EMPLOYEE_DEPARTMENT.Dnumber
FROM EMPLOYEE_DEPARTMENT
WHERE Zipcode =30332);

4
SELECT City FROM EMP_CUSTOMERS
INTERSECT
SELECT City FROM EMP_SUPPLIERS
ORDER BY City;

LAB-2

1

2

LAB-3

1.

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG