SQL query

as soon as possible

Practical-2 1. Retrieve all data from employee, jobs and deposit. SQL Query: Output: 2. Display job title and maximum salary of all jobs. 3. Display the department of employee without duplication. What is the answer if you apply it to whole employee table? 4. Give details of account no. and deposited rupees of customers having account opened between dates P1-01-06 and 25-07-06. 5. Display all jobs with minimum salary is greater than 4000. 6. Display name and salary of employee whose department no is 20. Give alias name to name of employee. 7. Display employee no, name and department details of those employee whose department lies in (10,20). 8. Display employee no, name and department details of those employee whose department not in (20,30). 9. Display employee no, name and department details of those emplovee whose department no is between 15 and 25. 10. Display the non-null values of employees. 11 Display name of customer along with its account no (both columu should be displayed as one) whose amount is not equal to 8000 Rs. 12. Insert some duplicate values in deposit table and apply the concept of Distinct and also combine two columns and display it one column using common alias name 13. Display the content of job details with minimum salary either 2000 - 4000