Hackerrank sql problem solving Hackerrank Problem solving solutions in Python. Each case study presents a real-world business scenario, and you are tasked with answering a series of questions using SQL queries. You signed out in another tab or window. - JawadSher/SQL-Problems-Solutions-HackerRank Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. We use cookies to Welcome to my collection of HackerRank SQL challenge solutions! š„· This repository showcases my optimized and efficient SQL queries for various problem-solving scenarios. Introduction. Status. ā I used the MySQL option on the platform to solve each of the challenges. I will initially outline the problem statements and then proceed to add their respective solutions. 15 Days of Learning SQL. So, in this free SQL exercises page, we'll cover a series of SQL practice exercises covering a wide range of topics suitable for beginners, intermediate, and advanced SQL learners. Please check 1. Mini-Max Sum Another way to solve this query is using the pivot function in T-SQL. SQL; Problem Solving Badges. Easy SQL (Basic) Max Score: Easy SQL (Intermediate) Max Score: 30 Success Rate: 94. This repository contains solutions to various SQL challenges and problems solved on HackerRank. Problem Solving (Basic) SQL (Basic) SQL (Intermediate) SQL (Advanced) Difficulty. Easy. 80. Ketty doesnāt want the NAMES of those students who received a grade lower than 8. Revising the Select Query I. here, we will see HackerRank SQL problems with solutions, let's dive into This article will help you in revising basic SQL queries and. Your result cannot contain duplicates. Solve Challenge You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Language Proficiency. Ask Question Asked 3 years, 11 months ago. Challenges | Medium | HackerRank Julia asked her students to create some coding challenges. Find and fix vulnerabilities Actions HackerRank Problem Solving SQL: MySQL Hi friends I was solving this hacker rank sql problem " Query the list of CITY names from STATION that do not start with vowels. com practice problems using Python 3, Š”++ and Oracle SQL - marinskiy/HackerrankPractice Hackerrank_SQL_solution. Customer Spending. 74%. Post displaying LeetCode sql problem solving questions and solution. Hackerrank ā Divisible Sum Pairs. Ok | Prepare; Certify; Compete Problem Solving (Basic) Get Certified. Welcome to the HackerRank Problem Solutions repository! This repository contains solutions to various HackerRank challenges that Iāve tackled, organized by problem categories and difficulty levels. For example, in problem Challenges (medium level), I would rephrase the task as: āWrite a query to print the hacker_id, Welcome to the HackerRank Solutions repository, where you can find comprehensive solutions to various HackerRank problems implemented in SQL. Link to HackerRank problem is here Download the dataset and solution for this problem from below: 0. with dat as ( select a. Whether you are a beginner or an experienced coder, this repository aims to provide clear and efficient solutions to help you improve your problem-solving skills. The SQL problem is taken from HackerRank. HackerRank is a platform for competitive coding. You want to rename a certain file on your computer. Medium SQL (Intermediate) Max Score: 30 Success Rate: 96. Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. LeetCode SQL Problem Solving Questions With Solutions. 56%. Join over 23 million developers in solving code challenges on HackerRank, SQL. This repository contains my SQL solutions to HackerRank challenges, organized by difficulty: Easy, Medium, and Hard. Problem. hackerrank-python hackerrank-solutions hackerrank-javascript hackerrank-30dayschallange hackerrank-sql hackerrank-statistics hackerrank-interview-kit hackerrank-certificates. Complex joins-This competency includes using INNER, LEFT, RIGHT, and FULL joins on multiple tables and using joins for many-to-many relationships. It is designed for experienced SQL professionals who want to validate their skills and advance their careers. Databases. Medium SQL (Intermediate) Max Score: 30 Success Rate: 97. Automated the process of adding solutions using Hackerrank Solution Crawler. New Companies. Skip to content. Note that all the nodes (in the tree) are already mentioned in the N column in the table. It serves as a record of my progress and showcases my understanding of SQL concepts and problem-solving skills. HackerRank SQL Problems Solved PART 1. I recently published a piece about how I cleared all HackerRank SQL challenges in two weeks. sql at master · Shounok/hackerrank Shounok/hackerrank-sql-solutions. Subdomains. The output column headers should be Doctor, Professor, Singer, and Actor, respectively. SQL Problem Solutions on HackerRank This repository contains my solutions to various SQL problems from HackerRank. 4 Star - Silver. 450. Learn about basic MySQL and My solutions to various HackerRank SQL problems using MySQL - shanuhalli/MySQL-Basics-to-HackerRank. Solutions to HackerRank practice, tutorials and interview preparation problems with Python, SQL, C# and JavaScript. It includes efficient SQL queries, problem-solving techniques, and well-documented scripts. 95%. But technical problem solving lies at the heart of programming, and most coding questions are designed to test a candidateās problem-solving abilities. SQL. In this video I am solving "Top Competitors" Problem on Hackerrank. The HackerRank Software Engineer Certification tests crucial skills like problem-solving, SQL, and REST APIs ā key abilities for junior software and backend developers. Easy SQL (Basic) Max Score: 10 Success Rate: 99. " and my solution was " Select Distinct CITY From STATION WHERE Hard SQL (Intermediate) Max Score: 50 Success Rate: 85. com/challenges/revising-the-select-query/problem?isFullScreen=trueProblem Name: Revising the Select Solutions to HackerRank / GeeksforGeeks / LeetCode Questions: C, C++, Python, Problem Solving, SQL, 30 Days of Code and much more (400+ problems) - afrozchakure It is an easy problem but boy oh boy it took me a bit to decipher what the Hackerrankās āThe Blunderā SQL problem. Solve SQL | HackerRank We use cookies to ensure you have the best browsing experience on our website. You switched accounts on another tab or window. This repository features solutions to various intermediate-level SQL challenges from HackerRank. However, because of a glitch, you can't rename it to whatever you want-you can only This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. 48%. github mysql sql certificate hackerrank hacker hackerrank-solutions hackerrank-challenges hackerrank-sql hackerrank-certificates hakerrank-problem-solving mysqlchallenges. Solutions to Certification of Problem Solving Basic on Hackerrank. Easy Problem Solving (Basic) Max Score: 5 Success Rate: 87. Stand out from the crowd. To get a certificate, two problems have to be solved within 90 minutes. Problem Solving, SQL, 30 Days of Code and much more (400+ problems) python sql leetcode cpp codechef competitive-programming hackerrank geeksforgeeks codeforces leetcode-solutions hacktoberfest hackerrank-solutions codewars-solutions hackerrank-algorithms-solutions hackerrank-challenges Review the problem statement Each challenge has a problem statement that includes sample inputs and outputs. Q. 65%. Modified 1 year, 3 months ago. Hackerrank SQL problem to solve in Oracle's SQL version. Binary Tree Nodes. You can earn points for this Badge by solving challenges in the Algorithms and Data Structures tracks. Commented Feb 13, 2024 at 7:36. We shall use recursive sql to solve the given problem. The OCCUPATIONS After digging in the Recursive Query was able to solve this problem. While solving all SQL problems from HackerRank, I came across multiple solutions for the same The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. The following is a list of possible problems per certificate. MIT license Activity. Info; Rules; Scoring; Info. GitHub is where people build software. So, if you have any suggestions or tips, Iād be thrilled to learn from you! In conclusion, I hope you enjoyed following my journey in solving this tricky HackerRank SQL problem. Add a description, image, and links to the hakerrank-problem-solving topic page so that developers can more easily learn about it. It is very important that you all first give it a try & brainstorm yourselves before having a Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Sign in Hacker Rank SQL Problem Solving: My solutions to various HackerRank SQL problems using MySQL. This is a medium SQL Problem. Draw The Triangle 2. We shall use recursive sql to solve the given proble This repository contains solutions to Hackerrank practice problems in SQL, C++, Java Python and Problem Solving (Data Structures and Algorithms). HackerRank SQL Problem Solving Questions With Solutions. ; If you are interested in adding more Hackerrank problem solutions, please feel free to contribute. 1. - kilian-hu/hackerrank-solutions My solutions to SQL problems on HackerRank # SQL Problems Page: https://www. Points Needed. Review the problem statement Each challenge has a problem statement that includes sample inputs and outputs. 02%. Each solution is accompanied by comments for clarity, showcasing various approaches and optimizations. Each solution is designed to demonstrate strong analytical and query-writing skills. - kilian-hu/hackerrank-solutions Hackerrank problem solving certificate question. Indexes. You can find me on hackerrank here. Solving problems is the core of computer science. BigNumber. This hard-level problem was the last one I finished, and it took me quite some time to figure out the solution. 3 Star - Silver. - naresy/Hacker-Rank-Basic-Skill-Student Sql one of the most important language asked in most of the analytics interviews, in this series i will be solving sql questions which are more relevant to q Problem Solving (Basic) Get Certified. Revising the Select Query I; 2. Easy SQL (Advanced) Max Score: 25 Success Rate: 96. Advanced Select. Preparation Kits View all kits. Database Normalization. *,h. It focuses on three main areas: In this course we will be solving problems on the Northwind and AdventureWorks2012 database, and also along with that we will also solve some HackerRank SQL challenges. Solved. 50%. 6: Binary Tree Nodes: Solution: We can write this query using simple case when statements. Programmers must first understand how a human solves a problem, then understand how to translate this "algorithm" into something a computer can do, and finally, how to write the specific code to implement the solution. Whether we are beginners or experienced professionals, practicing SQL exercises is important for improving your skills. Eventually, I decided to try taking the Problem Solving (Basic) certification exam from Hackerrank. Follow. In this video, we will learn how to solve a complex SQL query. - kilian-hu/hackerrank-solutions Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Published on November 5, 2020 · āāā views All my solutions to get 5 * (gold) badge in both SQL and Problem solving. Skip to Content Home SQL Bootcamp. Post displaying HackerRank sql problem solving questions and solution. Unsolved. This repository contains my SQL solutions to HackerRank challenges, organized by difficulty level: Easy, Medium, and Hard. Linux Shell. Blog You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Specialized Skills. This repository contains my solutions to the challenges, along with some explanations and any additional resources used. SQL (Basic) SQL (Intermediate) SQL (Advanced) Difficulty. November 5, 2020 · āāā views. Each solution is designed to demonstrate various SQL techniques I solved over 150 SQL problems on Leetcode and HackerRank, not including SQL puzzle books. Hard. zee. to. ) to finish all the 58 SQL challenges on the site, and I gained quite some insights from the journey (and having The SQL problem is taken from HackerRank. 83%. This is a Medium SQL Problem. In the past few days, I finally completed all the SQL questions on HackerRank. Starts in. Advanced Join. Solutions of more than 380 problems of Hackerrank across several domains. Harry Potter and his friends are at Ollivanderās with Ron, finally replacing Charlieās old broken wand. Below is the code for it. 2 of 6; Choose a language Select the language you wish to use to A: The HackerRank Advanced SQL Certification is a prestigious certification that demonstrates your ability to write complex SQL queries and solve challenging data problems. com/challenges/the-pads/problem?isFullScreen=trueProblem Name: The PADSDifficulty Level: MediumKey topics here:- Aggre Solutions to HackerRank practice, tutorials and interview preparation problems with Python, SQL, C# and JavaScript - nathan-abela/HackerRank-Solutions You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Specialized Skills. - The Ugly. Join over 11 million developers in solving code challenges on HackerRank, registered for the contest. Cracking the Problem Solving Questions: Insights from HackerRank's Certification Tests for Software Engineer Interns "Mastering Problem-Solving and SQL related Questions for a HackerRank Software This repository contains MySQL solutions of the HackerRank-SQL-Intermediate-Certificate problems which I encountered during the test. Regular practice helps you get better at using SQL and boosts your confidence in handling different database tasks. 650. Ask Question Asked 2 years, 4 months ago. Problem statement: From my experience, understanding the problem statement on HackerRank takes up to 75% of the time allotted for solving a medium- to hard-level problem. At its core, problem-solving focuses on the study, understanding, and usage of data structures and algorithms. ā Yunnosch. The repository dedicated to solutions for Hacker-rank Database problems, solved with MySQL - hackerrank-sql-solutions/The PADS. codechef spoj codeforces leetcode-solutions hackerrank-solutions hackerrank-java spoj-solutions leetcode-java codeforces-solutions codechef-solutions spoj-problems hackerrank-sql hackerrank-problem-solutions codeforces-problems hackerrank-problem-solving codeforces-solutions-github hackerrank-java-solutions spoj-solutions-java codeforces In this video I will tell How To Solve Questions On Hackerrank or How To Solve Problems On Hackerrank . SQL (Intermediate) SQL (Advanced) Difficulty. Basic Select. Reload to refresh your session. They are unnecessarily long, and the tasks could be clearer. You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Language Proficiency. higher grades are entered first. 66%. Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non About. 82%. We welcome contributions to enhance this collection of HackerRank 30 Days of Code solutions: Improve Existing Solutions: Optimize or clarify current solutions. The 8 Week SQL Challenge by Danny Ma is a series of case studies designed to help you improve your SQL skills. This is made slightly more complex because the question Easy SQL (Intermediate) Max Score: 30 Success Rate: 94. Write better code with AI Security. Rules. File Renaming - Problem Solving (Intermediate) | HackerRank File Renaming. 19. So here I am, three weeks later, writing this article sharing my experience and tips with you on what Iāve learned from the journey. But I think that any similar decent learning platform would do the same, SQL (Intermediate) SQL (Advanced) Difficulty. Sign in Product GitHub Copilot. Python (Basic) Get Certified. Regex. 94%. If you feel this repo is helpful for you, please do star it. sql and 2. - sayantani-dey/Solving-SQL-Problems-HackerRank---LeetCode Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. 2 Star - Bronze. In this short YouTube tutorial, I break down and solve a medium difficulty SQL problem on HackerRank. This competency area includes usage of hash maps, stacks, queues, heaps, and analyzing run-time complexities and space complexities, Join over 23 million developers in solving code challenges on HackerRank, š Solutions of more than 380 problems of Hackerrank accross several domains. Problem Solving SQL Table of Contents My solutions to SQL problems on HackerRank; 1. Problem solving. Business Expansion. The report must be in descending order by grade ā i. We use cookies to With a passion for problem-solving. Unions-This competency includes using unions to display multiple sets of information In this playlist, we are going to solve all the HackerRank SQL problems. Easy SQL (Advanced) Max Score: 25 Success Rate: 97. Once again, Iām thrilled to join you on another exciting journey to tackle an intriguing problem, this time with T-SQL. Here are a few examples of technical problem-solving questions: 1. Please add a description of the effect of what you propose and explain why it helps to solve the problem. Courses. 1 Star - Bronze. No responses yet. Problem Solving - Badge Level. These solutions are implemented in multiple programming languages to showcase different approaches and techniques for solving common coding problems. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. ; Improve Problem Solving (Intermediate) Difficulty. Contribute to astopaal/parallelProcessing development by creating an account on GitHub. This collection serves as a useful resource for improving SQL skills and problem-solving techniques. Strings. To solve this āblunderā we have to write a query calculating A collection of solutions to competitive programming exercises on HackerRank. Parallel Processing - Problem Solving (Basic) certification | HackerRank Solution in Python: Labels : #hackerrank,#hackerrank certification,#problem solving,#problem solving (Basic),#python, Copy. 5 Star - Gold. SQL (Basic) Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. The goal of this repository is to demonstrate problem-solving skills, proficiency in SQL, and understanding of database concepts. I hope You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Language Proficiency. Some challenges include additional information to help you out. Post a Comment Post a Comment Want to A collection of solutions to competitive programming exercises on HackerRank. These exercises are designed to In this post, Iāll share my solutions to some SQL problems on HackerRank, categorized as āEasy. Skills. Set and Algebra. Data Structures. Join over 23 million developers in solving code challenges on HackerRank With a passion for problem-solving. Write a query to print the hacker_id, name, and the total number of challenges created by each student. 92%. The goal of this repository is to document and share SQL queries that I have I have tried to provide the complete solution with possible explanation to all SQL Practice problem on HackerRank. Readme License. Revising the Select Query II. Input Format. There are 58 free SQL questions on HackerRank and 100 on Leetcode, including 50 free of charge and 50 problems for In this post, we will be covering all the solutions to SQL on the HackerRank platform. The STATION table is described as This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. Hard SQL (Advanced) Max Score: 50 Success Rate: 78. This 75-minute exam, shaped by feedback from 2,000 corporate partners, aligns closely with the demands of real-world jobs [1]. It was a fun ride, and thereās no reason not to ride on the momentum and brush up my Python skills. Object Oriented Programming. A Very Big Sum. - ashraf789/Hackerrank-problem-solving. Interview preparation kit, 30 days of code, data structures, coding interview, problem solving, Add a description, image, and links to the hackerrank-sql-problems topic page so that developers can more easily learn about it. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to Solution ā Japanese Citiesā Names in SQL SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN"; Description: The above Problem (Japanese Citiesā Names) is generated by Hacker Rank but the Solution is Provided by Easy Problem Solving (Basic) Max Score: 10 Success Rate: 95. Works in real-time and it's absolutely undetectable š You're applying for a new job and have a coding problem coming up. Relational Algebra. 2 of 6; Choose a language Select the language you wish to use to This repository contains my solutions to various SQL problems on HackerRank. OLAP. Basic Join. SQL; Sql - Badge Level. However, in the above query I have tried sticking to using standard SQL. HackerRank SQL Problems and Solutions ā2. We will mostly work on understanding of the problem statement and the way of thinking Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Watch the entire video to know more about "SQL Problem. name from ( select submission_date,min(hacker_id) mn from ( select submission_date,hacker_id,cnt, rank() over ( partition by submission_date order by submission_date asc, cnt desc) rn from ( select submission_date,hacker_id,count(distinct Problem solving itself might at first seem like itās taking a back seat. If there is more than one student with the same grade (8-10) assigned to them, order those particular Starting today, Iām starting to solve HackerRank SQL exercises, and Iām excited to share how I do it with you! HackerRank SQL Problems and Solutions ā 1. The CITY table is described as Current projects at work require more SQL skills, so I took the time to brush up my SQL knowledge using the HackerRank coding challenges platform. 99%. ; Add Explanations: Provide detailed explanations of code and problem-solving approaches. Try for How to Answer and consider taking the tour please. But I'm a bit biased, I completed HR SQL path some 5 years ago and it really helped me solidify solving SQL problems using the stuff I learned at the time. A collection of solutions to competitive programming exercises on HackerRank. Viewed 6k times 0 . Curate this topic Add Problem Solving (Basic) Difficulty. Published on November 4, Easy SQL (Advanced) Max Score: 25 Success Rate: 96. This course is meant for all levels, so whether you are a beginner, intermediate or solutions to various problem solving (programming) exercises - yaru22/problem-solving In this lecture, 'SQL Queries - HackerRank Problem Solving' from "Master SQL Series" is covered by Arpit Jain. HackerRank offers an extensive collection of SQL problems, and we will solve them one by one. CodeRankGPT helps you solve HackerRank coding problems during your coding interview. wordp Weather Observation Station 1 Hackerrank Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Nerves can peak during the programming test, and even experienced developers might blank SQL (Structured Query Language) is a powerful tool used for managing and manipulating relational databases. Each solution is written in MySQL and includes detailed comments to explain the logic and approach used to solve the problem. 300. Sep 16, 2024. This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. Top Competitors. ali0806/HackerRank-SQL-Problem-Solve. Navigation Menu Toggle navigation. Select by ID; 5. C++; Java; Python; Specialized Skills. Solve Challenge. _____ SUBSCRIBE!Do yo Sql one of the most important language asked in most of the analytics interviews, in this series i will be solving sql questions from hackerrank, hackerearth. More from Sonali jain. Medium SQL (Intermediate) Max Score: 20 Success Rate: 96. Alternative Queries. These solutions can The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. Sweet, we've sent you an email confirming your registration! You can tell your friends about SQL Tweet it Share it Practice You might like to solve practice problems on HackerRank. The exam had 2 coding test problems that had to be completed within 90 minutes. Easy Problem Solving (Basic) Max Score: 10 Success Rate: 98. Oh, but thereās a twist! Solving a Tricky HackerRank SQL Problem ā Combining Queries with This video is solving the "Contest Leaderboard" Problem on Hackerrank. Please read our cookie policy for more information about how we use cookies. Weather Observation Station 4 | Easy | HackerRank Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. 175. Easy Problem Solving (Intermediate) Max Score: 5 Success Rate: 96. Each solution includes a brief explanation of the problem and my approach to solving it. Basics of Sets and Relations #2. mysql sql solutions hackerrank problem-solving hackerrank-solutions hackerrank-challenges hackerrank-sql hackerrank-sql-solutions mysql-environment sql-challenges Resources. Functional Programming. We use cookies to ensure you have the best browsing experience on our website. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Select By ID. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects. e. 170+ solutions to Hackerrank. This video is for beginners who is starting their jou I admit, it took some clever thinking to solve this puzzle, and Iām sure there are other fantastic ways to approach it using SQL. Problem Link: https://www. Whether you're a beginner or an experienced developer, you'll find solutions and explanations for everything from basic queries to advanced data manipulation. This video will help you to improve your coding skills in SQL_____ Weather Observation Station 1 Hackerrank Solution SQL*****If You want code click here: https://realnamehiddenin. Problem 1. 2 of 6; Choose a language Select the language you wish to use to In this video, we will be solving SQL problems on Hackerrank. Medium. Basic Select; Aggregation You can earn the following badges by solving challenges on HackerRank : Problem Solving (Algorithms and Data Structures) Specialized Skills. Problem Solving (Basic) Active Traders; Balanced System Files Partition; Longest Subarray; Maximum Cost of Laptop Count; Nearly Similar Rectangles Problem Link: https://www. Sep 15, 2024. . 03%. It took me a bit more than two weeks (on and off between work, workout, and taking the kid to day school, etc. Write a 40s-50s short story about a man who gets aliens to solve problems Is it Solve Me First - HackerRankhttps://www. Throughout this blog post, weāll explore why problem-solving skills are so critical for software engineers, delve into the techniques they use to address complex challenges, and discuss how hiring Hackerrank is garbage for practicing SQL. Select all; 4. View on GitHub Hackerrank. Easy SQL (Intermediate) Max Score: 30 Success Rate: 94. Aggregation. Note: Print NULL when there are no more names corresponding to an occupation. com/challenges/solve-me-first/problemFollow me on Social Media Hackerrank Problem solving solutions in Python. NoSQL - XML, MapReduce. Find and fix You signed in with another tab or window. hackerrank. Welcome to the HackerRank SQL Problems repository! This collection features a variety of SQL challenges from HackerRank, designed to help you sharpen your SQL skills. ; Multiple Language Implementations: Add solutions in other programming languages. sql files for the solutions I submitted! This repository is a collection of solved SQL problems from coding platforms. Revising the Select Query II; 3. 15%. Hard SQL (Intermediate) Max Score: 50 Success Rate: 85. In this version I am solving the problem with a Subquery Type of triangle problem of hackerrank SQl Advance select. Easy SQL (Basic) Max Score: 10 Success Rate: 95.