SQL Assignment Create the following Tables and insert the values accordingly and Perform the tasks mentioned below. Employee Table Employee Bonus Table Employee Title Table Tasks To Be Performed: Display the “FIRST_NAME” from Employee table using the alias name as Employee_name. Display “LAST_NAME” from Employee table in upper case. Display unique values of DEPARTMENT from EMPLOYEE table. Display the first three characters of LAST_NAME from EMPLOYEE table. Display the unique values of DEPARTMENT from EMPLOYEE table and prints its length. Display the FIRST_NAME and LAST_NAME from EMPLOYEE table into a single column AS FULL_NAME. a space char should separate them. DISPLAY all EMPLOYEE details from the employee table order by FIRST_NAME Ascending. 8. Display all EMPLOYEE details order by FIRST_NAME Ascending and DEPARTMENT Descending. Display details for EMPLOYEE with the first name as “VEENA” and “KARAN” from EMPLOYEE table. Display details of EMPLOYEE with DEPARTMENT name as “Admin”. DISPLAY details of the EMPLOYEES whose FIRST_NAME contains ‘V’. DISPLAY details of the EMPLOYEES whose SALARY lies between 100000 and 500000. Display details of the employees who have joined in Feb-2020. Display employee names with salaries >= 50000 and <= 100000. display details of the employees who are also managers. display duplicate records having matching data in some fields of a table. display only odd rows from a table. clone a new table from employee table. display the top 2 highest salary from a table. 21. display the list of employees with the same salary. display the second highest salary from a table. display the first 50% records from a table. display the departments that have less than 4 people in it. display all departments along with the number of people in there. 26 display the name of employees having the highest salary in each department. display the names of employees who earn the highest salary. diplay the average salaries for each department display the name of the employee who has got maximum bonus display the first name and title of all the employees second part complete the below tasks using the table – studies, software & programmer. 51. who is the above programmer referred in 50? 52. who is the youngest programmer knowing dbase? 53. which female programmer earning more than 3000 does not know c, c++, oracle or dbase? 54. which institute has most number of students? 55. what is the costliest course? 56. which course has been done by the most of the students? 57. which institute conducts costliest course. 58. display the name of the institute and course, which has below avg course fee. 59. display the names of the courses whose fees are within 1000 (+ or -) of the average fee, 60. which package has the highest development cost? 61. which course has below avg number of students? 62. which package has the lowest selling cost? 63. who developed the package that has sold the least number of copies? 64. which language has used to develop the package, which has the highest sales amount? 65. how many copies of package that has the least difference between development and selling cost where sold. 66. which is the costliest package developed in pascal. 67. which language was used to develop the most number of packages. 68. which programmer has developed the highest number of packages? ms sql certification training
[email protected] - +91-7022374614 - us: 1-800-216-8930 (toll free) 69. who is the author of the costliest package? 70. display the names of the packages, which have sold less than the avg number of copies. 71. who are the authors of the packages, which have recovered more than double the development cost? 72. display the programmer name and the cheapest packages developed by them in each language. 73. display the language used by each programmer to develop the highest selling and lowest-selling package. 74. who is the youngest male programmer born in 1965? 75. who is the oldest female programmer who joined in 1992? 100000.="" display="" details="" of="" the="" employees="" who="" are="" also="" managers.="" display="" duplicate="" records="" having="" matching="" data="" in="" some="" fields="" of="" a="" table.="" display="" only="" odd="" rows="" from="" a="" table.="" clone="" a="" new="" table="" from="" employee="" table.="" display="" the="" top="" 2="" highest="" salary="" from="" a="" table.="" 21.="" display="" the="" list="" of="" employees="" with="" the="" same="" salary.="" display="" the="" second="" highest="" salary="" from="" a="" table.="" display="" the="" first="" 50%="" records="" from="" a="" table.="" display="" the="" departments="" that="" have="" less="" than="" 4="" people="" in="" it.="" display="" all="" departments="" along="" with="" the="" number="" of="" people="" in="" there.="" 26="" display="" the="" name="" of="" employees="" having="" the="" highest="" salary="" in="" each="" department.="" display="" the="" names="" of="" employees="" who="" earn="" the="" highest="" salary.="" diplay="" the="" average="" salaries="" for="" each="" department="" display="" the="" name="" of="" the="" employee="" who="" has="" got="" maximum="" bonus="" display="" the="" first="" name="" and="" title="" of="" all="" the="" employees="" second="" part="" complete="" the="" below="" tasks="" using="" the="" table="" –="" studies,="" software="" &="" programmer.="" 51.="" who="" is="" the="" above="" programmer="" referred="" in="" 50?="" 52.="" who="" is="" the="" youngest="" programmer="" knowing="" dbase?="" 53.="" which="" female="" programmer="" earning="" more="" than="" 3000="" does="" not="" know="" c,="" c++,="" oracle="" or="" dbase?="" 54.="" which="" institute="" has="" most="" number="" of="" students?="" 55.="" what="" is="" the="" costliest="" course?="" 56.="" which="" course="" has="" been="" done="" by="" the="" most="" of="" the="" students?="" 57.="" which="" institute="" conducts="" costliest="" course.="" 58.="" display="" the="" name="" of="" the="" institute="" and="" course,="" which="" has="" below="" avg="" course="" fee.="" 59.="" display="" the="" names="" of="" the="" courses="" whose="" fees="" are="" within="" 1000="" (+="" or="" -)="" of="" the="" average="" fee,="" 60.="" which="" package="" has="" the="" highest="" development="" cost?="" 61.="" which="" course="" has="" below="" avg="" number="" of="" students?="" 62.="" which="" package="" has="" the="" lowest="" selling="" cost?="" 63.="" who="" developed="" the="" package="" that="" has="" sold="" the="" least="" number="" of="" copies?="" 64.="" which="" language="" has="" used="" to="" develop="" the="" package,="" which="" has="" the="" highest="" sales="" amount?="" 65.="" how="" many="" copies="" of="" package="" that="" has="" the="" least="" difference="" between="" development="" and="" selling="" cost="" where="" sold.="" 66.="" which="" is="" the="" costliest="" package="" developed="" in="" pascal.="" 67.="" which="" language="" was="" used="" to="" develop="" the="" most="" number="" of="" packages.="" 68.="" which="" programmer="" has="" developed="" the="" highest="" number="" of="" packages?="" ms="" sql="" certification="" training=""
[email protected]="" -="" +91-7022374614="" -="" us:="" 1-800-216-8930="" (toll="" free)="" 69.="" who="" is="" the="" author="" of="" the="" costliest="" package?="" 70.="" display="" the="" names="" of="" the="" packages,="" which="" have="" sold="" less="" than="" the="" avg="" number="" of="" copies.="" 71.="" who="" are="" the="" authors="" of="" the="" packages,="" which="" have="" recovered="" more="" than="" double="" the="" development="" cost?="" 72.="" display="" the="" programmer="" name="" and="" the="" cheapest="" packages="" developed="" by="" them="" in="" each="" language.="" 73.="" display="" the="" language="" used="" by="" each="" programmer="" to="" develop="" the="" highest="" selling="" and="" lowest-selling="" package.="" 74.="" who="" is="" the="" youngest="" male="" programmer="" born="" in="" 1965?="" 75.="" who="" is="" the="" oldest="" female="" programmer="" who="" joined="" in="">