Top's-Assignment
a) Get First_Name from employee table using alias name “Employee Name”.
b) Get FIRST_NAME, Joining year, Joining Month and Joining Date from employee table.
c) Get all employee details from the employee table order by First Name Ascending And Salary descending?
d) Get employee details from employee table whose first name contains „o‟.
e) Get employee details from employee table whose joining month is “January”.
f) Get department, total salary with respect to a department from employee table Order By total salary descending.
g) Get department wise maximum salary from employee table order by salary ascending?
h) Select first_name, incentive amount from employee and incentives table for those Employees who have incentives and incentive amount greater than 3000
i) Select 2nd Highest salary from employee table.
j) Select first_name, incentive amount from employee and incentives table for all Employees who got incentives using left join.
k) Create View OF Employee table in which store first name, last name and salary only.
l) Create Procedure to find out department wise highest salary.
m) Create after Insert trigger on Employee table which insert records in view table.
a) All orders for more than $1000.
b) Names and cities of all salespeople in London with commission above 0.10.
c) All salespeople either in Barcelona or in London.
d) All salespeople with commission between 0.10 and 0.12. (Boundary values should be excluded).
e) All customers with NULL values in city column.
f) All orders taken on Oct 3Rd and Oct 4th 1994.
g) All customers serviced by peel or Motika.
h) All customers whose names begin with a letter from A to B
i) All customers excluding those with rating <= 100 unless they are located in Rome.
j) All orders except those with 0 or NULL value in amt field.
k) Count the number of salespeople currently listing orders in the order table.