The Student Analysis SQL problem is a question presented in the HackerRank Basic SQL Certification exam.
Student Analysis SQL solution in SQL
SELECT a.roll_number,a.name
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: https://github.com/adminazhar/hackerrank-SQL-basic-skills-certification-test-solution