Python Qs: 1. Write Program to get the most frequency occurring in file? 2. Given a list and a number find two numbers in the list that sums up to the number given? 3. Write Program to print a tree in level order traversal? 4. Write a function that accept the file, count and return the exact occurrence of a word based on count? 5. List a=[ 1,2,3 none, none] list b=[4,5,3] Output=[1,4,2,5,3,3] ? Sql Qs: Given Employee & Department tables 1. Display ename,dname even if there no employees working in a particular department. 2. List out the lowest paid employees working under each manager, exclude any groups where minsal is less than 1000, sort the output by salary 3. Display the name of employee who earn Highest Salary 4. Display the employee Number and name for employee working as clerk and earning highest salary among the clerks. 5. Display the job groups having Total Salary greater than the maximum salary for Managers. 6. Display the names of employees from department number 10 with salary greater than that of ANY employee working in other departments. 7. Display those employees whose salary is greater than his managers salary. 8. Display the grade and employees name for the deptno 10 or 30 but grade is not 4 while joined the company before 31-DEC-82. 9. Display the Second maximum salary from the table using subquery. 10. Display those employees whose salary is less than his manager but more than salary of other managers. Excel Qs: Given Employee & Department tables 1. Count number of employees whose salary is greater than 20000 2. Get chemistry dept employees total salary 3. what are the use of charts - Pie chart, Bar chart, Line chart, Pivot table, Con(bar & live). 4. Given 2 tables. Fill sales column using HLookup.
