Testing exam report internal marks query
Subject ID: 11
Academic Year: 2025-2026 Even
Semester: 1
Course ID: 2

Formatted academic year: '2025-2026 - Even'

Students found: 65
- 2024CS001 John Doe (ID: 161)
- 2024CS002 Jane Smith (ID: 162)
- 2024CS003 Mike Johnson (ID: 163)
- 2024CS004 Sarah Williams (ID: 164)
- 2024CS005 David Brown (ID: 165)
- BSCNU001 ABINAYA A (ID: 101)
- BSCNU002 ABINAYA G (ID: 102)
- BSCNU003 AGALYA R N (ID: 103)
- BSCNU004 AJITHA R (ID: 104)
- BSCNU005 AJMATH BEEVI S (ID: 105)
- BSCNU006 AKALYA M (ID: 106)
- BSCNU007 AKSHAYA R (ID: 107)
- BSCNU008 ANISHA K (ID: 108)
- BSCNU009 ANUPRIYA D (ID: 109)
- BSCNU010 ANUSRI L (ID: 110)
- BSCNU011 DEEPIKA A (ID: 111)
- BSCNU012 DHARSHINI A (ID: 112)
- BSCNU013 DHARUNIKA K (ID: 113)
- BSCNU014 FAHIMA ALMAS J (ID: 114)
- BSCNU015 GOPIKA B (ID: 115)
- BSCNU016 HARSHINI S (ID: 116)
- BSCNU017 HEMALATHA M (ID: 117)
- BSCNU018 ISWARYA S (ID: 118)
- BSCNU019 JANANI K (ID: 119)
- BSCNU020 JANANI M (ID: 120)
- BSCNU021 JANANI V (ID: 121)
- BSCNU022 JAYALAKSHMI J (ID: 122)
- BSCNU023 JEEVIYA V (ID: 123)
- BSCNU024 JOTHIKA B (ID: 124)
- BSCNU025 KAARUNYA V (ID: 125)
- BSCNU026 KABILA N (ID: 126)
- BSCNU027 KANIMOZHI J (ID: 127)
- BSCNU028 KANISHKA S (ID: 128)
- BSCNU029 KARPAGAVALLI K (ID: 129)
- BSCNU030 KAVIYA G (ID: 130)
- BSCNU031 KAYALVIZHI M (ID: 131)
- BSCNU032 KEERTHANA A (ID: 132)
- BSCNU033 KEERTHANA E (ID: 133)
- BSCNU034 MANISHA M (ID: 134)
- BSCNU035 MEHAVARSHINI V (ID: 135)
- BSCNU036 MOHANA PRIYA S (ID: 136)
- BSCNU037 NARMATHA S (ID: 137)
- BSCNU038 NATHIYASRI R V (ID: 138)
- BSCNU039 NIVITHRA R (ID: 139)
- BSCNU040 PAVITHA B (ID: 140)
- BSCNU041 POORVAJA V (ID: 141)
- BSCNU042 PRIYADHARSHINI M (ID: 142)
- BSCNU043 PRIYADHARSHINI R (ID: 143)
- BSCNU044 RESHMA M (ID: 144)
- BSCNU045 RINESHA R (ID: 145)
- BSCNU046 ROZHINI K (ID: 146)
- BSCNU047 SABITHA S (ID: 147)
- BSCNU048 SANDHIYA P (ID: 148)
- BSCNU049 SHANMUGA PRIYA K (ID: 149)
- BSCNU050 SOWMIYA R (ID: 150)
- BSCNU051 SUBIKA M (ID: 151)
- BSCNU052 SUBIKSHA R (ID: 152)
- BSCNU053 SUGASRI K (ID: 153)
- BSCNU054 SUGUNA S (ID: 154)
- BSCNU055 VARTHINI B (ID: 155)
- BSCNU056 VENNILA K (ID: 156)
- BSCNU057 VIJAYASARASWATHI S (ID: 157)
- BSCNU058 VIJAYASRI V (ID: 158)
- BSCNU059 VISHNUPRIYA M (ID: 159)
- BSCNU060 YAZHINI A (ID: 160)

Student IDs: 161,162,163,164,165,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160
Calculation method: avg3

Query: SELECT 
                im.student_id, 
                ie.subject_id,
                et.type_name,
                im.marks_obtained
              FROM internal_marks im
              JOIN internal_exams ie ON im.internal_exam_id = ie.internal_exam_id
              JOIN exam_types et ON ie.exam_type_id = et.exam_type_id
              WHERE im.student_id IN (161,162,163,164,165,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160) 
                AND ie.subject_id = ?
                AND ie.academic_year = ?
                AND ie.semester = ?
                AND et.type_name IN ('CI1', 'CI2', 'CI3')

Internal data found: 5 records
- 101_11: {"CI1":25,"CI2":25,"CI3":25}
  CI marks: CI1=25, CI2=25, CI3=25
  Valid marks: [25,25,25]
  Calculated internal mark: 25
- 102_11: {"CI1":25,"CI2":25,"CI3":25}
  CI marks: CI1=25, CI2=25, CI3=25
  Valid marks: [25,25,25]
  Calculated internal mark: 25
- 103_11: {"CI1":25,"CI2":25,"CI3":25}
  CI marks: CI1=25, CI2=25, CI3=25
  Valid marks: [25,25,25]
  Calculated internal mark: 25
- 104_11: {"CI1":25,"CI2":25,"CI3":25}
  CI marks: CI1=25, CI2=25, CI3=25
  Valid marks: [25,25,25]
  Calculated internal mark: 25
- 105_11: {"CI1":25,"CI2":25,"CI3":25}
  CI marks: CI1=25, CI2=25, CI3=25
  Valid marks: [25,25,25]
  Calculated internal mark: 25