목록SQL (63)

Milky's note

[HackerRank](E) Draw The Triangle 1

https://www.hackerrank.com/challenges/draw-the-triangle-1/problem?isFullScreen=true Draw The Triangle 1 | HackerRank Draw the triangle pattern using asterisks. www.hackerrank.com [문제] P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): * * * * * * * * * * * * * * * Write a query to print the pattern P(20). [답] - mysql set @star=21; select repeat('* ', @star..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 26. 00:01
[HackerRank](M) The Report

https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com [문제] You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades conta..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 23:35
[HackerRank](E) Average Population of Each Continent

https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hackerrank.com [문제] Given the CITY and COUNTRY tables, query the names of all t..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 23:06
[HackerRank](E) African Cities

https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true&h_r=next-challenge&h_v=zen African Cities | HackerRank Query the names of all cities on the continent 'Africa'. www.hackerrank.com [문제] Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CI..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 25. 22:42
Prev 1 2 3 4 5 6 7 8 ··· 16 Next