본문 바로가기

SQL

(5)
[SQL] [Codewars] 6Kyu - SELECT prime numbers Codewars: Achieve mastery through coding challenge Codewars is a coding practice site for all programmers where you can learn various programming languages. Join the community and improve your skills in many languages! www.codewars.com 문제 Write a SELECT query which will return all prime numbers smaller than 100 in ascending order. Your query should return one column named prime. 코드 CREATE OR REP..
[SQL] [Codewars] 7kyu - Simple Fun #74: Growing Plant Codewars: Achieve mastery through coding challenge Codewars is a coding practice site for all programmers where you can learn various programming languages. Join the community and improve your skills in many languages! www.codewars.com 문제 Task Each day a plant is growing by upSpeed meters. Each night that plant's height decreases by downSpeed meters due to the lack of sun heat. Initially, plant ..
[SQL] [Codewars] 7Kyu - SQL with LOTR: Elven Wildcards Codewars: Achieve mastery through coding challenge Codewars is a coding practice site for all programmers where you can learn various programming languages. Join the community and improve your skills in many languages! www.codewars.com 문제 Deep within the fair realm of Lothlórien, you have been asked to create a shortlist of candidates for a recently vacated position on the council. Of so many wo..
[SQL] [Codewars] 7Kyu - Countries Capitals for Trivia Night (SQL for Beginners #6) Codewars: Achieve mastery through coding challenge Codewars is a coding practice site for all programmers where you can learn various programming languages. Join the community and improve your skills in many languages! www.codewars.com 문제 Your friends told you that if you keep coding on your computer, you are going to hurt your eyes. They suggested that you go with them to trivia night at the lo..
[SQL] [Codewars] 7Kyu - Hello SQL World! Codewars: Achieve mastery through challenge Codewars is where developers achieve code mastery through challenge. Train on kata in the dojo and reach your highest potential. www.codewars.com 문제 Hello SQL! Return a table with a single column named Greeting with the phrase 'hello world!' 코드 SELECT 'hello world!' as "Greeting" 설명 SQL에서 문자열을 출력하는데 SELECT를 사용할 수 있다. 출력할 문자열은 작은따옴표로 묶어줘야 한다. 또한, SQL에서 ..