1. SELECT Name 
    2.   FROM employees
    3.     WHERE Birthday< ALL
    4.       (  SELECT Birthday
    5.              FROM employees
    6.                  WHERE DepartmentID IN
    7.                  ( SELECT DepartmentID
    8.                      FROM departments
    9.                      WHERE DepartmentName='市场部')
    10.         )；
    12.         SELECT employees.*,salary.*
    13.           FROM employees,salary
    14.             WHERE employees.EmployeeID=salary.EmployeeID;
    16. SELECT  *
    17.     FROM employees, departments 
    18.     WHERE employees.DepartmentID=departments.DepartmentID;
    20.     SELECT DepartmentName
    21.       FROM departments JOIN employees
    22.           ON departments.DepartmentID=employees.DepartmentID
    23.         WHERE employees.Name='王林';
    25. SELECT *
    26.   FROM departments JOIN employees USING(DepartmentID)
    27.     WHERE departments.DepartmentName!='广告部';
    29. SELECT employees.*,salary.InCome
    30.   FROM employees LEFT OUTER JOIN salary
    31.       ON employees.EmployeeID=salary.EmployeeID;
    33. SELECT Name,InCome,OutCome
    34.   FROM employees,salary,departments
    35.     WHERE employees.EmployeeID=salary.EmployeeID
    36.       AND
    37.             employees.DepartmentID=departments.DepartmentID
    38.         AND
    39.             DepartmentName='广告部'
    40.         AND
    41.             InCome>2000;
    43. SELECT Name,InCome,OutCome,Birthday
    44.   FROM employees,salary,departments
    45.     WHERE employees.EmployeeID=salary.EmployeeID
    46.       AND
    47.             employees.DepartmentID=departments.DepartmentID
    48.         AND
    49.             DepartmentName='研发部'
    50.         AND
    51.             Birthday<'1966-01-01';