Here are the 4 questions asked in HackerRank SQL Basic Certification Exam, from these 2 will be available in one attempt.
Student analysis SQL solution-
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;
Country codes SQL solution
FROM customers as a
LEFT join country_codes as b
ORDER BY a.customer_id;
Student Advisor SQL solution in MYSQL
SELECT roll_number,name FROM student_information a INNER JOIN faculty_information b ON a.advisor = b.employee_ID WHERE (b.gender = 'M' and b.salary>15000) or (b.gender = 'F' and b.salary>20000);
Profitable Stocks SQL solution in MYSQL
FROM price_today a
INNER JOIN price_tomorrow b
ON a.stock_code = b.stock_code
ORDER BY stock_code asc;
SELECT ei.employee_ID, ei.name FROM employee_information ei JOIN last_quarter_bonus b ON b.employee_ID = ei.employee_ID WHERE ei.division LIKE 'HR' AND b.bonus >= 5000;
The solution of HackerRank SQL Basic Certification problem student analysis and country code is shared for your increasing knowledge. Please don’t copy the the code . You can use the code to make your understand clear.