분류 전체보기350

• [TIL] 20230226 (일) 오늘 한 것 토스 오랜만에 레스투 친구들을 만났다 ㅎㅎ 총 공부시간 04시간 50분 56초 복습 및 회고/TIL 2023. 2. 26.

• [TIL] 20230225 (일) 오늘 공부한 것 토스 총 공부시간 05시간 14분 36초 복습 및 회고/TIL 2023. 2. 25.

• [TIL] 20220223 (목) 오늘 공부 한 것 1. 토익스피킹 part5, 모고 1회 2. 경영학 3. 데산진 지원서 작성 총 공부시간 09시간 28분 18초 복습 및 회고/TIL 2023. 2. 23.

• [해커랭크/SQL] 20. Employee Salaries 👉 https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com 🤔 문제 분석 1) Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater tha.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 19. Employee Names 👉 https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Employee Names | HackerRank Print employee names. www.hackerrank.com 🤔 문제 분석 1) 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 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [해커랭크/SQL] 18. Higher Than 75 Marks 👉 https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true Higher Than 75 Marks | HackerRank Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name. www.hackerrank.com 🤔 문제 분석 1) Query the Name of any student in STUDENTS who scored higher than Marks. 2) Order your output by the last three characters of each na.. 코딩테스트/해커랭크 SQL 2023. 2. 22.

• [TIL] 20230222 (수) 1. 토익스피킹 part 3 2. SQL - 사용자정의 함수 인강 듣기 및 리트코드 문제풀이 - 해커랭크 3문제 풀기 3. 데산진 자소서 작성 총 공부시간 8시간 10분 48초 복습 및 회고/TIL 2023. 2. 22.

• [TIL] 20230221 (화) 오늘 공부한 것 1. 토익스피킹 뿌시기 2. SQL - 해커랭크 3문제 풀기 - 윈도우 함수 인강 듣기, 관련 리트코드 3문제 풀이 - 정규표현식 인강 듣기 및 관련 문제 풀이 총 공부시간 09시간 19분 25초 복습 및 회고/TIL 2023. 2. 21.

• [해커랭크/SQL] 17. Weather Observation Station 12 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that do not start with vowels and do not en.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 16. Weather Observation Station 11 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 🤔 문제 분석 1) Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. 2) Your result cannot contain d.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [해커랭크/SQL] 15. Weather Observation Station 10 (REGEXP) 👉 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com 🤔 문제 분석 1) 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 CITY REGEXP "[^a|e|i|o|.. 코딩테스트/해커랭크 SQL 2023. 2. 21.

• [TIL] 20230220 (월) 오늘 공부한 것 1. 토익스피킹 2. SQL 해커랭크 3문제 풀기 공부시간 04시간 12분 06초 복습 및 회고/TIL 2023. 2. 20.