Question: Change this SQL , writing the join condition in the from clause. select a . student _ name, a . test _ score, b .

Change this SQL, writing the join condition in the from clause.
select a.student_name,
a.test_score,
b.letter_grade
from sec1311_student_scores a,
sec1311_grade_ranges b
where a.test_score between b.beginning_score
and b.ending_score
order by a.student_name;

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!