The Student Analysis SQL problem is a question presented in the HackerRank Basic SQL Certification exam.

Full HackerRank SQL Basic Certification Solution Video

Student Analysis SQL solution in SQL

SELECT a.roll_number,
FROM student_information a
INNER JOIN examination_marks b
ON a.roll_number = b.roll_number
GROUP BY b.roll_number
HAVING SUM(b.subject_one + b.subject_two + b.subject_three) < 100;

This is one question solution to the HackerRank SQL Basic Certification problem and this is shared for your increasing knowledge.

Here’s GitHub Repo:

Categorized in: