dark

# HackerRank SQL Basic Certification Solutions – FREE SQL Certification

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

``SELECT a.customer_id,a.name,concat("+",b.country_code,a.phone_number)FROM customers as aLEFT join country_codes as b ON a.country=b.countryORDER BY a.customer_id;``

## Student Advisor SQL solution in MYSQL

``````SELECT roll_number,name
FROM student_information a
INNER JOIN faculty_information b
WHERE (b.gender = 'M' and b.salary>15000) or (b.gender = 'F' and b.salary>20000);``````

## Profitable Stocks SQL solution in MYSQL

``SELECT a.stock_codeFROM price_today aINNER JOIN price_tomorrow bON a.stock_code = b.stock_codeWHERE b.price>a.priceORDER BY stock_code asc;``

## Merit Rewards

``````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.

## Student Analysis SQL HackerRank Solution

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

## HackerRank Python Basic Certification Solutions – FREE SQL Certification

Here are the 2 questions asked in HackerRank Python Basic Certification Exam, these 2 will be available in…

## HackerRank SQL Intermediate Certification Solutions – FREE SQL Certification

Here are the 2 questions asked in HackerRank SQL Intermediate Certification Exam, these 2 will be available in…