sqlquery13.sql

Problem Statement:
List down the employee details with their annual salary, 
given that the annual salary of the employees being listed should be greater than 30000

Information about the table:
Table Employee:+---------+-------------------+-------------------+---------+------------+--------+----------+
| EmpCode | EmpName           | Job               | Manager | HireDate   | Salary | DeptCode |
+---------+-------------------+-------------------+---------+------------+--------+----------+
|    9369 | Ted Mosby         | SOFTWARE ENGINEER | 7902    | 1980-12-17 |   2800 |       20 |
|    9499 | Robin Scherbatsky | SALESMAN          | 7698    | 1981-02-20 |   1600 |       30 |
|    9566 | Lily Aldrin       | MANAGER           | 7839    | 1981-04-02 |   3570 |       20 |
|    9654 | Phoebe Buffay     | SALESMAN          | 7698    | 1981-09-28 |   1250 |       30 |
|    9782 | Monica Geller     | MANAGER           | 7839    | 1981-06-09 |   2940 |       10 |
|    9788 | Chandler Bing     | ANALYST           | 7566    | 1982-12-09 |   3000 |       20 |
|    9839 | Marshall Eriksen  | PRESIDENT         | 7566    | 1981-11-17 |   5000 |       10 |
+---------+-------------------+-------------------+---------+------------+--------+----------+

Solution:
select empcode, empname, salary, 12*salary as A_Sal from employee where 12*salary > 30000;

Output:
+---------+------------------+--------+-------+
| empcode | empname          | salary | A_Sal |
+---------+------------------+--------+-------+
|    9369 | Ted Mosby        |   2800 | 33600 |
|    9566 | Lily Aldrin      |   3570 | 42840 |
|    9782 | Monica Geller    |   2940 | 35280 |
|    9788 | Chandler Bing    |   3000 | 36000 |
|    9839 | Marshall Eriksen |   5000 | 60000 |
+---------+------------------+--------+-------+