CodingSpace

Problem. Revising Aggregations - The Sum Function Link. https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign Revising Aggregations - The Sum Function | HackerRank Query the total population of all cities for in the District of California. www.hackerrank.com Description. Query the total populatio..

Problem. Revising Aggregations - The Count Function Link. https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true Revising Aggregations - The Count Function | HackerRank Query the number of cities having populations larger than 100000. www.hackerrank.com Description. Query a count of the number of cities in CITY having a Population larger than 100..

Problem. Basic SELECT - Employee Salaries Link. https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com Description. Write a query that prints a list of employee names (i.e.: the name attribute) for e..

Problem. Basic Join - The Report Link. https://www.hackerrank.com/challenges/the-report/problem The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com Description. You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Ketty gives Eve a task to generate a report containing three col..

Problem. Basic Join - Average Population of Each Continent Link. https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=7-day-campaign Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hacke..

Problem. Basic Join - Population Census Link. https://www.hackerrank.com/challenges/asian-population/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=7-day-campaign The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com Description. Given the CITY and COUNTRY tables, query the sum of the populations of all citie..

Problem. Advanced Select - The PADS Link. https://www.hackerrank.com/challenges/the-pads/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com Description. Generate the following two result sets: Query an alphabetically ordered list of all names ..

Problem. Advanced Select - Type of Triangle Link. https://www.hackerrank.com/challenges/what-type-of-triangle/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com Description. Write a query identifying the type of each record in the TRIANGLES table using its t..