Question
Please give PLSQL(Programming Language SQL Statements) Code 1(Step 1) https://codeshare.io/2EMK1o Code 2 (Step 2) https://codeshare.io/5PpZ0d Questions Query 1: Produce a list of current salary, monthly
Please give PLSQL(Programming Language SQL Statements) Code 1(Step 1) https://codeshare.io/2EMK1o Code 2 (Step 2) https://codeshare.io/5PpZ0d Questions
Query 1: Produce a list of current salary, monthly salaries, new salaries (monthly with 20% increase) for all staff, showing staff number, first and last names, and salary details.
Query 2: List all staff whose salary is greater or equal than the average salary of staff working in Branch B010, and show by how much.
Query 3: Find name of owners that the rent of their property is larger than all properties handled by branch B010.
Query 4: For total rent collected for properties located in different cities, list the cities and property with the highest rent collected
Query 5: List properties handled by staff at Burmingham.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started