Cisco | SDE | 2022 | SQL: Filtering Even Scores and Formatting

Problem Statement: Examination Data There is a database containing student exam scores. Your task is to write a query to print the names and the corresponding marks of the students who scored an even number of marks. Requirements: The names must be displayed in UPPERCASE. The results should be ordered alphabetically ascending by the student's name. The output format should be: NAME MARKS. Schema Table: exam Name Type Description NAME STRING The name of the student. This is the primary ...