3. Clumsy Administrator A company maintains the records of all its employees. They pay their database administrator too

[answerhappygod]

3 Clumsy Administrator A Company Maintains The Records Of All Its Employees They Pay Their Database Administrator Too 1 (57.45 KiB) Viewed 290 times

3. Clumsy Administrator A company maintains the records of all its employees. They pay their database administrator too little so the work has been quite clumsy. The administrator has carelessly inserted the records of many employees into the employee records table multiple times. An employee's record is considered duplicate only if all the columns (fields) of his/her record are duplicated. Write a query to find the names of employees whose records occur more than once in the table. Schema You are provided 1 table: EMPLOYEE. EMPLOYEE Name Type Description NAME STRING The name of the employee. PHONE STRING The telephone number of the employee. AGE INTEGER The age of the employee. Sample Data Tables EMPLOYEE NAME PHONE AGE Jamie 1000040000 30 Jacob 1000020000 60 Jacob 1000020012 65 Jamie 1000040000 30 Henry 100001 2000 34 Henry 100001 2000 34 Here, the exact records of Jamie and Henry occur more than once in the table. Hence, Jamie and Henry are the employees in the resultant output.