Question: SELECT ps . first _ name | | ' ' | | ps . last _ name AS student, cs . grade, pt . first

SELECT ps.first_name ||''|| ps.last_name AS student, cs.grade,
pt.first_name ||''|| pt.last_name AS teacher,
s.subject, c.semester, c.year
FROM people ps
JOIN students s ON ps.person_id = s.person_id
JOIN classroom_students cs ON s.student_id = cs.student_id
JOIN classrooms c ON c.classroom_id = cs.classroom_id
JOIN subjects s ON s.subject_id = c.subject_id
JOIN teachers t ON t.teacher_id = c.teacher_id
JOIN people pt ON pt.person_id = t.person_id;
(3%) Using the view you just created, write a query that outputs all the students in Megan Gray's spring, 2021 Science class. It should include the student's name and grade and should be ordered so that the students with the highest grades show up first.
(5%) Write a query that gets the full name of the teacher who teaches Science at Fayetteville-Manlius School in the spring of 2021.

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!

Q:

Help me come up with a for each statement to print their letter grade. this is the code i have so far and then this is the given code from student.java public class GradeBook { public static void...

Q:

Answer must be in java and the classes needed to complete the question is provided down below. The majority of the picture just explains what the methods in the class GradeBooking do, the question is...

Q:

please write a simple Java program on bluej the user enter the grade SAMPLE OF OUTPUT: Enter student details: First Name: John Last Name: Kendall Marks : 96 Grade First Name John Last Name Kendall A+...

Q:

Please help me to do this interface and linking in Microsoft VISUAL Studio ( Window Form application ) Please use c# Figure 1 till figure 10 anything Overview of My Tutors (MyT) My Tutors is a free,...

Q:

This program will read data from a text file to produce a grade report. The data in the text file will contain the class ID (or title), the number of tests given in the class, and a list of students...

Q:

Check my most recent question asked.. I re-uploaded it as a single picture (might help to zoom in, it was screenshotted on vertical monitor) with a google doc link (all user access) for the large...

Q:

please answer this by Using Apex Oracle Program database programing. need accurate answer and should use apex oracle. Assignment #2 (4%) Instruction: Include FULL Screenshot that display your code...

Q:

write a C program that manages students records. A student can be described by the following fields: Student ID Student last name Student last name Grade Major You need to use hierarchical structure...

Q:

SQL coding: i nstruction and questions is in the query.sql. Majority of the questions had been done. please complete the section that I bold in query.sql. If possible please help me create a 'course'...

Q:

The language is java. Most of the code is already written except the StudentMain. Please write the code to fit the prompt. Also, please do not use extremely complex java functions that a intro to...

Q:

An audit team would most likely examine the detail support for charges to which of the following accounts? a. Payroll expense. b. Cost of goods sold. c. Supplies expense. d. Legal expense.

Q:

Consider the following Lewis structure, where E is an unknown element: What is possible element E, and the molecular structure and the bond angle for this negative ion? :0: Select one: O a. E is a...

Q:

Computer Forensics is needed to ensure the overall integrity and the continued existence of an organization s computer system and network infrastructure. Group of answer choices True False

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Discuss the key people management challenges that Dorian faced.

Q:

Why are problems expected to increase in case the target employees have a low contact with the bidder firm?

Q:

How fast should bidder managers move into the target?