Consider the below two tables for reference

Employeelnfo Table

$\backslash$table$[[$EmpID$,$EmpFname,EmpLname,Department,Project,Address,DOB,Gender$],[1,$Sanjay,Mehra,HR$,$P$1,$Hyderabad$($HY$,01/12/1976,$M$],[2,$Ananya,Mishra,Admin,P$2,$Delhi$($DEL$),02/05/1968,$F$],[3,$Sonia,Kulkarni,HR$,$P$1,$Hyderabad$($HY$,02/05/1992,$F$]]$

EmployeePosition Table

$\backslash$table$[[$EmpID$,$EmpPosition,DateOfJoining,Salary$],[1,$Manager,$\frac{01}{05}\frac{?}{2022},500000],[2,$Executive,$\frac{02}{05}\frac{?}{2022},75000],[3,$Manager,$\frac{01}{05}\frac{?}{2022},90000]]$

a$)$ Write q query to find all the employees whose salary is between $50000$ to $100000.$

b$)$ Write a query to find the names of employees that begin with $\text{'}S\text{'}$

c$)$ Write a query to fetch all employees who also hold the managerial position.

d$)$ Write a query to fetch the department$-$wise count of employees sorted by department's count in ascending order

e$)$ Write a query to retrieve the list of employees working in the same department.