Question: Given the following assignments and students tables, write a SQL query that returns all assignments with a score of 90 or greater along with the

 Given the following assignments and students tables, write a SQL query

Given the following assignments and students tables, write a SQL query that returns all assignments with a score of 90 or greater along with the names of the students to which such assignments belong. In the tables, assignments.student_id is a foreign key into students.id. (5 pts) assignments id student_id score 1 2. 87 2 2 93 3 3 74 4. 3 95 students id first_name last_name 1 Chris Bay 2 Sally Steuterman 3 Paul Matthews 4. Carly Langlois

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!