Write the SQL that will retrieve the following results STUID FNAME LNAME ADVISORFNAME ADVISORLNAME 2001 Tanisha Blake Jake Plummer 2003 Jonathan Wu Kelly Christensen 2004 Alvin Klein Jake Plummer 2005 John Jenkins Michelle Kwon The STUDENT table is as follows STUID FNAME LNAME ADVISOR ID 2001 Tanisha Blake 2 2002 Jess Goldwasser NULL 2003 Jonathan Wu 3 2004 Alvin Klein 2 2005 John Jenkins 1 The ADVISOR table is as follows ADVISOR ID ADVISORFNAME ADVISORLNAME 1 Michelle Kwon 2 Jake Plummer 3 Kelly Christensen 4 Nick Jonas

Question: Write the SQL that will retrieve the following results: STUID FNAME LNAME ADVISORFNAME ADVISORLNAME 2001 Tanisha Blake Jake Plummer 2003 Jonathan Wu Kelly Christensen 2004

Write the SQL that will retrieve the following results:

STUID	FNAME	LNAME	ADVISORFNAME	ADVISORLNAME
2001	Tanisha	Blake	Jake	Plummer
2003	Jonathan	Wu	Kelly	Christensen
2004	Alvin	Klein	Jake	Plummer
2005	John	Jenkins	Michelle	Kwon

The STUDENT table is as follows:

STUID	FNAME	LNAME	ADVISOR_ID
2001	Tanisha	Blake	2
2002	Jess	Goldwasser	NULL
2003	Jonathan	Wu	3
2004	Alvin	Klein	2
2005	John	Jenkins	1

The ADVISOR table is as follows:

ADVISOR_ID	ADVISORFNAME	ADVISORLNAME
1	Michelle	Kwon
2	Jake	Plummer
3	Kelly	Christensen
4	Nick	Jonas

Step by Step Solution

★★★★★

3.55 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

You can achieve this by using a SQL query that involves joining the STUDENT and ADVISOR tables based on the ADVISORID Heres the SQL query SELECT sSTUID sFNAME sLNAME aADVISORFNAME aADVISORLNAME FROM STUDENT s JOIN ADVISOR a ON sADVISORID aADVISORID This query selects the desired columns from the STUDENT table and joins it with the ADVISOR table ... View full answer

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!

Write the SQL that will retrieve the following results: Consultants Table Fname Lname HireDate Position Bella Agostino 11/12/2019 Developer John Perry 2/17/2016 Network Engineer Jessica Murdoch...

The Internal Revenue Service Restructuring and Reform Act (RRA) was signed into law by President Bill Clinton in 1998. A major objective of the RRA was to promote electronic filing of tax returns....

Player Team Position Salary Brian McCann Atlanta Braves Catcher$6,700,000 Brooks Conrad Atlanta Braves Third Baseman $427,250Chipper Jones Atlanta Braves Third Baseman $14,000,000 CraigKimbrel...

1. Write the SQL query to retrieve the following information of all employees: a. Employee number b. Employeelastname c. Date of hire d. Jobcode. The company wants to send a check to their employees...

[1] Write code for a webpage that uses client-side programming to extract dynamic data from two other sites and displays that information locally. In one case, it should traverse the document of the...

Write the SQL statements that provide the following database functionality: Query 1. Write an SQL statement that correctly uses the 'LIKE' symbol on an alphanumeric field to select a subset of data....

Write the SQL commands to grant the following privileges: a. User Stetson must be able to retrieve data from the Customer table. b. Users Webster and Bremer must be able to add new orders and order...

Based on the Dolphin Market database, write the SQL that would be required to answer the following questions. Provide the SQL and the number of rows returned or answer generated, depending on the...

1. Given the following relations, write the SQL statements that do the following: Person a. Find the names and addresses of drivers who got into accidents which resulted in a damage amount over 1000...

--Homework Assignment 9 --Using the Movie 2 Database write the SQL queries to satisfy the following. Submit this file with your SQL anwsers via D2L --1a List the DVD No and title for each movie that...

Heavens Hwy reporting date is 30 June. The company purchased an item of equipment on credit for $102,000 (ignore GST) on 1 October 2021. It is expected that the useful life of the equipment will be...

In the table below, categorize each benefit of the psychological contract in terms of whether it is an employee contribution of an empl inducement. Employee contribution Employer inducement Skills...

Work out the clamping force, in kilograms, exerted by the M 3 0 steel nut and bolt on the plates shown below. The nut has been torqued down to 6 Nm . Use the following formula and information: Torque...

10. Bonita is considering purchasing an expensive piece of jewelry next month. The local jeweler is offering a three-year financing plan to help her pay for the jewels. For the purposes of preparing...

Exercise 5.3 (Algo) Worksheet through Adjusted Trial Balance. LO 5-1, 5-2 On January 31, 20X1, the general ledger of Johnson Company showed the following account balances. Accounts Cash Accounts...

The General Duty Clause is often used to cite employers in the absence of a specific regulation. Provide an example of when you believe the Occupational Safety and Health Administration (OSHA)...

Which account would be best suited to AI? Taxes Retained earnings Cash Long-term liabilities

g(x) = x 5 5x 6 a. Show that g(x) = 0 has a root, , between x = 1 and x = 2. b. Show that the equation g(x) = 0 can be written as x = (px + q) 1/r , where p, q and r are integers to be found. The...

Under what circumstances would you include more than one index in a lengthy report?

The Gates Foundation is known around the world for the quality of its work, and that includes the quality of its communication efforts. Which of the following proofreading strategies should you use...

Austin, Texas, advertising agency GSD&M Advertising brainstorms new advertising ideas using a process it calls dynamic collaboration. A hand-picked team of insiders and outsiders is briefed on the...

Fiero Products, LTD, of Bologna, Italy, makes a variety of footwear, including indoor slippers, childrens shoes, and flip-flops. To keep up with increasing demand, it is considering three expansion...

The Great Air Commuter Service Company started in 1984 to pro-vide efficient and inexpensive commuter travel between Boston and New York City. People in the airline industry know Peter Wilson, the...

Quite a few years ago, a popular show called Lets Make a Deal appeared on network television. Contestants were selected from the audience. Each contestant would bring some silly item that he or she...