Subject Pass Rate

Write a SQL query to calculate pass rate (marks >= 70) for each subject.

Expected Columns

• subject_name
• total_students
• passed
• pass_rate

Example Output

| subject_name | total_students | passed | pass_rate | |--------------|----------------|--------|-----------| | Mathematics | 15 | 14 | 93.33 | | Physics | 10 | 8 | 80.0 | | ... | ... | ... | ... |