All Problems
57

Students with All Subjects

MediumJOINCOUNTHAVING

Problem Description

Write a SQL query to find students who have marks in exactly 3 subjects.

Expected Columns

  • student_name
  • subject_count

Example Output

| student_name | subject_count | |--------------|---------------| | Ishaan Malhotra | 3 | | Tanya Bose | 3 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#57 Students with All Subjects
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results