peer response | The Nursing Tutors
November 19, 2020
Short Assignment II Research Methods and Design I -Confound It All! Instructions:
November 19, 2020

This is in MySQL. 
1. Return the names, IDS, and average salary of the top 10 employees who are Senior Engineers whose average salary is at least $110,000 in descending order.2. Find the top ten employees (names, IDs and total wages) who earned equal to or more than $200000 between 01/01/2000 and 01/01/2002. Order them in decreasing order. Assume salaries change every 12 months. For simplicity, ignore salaries that started or ended outside of the date range.3. Use a subquery to display the employee number and bottom 10 average salaries of the employees who are not ‘Staff’.

.button {
background-color: #4CAF50;
border: none;
color: white;
padding: 10px 20px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
border-radius: 10px;
}
.awasam-alert {
color: red;
}

 

"Is this question part of your assignment? We Can Help!"

Essay Writing Service
ORDER NOW