Suppose that you have the following two files (named Student and Scores). Professor Dumbledore has asked...

 

Transcribed Image Text:

Suppose that you have the following two files (named "Student" and "Scores"). Professor Dumbledore has asked you to write a SQL query to obtain a file that includes a record for each student with an O.W.L Score that is greater than 86. Includes the following records in your query. ID Last Name First Name O.W.L Score Student Last Name Potter Granger Diggory Malfoy Lovegood Score ID 1164 3157 6487 7697 9642 First Name Harry Hermione Cedric Draco Luna O.W.L Score 85 99 92 82 95 ID 6487 3157 9642 7697 1164 N.E.W.T. Score 88 100 95 75 Suppose that you have the following two files (named "Student" and "Scores"). Professor Dumbledore has asked you to write a SQL query to obtain a file that includes a record for each student with an O.W.L Score that is greater than 86. Includes the following records in your query. ID Last Name First Name O.W.L Score Student Last Name Potter Granger Diggory Malfoy Lovegood Score ID 1164 3157 6487 7697 9642 First Name Harry Hermione Cedric Draco Luna O.W.L Score 85 99 92 82 95 ID 6487 3157 9642 7697 1164 N.E.W.T. Score 88 100 95 75

Answer rating: 100% (QA)

SELECT SID AS ID S Last Name AS ... View the full answer