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 (UnitCode, UnitName) Offerings (UnitCode Year, Semester, coordinator) Results (UnitCode, ear, Semester, Student Number, Result) StudentDetails (StudentNumber, Name, Address) Consider the following SOL query: SELECT UnitDetails.UnitCode, UnitDetails.UnitName, Results.Year, Results.Semester, Results.Result FROM StudentDetails, Unitbetails, Results WHERE StudentDetails.StudentNumber Results.StudentNunber AND UnitDetails.UnitCode = Results "UnitCode AND StudentDetails.Name 'John Bron' ORDER BY Results.Year, Results.Senester, UnitDetails.UnitCode Which of the following best describes the purpose of that SQL query? 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 from the UnitDetails, Results and Studenttails tables are included in the output The query joins all four 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 code. 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, Results and StudentDetails 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. 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 from the UnitDetails and Results tables are included in the output. The query is not valid as it is syntactically incorrect