For student 2 only please Create the following queries using Data Manipulation Language (DML)-student must be able

  For student 2 only please

Transcribed Image Text:

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

Answer rating: 100% (QA)

For Student 2 the following SQL queries can be written to address the given tasks based upon the database schema provided in the images 1 Find the hig... View the full answer