CodeChef
Search results
Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Solve SQL | HackerRank We use cookies to ensure you have the best browsing experience on our website.
The HackerRank Skills Certification Test is a standardized assessment to help developers prove their coding skills. Get noticed by companies Candidates who successfully clear the test will be specially highlighted to companies when they apply to relevant roles.
SQL. These concepts cover the fundamental syntax and basic features of SQL. They are necessary for writing simple SQL queries and understanding the core structure and flow of database operations. Activities involved: Setting up a database environment and understanding SQL’s purpose and use cases. Reason: Fundamental setup and understanding ...
A participant's total score is the sum of the scores earned for each problem attempted. If you submitted more than one solution for a problem, only your highest score achieved will be used in this calculation. Participants are ranked by score, with the cumulative time taken (between the contest's start time and the time of your correct ...
Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
New Companies. Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees.
The PADS. Problem. Submissions. Leaderboard. Discussions. Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses). For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ...
Hackerrank / SQL(Basic) / Profitable Stocks.sql. Top. File metadata and controls. Code. Blame. 7 lines (7 ...
Solve Challenge. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
The Report. You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8.
