Question
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started