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.$$