This query provides a comprehensive report for each student, incorporating conditional logic, handling NULL values, and utilizing specific SQL functions like IIF for additional logic. …see more Like ...