Draw The Triangle1, 2

문제 풀이 링크1: https://www.hackerrank.com/challenges/draw-the-triangle-1/problem?isFullScreen=true

Draw The Triangle 1 | HackerRank

문제 풀이 링크2: https://www.hackerrank.com/challenges/draw-the-triangle-2/problem?isFullScreen=true

Draw The Triangle 2 | HackerRank

---

 

1. 1개부터 20개까지 출력

WITH RECURSIVE numbers AS (
  SELECT 1 AS n
  UNION ALL
  SELECT n + 1 FROM numbers WHERE n < 20
)
SELECT REPEAT('* ', n) AS pattern
FROM numbers;

2. 20개부터 1개까지 역순으로 출력

WITH RECURSIVE numbers AS (
  SELECT 20 AS n
  UNION ALL
  SELECT n - 1 FROM numbers WHERE n > 1
)
SELECT REPEAT('* ', n) AS pattern
FROM numbers;