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

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

Question:

  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

Expert Answer:

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