www.hackerrank.com/challenges/weather-observation-station-19/problem Weather Observation Station 19 | HackerRank Query the Euclidean Distance between two points and round to 4 decimal digits. www.hackerrank.com Answer select round(sqrt(power(max(lat_n) - min(lat_n),2) + power(max(long_w) - min(long_w),2)),4) from station www.hackerrank.com/challenges/weather-observation-station-20/problem Weathe..

www.hackerrank.com/challenges/weather-observation-station-17/problem Weather Observation Station 17 | HackerRank Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places. www.hackerrank.com Answer select round(long_w,4) from station where lat_n > 38.7780 order by lat_n limit 1 www.hackerrank.com/challenges/weather-..

www.hackerrank.com/challenges/weather-observation-station-15/problem Weather Observation Station 15 | HackerRank Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places. www.hackerrank.com Answer select round(long_w,4) from station where LAT_N < 137.2345 order by lat_n desc limit 1 www.hackerrank.com/challenges/weather-observation-station-16/prob..

www.hackerrank.com/challenges/weather-observation-station-13/problem Weather Observation Station 13 | HackerRank Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places. www.hackerrank.com Answer select Truncate(sum(lat_n),4) #Truncate your answer to 4 decimal places. from station where LAT_N between 38.7890 and 137.2345; www.h..

www.hackerrank.com/challenges/earnings-of-employees/problem Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com We define an employee's total earnings to be their monthly worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employe..

www.hackerrank.com/challenges/the-blunder/problem The Blunder | HackerRank Query the amount of error in Sam's result, rounded up to the next integer. www.hackerrank.com Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation. She wants your help finding t..

www.hackerrank.com/challenges/the-company/problem New Companies | HackerRank Find total number of employees. www.hackerrank.com 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 n..

www.hackerrank.com/challenges/binary-search-tree-1/problem Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Write a query to find the node type of Binary Tree ordered by the valu..

www.hackerrank.com/challenges/occupations/problem Occupations | HackerRank Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. www.hackerrank.com Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doct..

www.hackerrank.com/challenges/the-pads/problem The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com 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: AnAct..