REST API: IP Tracker
A REST API contains information about IP addresses. Given an IP address, make a fetch call to the REST API to fetch…
Youngest Employee
There are two data tables with employee information: EMPLOYEE and EMPLOYEE_UIN. Query the tables to generate a list of all employees who are less…
Conference Schedule
A schedule has just been released for an upcoming tech conference. The schedule provides the start and end times of each of…
REST API: Products in Range
A REST API contains information about items in an inventory. Given the product category, minimum price, and maximum price parameters, the goal…
REST API: Patient’s Medical Record
A REST API contains patients’ medical records. Given a patient id, fetch all the records for the patient and return their average…
Largest Number of Orders
A company maintains information about its orders in table called ORDERS. Write a query to find the CUSTOMER_ID of the customer who has placed the…
Hackerrank CertificationNerdyProblem Solving - BasicProblem Solving - IntermediateSoftware Engineer Role
Efficient Janitor
The janitor of a high school is extremely efficient. By the end of each day, all of the school’s waste is in…