SQL - LEVEL1

1. diplay the details of all employees.

2. display the name and job of all employees

3. display name and salary for all employees

4. display employee number and total salary for each employee

5. display employee name and annual salary for all employees

6. display the names of all employees who are working in department number 10

7. display the names of all employees working as clerks and drawing a salary more than 3000

8. display employee number and names for employees who earn commision

9. display names of employees who do not earn any commision

10.display the names of employees who are working as clerk,salesman or analyst and drawing a salary more than 3000

11.display the names of employees who are working in the company for the past 5 years

12.display the list of employees who have joined in the company before 30th june 90 or after 31st dec90.

13.display current date .

14display the list of users in your database(using log table).

15.display the names of all tables from the current user.