Q1. B. Consider the Following Table Employee(emp_id, name,dept_id, email, mobile_number, join_date,salary, mgr_id) 1) Query to display the name and salary for all the employees whose salary is not in...

Write in SQL

Extracted text: Q1. B. Consider the Following Table Employee(emp_id, name,dept_id, email, mobile_number, join_date,salary, mgr_id) 1) Query to display the name and salary for all the employees whose salary is not in the range of Rs. 10,000 and 50,000. 2) Make sure that the Emailld of each employee is common and unique to that employee only. 3) Query to display the name and Department number of all the Employees in department number 8 and 12 in an alphabetical order by name. 4) Write a query to display the name of employees who have an 'a' and 'e' in their name. 5) Write a query to display the name, job, salary of all the employees whose job is clerk or teacher and whose salary is not equal to 15,000.