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)

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please help me solve this problems for my computer science class. Deliverable 1. What is the run time for the following algorithm? Explain your approach public static int func(int n) { int count = 0;...

How do make a ER digram like similar to the following using my relational model? TshirtOrder PK TshirtOrderID FK OrderID FK ShirtID FK MaterialID FK ImageID Text Text Material Text font Staff PK...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

a. "The chair of the Computer Science department is requesting a list of students who have a grade of 85 or better in any computer course. She only wants to see their name once if they are in the...

Task 1 (5 marks): Create the above tables based on the list provided above: booking, cruise, model, qualifications, roster, schedule, staff, tour, and vessel. Insert at least five records into each...

SQL queries: 1. A. Find the name and phone number of each vendor who has a cooperating vendor. Hint: the vendors for whom the field Cooperating_Vendor_id is not empty B. Now find additionally the...

Using the picture below. what is the query for the data base? (using mysql xampp) Query on how the student_id (from table 1) and details_id(from table 2) join with the result in the table 3. Details...

Achieving Operational Excellence: Building a Relational Database for Operation. This exercise requires that you know how to develop a database using Microsoft Access, and know how to create forms,...

Choose an organization in the community to study (church, restaurant, retail, museum...etc). Interview leaders and team members. 1) What elements of a management system do they have in the...

1: 2 3 Question 37 (Mandatory) (2 points) Write a query that will use concatenation to list both FNAME and LNAME in the same column output. Use Author table to complete query (if you do not have a...

Define the following terms: i. P-Code ii. PDOP Mask iii. Position Dilution of Precision

Write how each expression is read. 1) lim (2x - 3) =1 4) lim Vx +2 DNE X-2 X-2" ifx

Question 6 ( 1 point ) Which values are NOT in the domain of the function? f ( x ) = x 4 x 2 - 2 5 A ) x = - 4 , 4 B ) x = - 4 , 5 C ) x = - 5 , 4 D ) x = - 5 , 5

What was the rate of growth in real GDP during the most recent quarter? You can find the answer in publications such as the Survey of Current Business, The Economist, and Business Week. Has growth...

Suppose that we have a linear program that is not in standard form. We could produce the dual by first converting it to standard form, and then taking the dual. It would be more convenient, however,...

How is monetary policy determined in the New Keynesian model? What is the central banks target, and what does the central bank control directly?

For the closed-economy, one-period model, suppose that U(C, l) = ln C + l, and F(K, N) = zK N 1 , where > 0 and 0

Suppose that U(c, c) = ln c + ln c, where > 0, and assume that the consumer lends at the real interest rate r 1 and borrows at the interest rate r 2 , where r 1

In the cost section of the proposal the contractor may want to include a Select (management reserve, budget expense, cost overload, itemized cost reserve) or Select (cost overload, contingency...

What are the three main parts of a use case scenario?

List the three main advantages in using prototyping.

Clyde Clerk is reviewing his firms expense reimbursement policies with the new salesperson, Trav Farr. Our reimbursement policies depend on the situation. You see, first we determine if it is a...

Use the production possibilities frontier in Figure 2P-2 to answer the following questions. a. What is the slope of the PPF between point A and point B? b. What is the slope of the PPF between point...

The graph in Figure 2P-1 shows Tanyas weekly production possibilities frontier for doing homework (writing papers and doing problem sets). a. What is the slope of the production possibilities...

Suppose that Canada produces two goods: lumber and fish. It has 18 million workers, each of whom can cut 10 feet of lumber or catch 20 fish each day. a. What is the maximum amount of lumber Canada...