For student 2 only please

Create the following queries using Data Manipulation Language (DML)-student must be able to explain the queries. Student 1 1. List the name, position, and salary of employees from branch BRO12, and arrange the list alphabetically according to the names. List the details of employees who work at any branch that is based in Penang state. List the type of the property and the business owner's name, for all properties in which the property type is Apartment with more than 4 number of rooms each. 2. 3. Student 2 1. Find the highest salary of Supervisors. 2 3. List the preferred type of property for clients whose name starts with the letter H. List the name, phone, and city of the registered branch for clients whose preferred accommodation type is Apartment. I Create the following queries using Data Manipulation Language (DML)-student must be able to explain the queries. Student 1 1. List the name, position, and salary of employees from branch BRO12, and arrange the list alphabetically according to the names. List the details of employees who work at any branch that is based in Penang state. List the type of the property and the business owner's name, for all properties in which the property type is Apartment with more than 4 number of rooms each. 2. 3. Student 2 1. Find the highest salary of Supervisors. 2 3. List the preferred type of property for clients whose name starts with the letter H. List the name, phone, and city of the registered branch for clients whose preferred accommodation type is Apartment. I