목록전체 글 (129)

Milky's note

[HackerRank](E) Draw The Triangle 2

https://www.hackerrank.com/challenges/draw-the-triangle-2/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Draw The Triangle 2 | 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=0;..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 26. 00:06
[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
Prev 1 ··· 13 14 15 16 17 18 19 ··· 33 Next