Milky's note

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..

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;..

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..

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..