MYSQL query for below using TWO SUBQUERIES: TABLE 1: FacultySubjects (Columns: StaffID, SubjectID, ProficiencyRating) TABLE 2: Staff
Fantastic news! We've Found the answer you've been seeking!
Question:
MYSQL query for below using TWO SUBQUERIES:
TABLE 1: FacultySubjects (Columns: StaffID, SubjectID, ProficiencyRating)
TABLE 2: Staff (Columns; StaffID, StaffName, StaffAddress, PhoneNumber, Salary, DateHired, Position)
Show the name, salary, and proficiency rating of the staff getting a salary of 5000 OR more than the average staff salary AND also have a proficiency rating more than or equal to the average proficiency rating.
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date: