SQL - LEVEL1

16.display the name of the current user .

17.display the names of employees working in department 10 or 20 or 40 or employees working as clerk,salesman or analyst .

18.display the names of employees whose name start with alphabets.

19.display the names for employees whose name ends with alphabets.

20.display the names of employees whose names have second alphabet A in their names.

21.display the names of employees whose name is exactly five characters in length.

22.display the names of employees who are not working as managers.

23.display the names of employees who are not working as salesman or clerk or analyst.

24.display all rows from emp table .the system should wait after every screen full of information.

25.display the total number of employees working in the company.

26.display the total salary being paid to all employees.

27.display the maximum salary from emp table.

28.display the minimum salary from emp table.

29.display the average salary from emp table.

30.Display the maximum salary being paid to clerk.

31.display the maximum salary being paid in dept no 20.

32.display the min sal being paid to any salesman.

33.display the average salary drawn by managers.

34.display the total salary drawn by analyst working in dept no 40.