Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL Oracle query that will list faculty supervisors and their respective students . Each supervisor's students should appear in a single row (i.e., list of

SQL Oracle query that will list faculty supervisors and their respective students. Each
supervisor's students should appear in a single row (i.e., list of values instead of
separate rows) i.e., if a faculty supervisor supervises more than one student then
all the supervised students' names should appear in a single row (next to each
other separated by a delimiter). 

Present your final output in the order of faculty supervisor's id and include only those results where the number of students against a supervisor is more than 1.
Hint: May consider using Oracle's special aggregate function. Consider
searching some single-set aggregate examples.

 

image.png


image.png 

1 Smith Faculty: 1 F_ID F_LAST F_FIRST F_MI LOC_ID Teresa J 9 4075921695 Associate 80000 F_PHONE F_RANK F_SALARY F_SUPER F_PIN F_IMAGE 6338 (BLOB) 23 2 Zhulin Mark M 10 4073875682 Full 108000 (null) 1121 (BLOB) 3 Langley Colin A 12 4075928719 Assistant 70000 4 9871 (BLOB)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Managing Global Supply Chains

Authors: Ray R. Venkataraman, Jeffrey K. Pinto

1st edition

1506302935, 1506302939, 978-1506302935

More Books

Students also viewed these Databases questions

Question

How are lean thinking and Six Sigma related?

Answered: 1 week ago