Question: Write a query that returns the following columns: Person's full name. Person's role at the school: principal, teacher, or student. Person's salary (or N/A for

Write a query that returns the following columns:

Person's full name.
Person's role at the school: principal, teacher, or student.
Person's salary (or N/A for students).
Person's school name.

SYSTEM.SCHOOLS P SCHOOL_ID SCHOOL_NAME ADDRESS CITY REGION POSTAL CODE COUNTRY NUMBER VARCHAR2 (35 BYTE) VARCHAR2 (60 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (10 BYTE) VARCHAR2 (15 BYTE) F PRINCIPAL_ID NUMBER SCHOOLS_PK (SCHOOL_ID) SCHOOL PRINCIPAL_FK (PRINCIPAL_ID) SYSTEM.PRINCIPALS IP * PRINCIPAL_ID F PERSON_ID SALARY NUMBER NUMBER NUMBER PRINCIPALS_PK (PRINCIPAL_ID) SYS_C0021074 (PERSON_ID) P F SYSTEM.PEOPLE PERSON_ID SCHOOL_ID * FIRST_NAME LAST_NAME BIRTH DATE ADDRESS CITY REGION POSTAL CODE COUNTRY PEOPLE_PK (PERSON_ID) SYS_C0021064 (SCHOOL_ID) CLASSROOM_ID NUMBER NUMBER VARCHAR2 (10 BYTE) VARCHAR2 (20 BYTE) DATE VARCHAR2 (60 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (10 BYTE) VARCHAR2 (15 BYTE) SYSTEM.STUDENTS P STUDENT_ID IF NUMBER PERSON_ID NUMBER GRADE_LEVEL NUMBER STUDENTS_PK (STUDENT_ID) SYS_C0021071 (PERSON_ID) SYSTEM.CLASSROOM_STUDENTS P CLASSROOM_STUDENT_ID F F STUDENT_ID GRADE NUMBER NUMBER NUMBER NUMBER CLASSROOM_STUDENTS_PK (CLASSROOM_STUDENT_ID) SYS_C0021082 (STUDENT_ID) SYS_C0021081 (CLASSROOM_ID) SYSTEM.TEACHERS P * TEACHER_ID NUMBER F F PERSON_ID NUMBER SUBJECT_ID NUMBER SALARY NUMBER TEACHERS_PK (TEACHER_ID) SYS_C0021067 (PERSON_ID) SYS_C0021068 (SUBJECT_ID) P F F SYSTEM.SUBJECTS P SUBJECT_ID NUMBER SUBJECT VARCHAR2 (60 BYTE) SUBJECTS_PK (SUBJECT_ID) tt SYSTEM.CLASSROOMS CLASSROOM_ID TEACHER_ID SUBJECT_ID SEMESTER YEAR NUMBER NUMBER NUMBER VARCHAR2 (6 BYTE) NUMBER (4) CLASSROOMS_PK (CLASSROOM_ID) SYS_C0021077 (TEACHER_ID) SYS_C0021078 (SUBJECT_ID)

Step by Step Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer The query is as follow SELECT CONCATPfirstname Plastname AS Persons f... 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!

Richard needs to borrow $34,103 and has narrowed his search for a loan to two banks. The first bank offers 67-month simple interest loans at an annual rate of 4.9%. The second bank offers 62-month...

Abby found a roll of fabric. The fabric is 36 inches wide and 23 feet 3 inches long. He needs to cut four 1-yard-wide sections from this roll. The length of those sections are 5 2/3 ft., 4 7/8 ft., 5...

On July 12 of this year, Lucas transferred $250,000 of FFP stock to a new trust. He gave the trustee directions to pay income to Dina for the next 20 years and then remit the remainder to Dina's son...

Oracle SQL Project in Brief..... 1. There are eight tables in the schema. Write eight queries that each return one row with one column showing how many records each table has. Give the column an...

IN PHP 1. Create a class called Person that has the following attributes: name (a string) age (an integer) gender (a string) The class should have the following methods: setName($name): This method...

PLS FILL THIS TEMPLATE ACCORDING TO THE INFORMATION GIVEN IN RESOURCES, BUT FOLLOW THE TEMPLATE RESOURCES-https://drive.google.com/drive/folders/1Pag8dyyUXC5n0eAVgOWV-Hg6-X_X2rzQ?usp=sharing...

303 DEVELOPING A PROGRAM PHILOSOPHY AND RATIONALE STATEMENT Previous chapters have discussed the processes used in developing new courses and improving programs and fields of study. Each of these...

s ask for just cause 1. How long has the employee has been working for the company 2. Disciplinary record 3. Notice of expectations 4. Disparate treatment 5. Adequate investigation 6. Progressive...

Are there fundamental differences between liberal arts colleges and universities? In this case, we have information on the top 25 liberal arts colleges and the top 25 universities in the Unites...

Suppose that a task in a project has the following time estimates: to= optimistic completion time = 6 weeks tm= most likely completion time = 8 weeks tp= pessimistic completion time = 11 weeks...

explain the relationship between forward rate and expected spot rates

A variable-air-volume (VAV) cooling system is a type where the quantity of air supplied and the supply air temperature are controlled. The space is to be maintained at 75 F (24 C) db and 63 F (17 C)...

Toefield Inc. has developed a powerful efficient snow remover that is significantly less polluting than existing snow removers currently on the market. The company spent $2,000,000 developing this...

Defend your research paper proposal on the topic Strategic allocation of Finance Resources in R&D across existing Businesses and describe about the problem and Research Question.

Read the Hewlett-Packard Company: Network Printer Design for Universality Case Study in the Simchi-Levi et al. text. Each question must be answered thoroughly and responses must be supported by the...

Write a thematic integration of faith and learning concept paper using a well-rounded approach to the concepts found in the course texts and current scholarly literature. This paper must be submitted...

What is absolutely true about a process in control?Select the correct answerA. The process will always be between the control limitsB. The variation in such a process will be lessC. The process will...

Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...

Brian and Kim have a 12-year-old child, Stan. For 2012, Brian and Kim have taxable income of $52,000, and Stan has nonqualifying dividend income of $4,500 and investment expenses of $250. No election...

Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...

Your doctor has told you that your youngest son suffers from somnambulism. What is another name for somnambulism? a. sleepwalking b. insomnia c. sleep apnea d. narcolepsy

Which theory of hypnosis includes the idea of a hidden observer? a. biological b. social cognitive c. dissociative d. expectancy

________ is a tranquilizer also known as the date rape drug. a. Halcion b. Rohypnol c. Librium d. Xanax