Welcome to my repository of SQL solutions for all the challenges on HackerRank. This repository contains a comprehensive set of SQL queries for every problem I've solved on the platform, categorized ...
The following challenges all revolve around simple SELECT statements that make use of SELECT, FROM, WHERE, and ORDER BY. The WHERE clauses will use and three basic boolean operators as well as some of ...
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 ...