oooooh boooooy

1)
VIEW `rh`.`1` AS
    SELECT
        `rh`.`nivelsal`.`nivel` AS `nivel`,
        `rh`.`nivelsal`.`MINSAL` AS `MINSAL`,
        `rh`.`nivelsal`.`MAXSAL` AS `MAXSAL`
    FROM
        `rh`.`nivelsal`

2)
VIEW `rh`.`2` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        `rh`.`empr`.`DEPTNO` AS `deptno`,
        `rh`.`empr`.`SAL` AS `sal`
    FROM
        `rh`.`empr`
    WHERE
        (`rh`.`empr`.`SAL` BETWEEN 500 AND 1500)

3)
VIEW `rh`.`3` AS
    SELECT
        `rh`.`depart`.`DEPTNO` AS `deptno`,
        `rh`.`depart`.`DNOME` AS `dnome`
    FROM
        `rh`.`depart`
    ORDER BY `rh`.`depart`.`DNOME`

4)
VIEW `rh`.`4` AS
    SELECT DISTINCT
        `rh`.`empr`.`FUNCAO` AS `funcao`
    FROM
        `rh`.`empr`

5)
VIEW `rh`.`5` AS
    SELECT
        `rh`.`empr`.`EMPNO` AS `EMPNO`,
        `rh`.`empr`.`ENOME` AS `ENOME`,
        `rh`.`empr`.`FUNCAO` AS `FUNCAO`,
        `rh`.`empr`.`CHEFE` AS `CHEFE`,
        `rh`.`empr`.`DATAADM` AS `DATAADM`,
        `rh`.`empr`.`SAL` AS `SAL`,
        `rh`.`empr`.`COM` AS `COM`,
        `rh`.`empr`.`DEPTNO` AS `DEPTNO`
    FROM
        `rh`.`empr`
    WHERE
        ((`rh`.`empr`.`DEPTNO` = 20) OR 10)
    ORDER BY `rh`.`empr`.`ENOME`

6)
VIEW `rh`.`6` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        `rh`.`empr`.`FUNCAO` AS `funcao`,
        `rh`.`empr`.`SAL` AS `sal`
    FROM
        `rh`.`empr`
    WHERE
        (`rh`.`empr`.`CHEFE` IS NOT NULL)

7)
VIEW `rh`.`7` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        `rh`.`empr`.`FUNCAO` AS `funcao`
    FROM
        `rh`.`empr`
    WHERE
        ((`rh`.`empr`.`FUNCAO` = 'administrativo')
            AND (`rh`.`empr`.`DEPTNO` = 20))

8)
VIEW `rh`.`8` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`
    FROM
        `rh`.`empr`
    WHERE
        ((`rh`.`empr`.`ENOME` LIKE '%OS%')
            OR (`rh`.`empr`.`ENOME` LIKE '%EI%'))

9)
VIEW `rh`.`9` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        ((`rh`.`empr`.`SAL` * 12) + IFNULL(`rh`.`empr`.`COM`, 0)) AS `remuneracao`
    FROM
        `rh`.`empr`

10)
VIEW `rh`.`10` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`
    FROM
        `rh`.`empr`
    WHERE
        (`rh`.`empr`.`ENOME` LIKE 'A%')

11)
VIEW `rh`.`11` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        ((`rh`.`empr`.`SAL` * 0.35) + IFNULL(`rh`.`empr`.`COM`, 0)) AS `descontos`
    FROM
        `rh`.`empr`

12)
VIEW `rh`.`12` AS
    SELECT
        CONCAT(`rh`.`empr`.`ENOME`,
                ' tem ocupado a posição de ',
                `rh`.`empr`.`FUNCAO`,
                ' no departamento ',
                `rh`.`empr`.`DEPTNO`,
                ' desde ',
                `rh`.`empr`.`DATAADM`) AS `informacao_empregados`
    FROM
        `rh`.`empr`

13)
VIEW `rh`.`13` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        (`rh`.`empr`.`SAL` * 12) AS `anual_sal`,
        `rh`.`empr`.`COM` AS `com`
    FROM
        `rh`.`empr`
    WHERE
        ((`rh`.`empr`.`FUNCAO` = 'vendedor')
            AND (`rh`.`empr`.`SAL` > `rh`.`empr`.`COM`))
    ORDER BY `rh`.`empr`.`SAL` DESC , `rh`.`empr`.`ENOME`

14)
VIEW `rh`.`14` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        `rh`.`depart`.`DNOME` AS `dnome`
    FROM
        (`rh`.`empr`
        JOIN `rh`.`depart`)
    WHERE
        (`rh`.`depart`.`DEPTNO` = `rh`.`empr`.`DEPTNO`)

15)
VIEW `rh`.`15` AS
    SELECT
        `rh`.`empr`.`ENOME` AS `enome`,
        `rh`.`depart`.`DNOME` AS `dnome`
    FROM
        (`rh`.`empr`
        JOIN `rh`.`depart`)
    WHERE
        (`rh`.`depart`.`DEPTNO` = `rh`.`empr`.`DEPTNO`)