2.

options

Consider a database with the tables listed below. The columns in each table are shown in parentheses 0. The primary key for each table is signified by the underlined columns. UnitDetails (Unicode, UnitName) Offerings UnitCode, Year, Semester, Coordinator) Results Unitcode, Year, Semester, Studentumber, Result) StudentDe? ails istudentimmber, Name , Address) Consider the following SQL query: SELECT UnitDetails.Unitcode, UnitDetails.UnitName, Results.Year, Results.semester, Results.Result FROM StudentDetails, UnitDetails, Result:s WHERE StudentDetails.StudentNumberResults.StudentNumber AND UnitDetails.Unitcode -Results.Unitcode AND studentDetails.Name 'John Brown' ORDER BY Results.Year, Results.Semester, UnitDetails.UnitCode Which of the following best describes the purpose of that SQL query? The query is not valid as it is syntactically incorrect. The query extracts all unit details and corresponding results for u UnitDetails and Results tables are included in the output. that Joh Brown has studied and orders them by year, semester and unit code. All of the columns from the The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. A selection of the columns from the UnitDetails and Results tables are included in the output The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. All of the columns rom the UnitDetails, Results and StudentDetails tables are included in the output The query extracts all unit details and coresponding results for units that John Browa has studied and orders them by year, semester and unit code. A selection of the columns from the UnitDetails, Results and StudentDetails tables are included in the output. tables in the database to extract all unit details corresponding results for units that John Brown has studied and orders them by year, semester and unit The query codc