Write a query to find all the employees from Employee Table whose salary $($with Salary Column$)$ is between $50000$ to $100000.$ Write a query to fetch top N records from Employee Table. Given the following data definition, write a query that returns the number of students whose first name is John. TABLE students id INTEGER PRIMARY KEY, firstName VARCHAR$(30)$ NOT NULL, lastName VARCHAR$(30)$ NOT NULL Consider the following tables EMP and SALGRADE, write the query for $($i$)$ to $($vi$)$ and output for $($vii$)$ to $($x$)$ TABLE: EMPLOYEE $($i$)$ To display details of all employee in descending order of their DOJ $($ii$)$ To display NAME AND DESIG of those employees whose sgrade is either $\text{'}$S$02\text{'}$ or $\text{'}$S$03\text{'}($iii$)$ To display NAME, DESIG, SGRADE of those employee who joined in the year $2009($iv$)$ To display all SGRADE, ANNUAL$\_$SALARY from table SALGRADE $[$where ANNUAL$\_$SALARY $\backslash (=\backslash )$ SALARY $12\backslash (]\backslash )($v$)$ To display number of employee working in each SALGRADE from table EMPLOYEE $($vi$)$ To display NAME, DESIG, SALARY, HRA from tables EMPLOYEE and SALGRADE where SALARY is less than $50000($vii$)$ Select MIN$($DOJ$),$ MAX$($DOB$)$ from employee; $($viii$)$ Select SGrade,Salary$+$HRA from SalGrade where Sgrade$=\text{'}$S$02\text{'}($ix$)$ Select count$($distinct sgrade$)$ from employee $($x$)$ Select sum$($salary$),$ avg$($salary$)$ from salgrade