QUESTION - 12
Consider the following relation in Company Database and solve the
queries
Employee(Emp_id, Ename, Age, Designation, Dept, Address,
Salary)
Emp_id: number (001, 002, 003 etc)
// Primary
key
Ename: String (any name like Adam, Andrew)
Age : number (any value in range 25-60)
Designation: String (TeamLead, Sus_admin, Clerk, Manager,
Programmer) //
repeat these
values among
employees
Dept: String (testing, administration, development) // repeat these
values among employees
Address: String (Marthahalli, Hsr, JP_nagar, vijaynagar, BTM) //
repeat these values
among employees
Salary: number (any values above Rs 20000)
i) Create the above table with proper constraints and insert atleast 8
records.
ii) Display the name and salary of the employees not belongs to
testing department, whose salary is in range above 20,000.
111) Retrieve the id, name and address of the employee whose
name starts with the letter 'a' and come from JP_nagar.
iv) Retrieve average salary of the employees.
v) Retrieve the employees name who are either Team_lead or
manager or programmer in decreasing order of their names.
Answers
Answered by
0
Answer:
hope I help you mark as brainly plz plz
Explanation:
plz bro plz plz plz
Similar questions