본문 바로가기
728x90
반응형

전체 글 보기164

[Node.js]간단한 예제 실행 1. Visual Studio Code를 이용해서 간단한 코드 작성 작업할 폴더 생성 -> hello.js 파일 생성 // Load HTTP module var http = require("http"); // Create HTTP server and listen on port 8000 for requests http.createServer(function(request, response) { // Set the response HTTP header with HTTP status and Content type response.writeHead(200, {'Content-Type': 'text/plain'}); // Send the response body "Hello World" response.end('.. 2021. 2. 16.
[Node.js]Node.js 설치 및 확인 1. Node.js 다운로드 및 설치 ( 특별히 변경할 것 x ) https://nodejs.org/ko/download/ 다운로드 | Node.js Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine. nodejs.org 2. 설치 확인 cmd 창에서 다음으로 확인 2021. 2. 16.
Type of Triangle Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with 3 sides of equal length. 정삼각형 Isosceles: It's a triangle with 2 sides of equal length. 이등변 삼각형 Scalene: It's a triangle with 3 sides of differing lengths. 그냥 삼각형 Not A Triangle: The given valu.. 2020. 6. 19.
Employee Salaries 문제 : Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than 2000 per month who have been employees for less than months. Sort your result by ascending employee_id. SELECT name FROM Employee WHERE months 2000 ORDER BY employee_id asc; Rose Patrick Lisa Amy Pamela Jennifer Julia Kevin Paul Donna Michell.. 2020. 6. 19.
Employee Names 문제 : Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. SELECT name FROM Employee ORDER BY name asc; 2020. 6. 19.
Higher Than 75 Marks 문제 : Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID. SELECT Name FROM STUDENTS WHERE Marks > 75 ORDER BY RIGHT(NAME, 3), ID ASC; Stuart Kristeen Christene Amina Aamina.. 2020. 6. 19.
HackerRank_18. Weather Observation Station 12 문제 : Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) NOT IN ('a', 'e', 'i', 'o', 'u') AND SUBSTR(CITY, -1, 1) NOT IN ('a', 'e', 'i', 'o', 'u'); Baker Baldwin Bass Harbor Beaufort Beaver Island Benedict Bennington Berryton Beverly Bison Blue River B.. 2020. 6. 12.
HackerRank_17. Weather Observation Station 11 문제 : Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) NOT IN ('a', 'e', 'i', 'o', 'u') OR SUBSTR(CITY, -1, 1) NOT IN ('a', 'e', 'i', 'o', 'u'); Kissee Mills Loma Mar Sandy Hook Tipton Arlington Turner Slidell Negreet Glencoe Chelsea Chignik La.. 2020. 6. 12.
HackerRank_16. Weather Observation Station 10 문제 : Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, -1, 1) NOT IN ('a', 'e', 'i', 'o', 'u'); Kissee Mills Loma Mar Sandy Hook Tipton Arlington Turner Slidell Negreet Chignik Lagoon Hanna City Albany Monument Manchester Prescott Graettinger Sturgis Highwood Bowdon Tyler Watkins Repu.. 2020. 6. 12.
HackerRank_15. Weather Observation Station 9 문제 : Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) NOT IN ('a', 'e', 'i', 'o', 'u'); Kissee Mills Loma Mar Sandy Hook Tipton Turner Slidell Negreet Glencoe Chelsea Chignik Lagoon Pelahatchie Hanna City Dorrance Monument Manchester Prescott Graettinger Cahone Sturgis Highwo.. 2020. 6. 11.
728x90
반응형

티스토리툴바