목록SQL/SQL 코딩 테스트-HackerRank (52)

Milky's note

[HackerRank](M) New Companies

https://www.hackerrank.com/challenges/the-company/problem?isFullScreen=true 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 num..
SQL/SQL 코딩 테스트-HackerRank 2022. 3. 28. 17:09
[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
Prev 1 2 3 4 5 6 ··· 13 Next