일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
- 설명의무
- 코딩테스트
- 자연어처리
- update
- 논문리뷰
- NLP
- GRU
- HackerRank
- 자연어 논문
- 짝수
- SQL코테
- 자연어 논문 리뷰
- 표준편차
- CASE
- Statistics
- Window Function
- nlp논문
- leetcode
- MySQL
- t분포
- 카이제곱분포
- sql
- inner join
- 서브쿼리
- SQL 날짜 데이터
- airflow
- LSTM
- sigmoid
- 그룹바이
- torch
- Today
- Total
목록전체 글 (108)
HAZEL
627. Swap Salary >> 문제 +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | | sex | ENUM | | salary | int | +-------------+----------+ id is the primary key for this table. The sex column is ENUM value of type ('m', 'f'). The table contains information about an employee. Write an SQL query to swap all 'f' and 'm' values (i.e., change all 'f..
Binary Tree Nodes >> 문제 You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Write a query to find the node type of Binary Tree ordered by the value of the node. Output one of the following for each node: Root: If node is root node. Leaf: If node is leaf node. Inner: If node is neither root nor leaf node. Sa..
Placements >> 문제 You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID (ID of the ONLY best friend). Packages contains two columns: ID and Salary (offered salary in $ thousands per month). Write a query to output the names of those students whose best friends got offered a higher salary than them. Na..
1] Weather Observation Station 3 >> 문제 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. >> 문제 푼 코드 SELECT distinct city FROM STATION WHERE id % 2 = 0 www.hackerrank.com/challenge..
Top Competitors >> 문제 Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than one challenge. Order your output in descending order by the total number of challenges in which the hacker earned a full score. If more than one hacker received full sc..
1] Population Density Difference >> 문제 Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: >> 문제 푼 코드 select max(population) - min(population) from city www.hackerrank.com/challenges/population-density-difference/problem Population Density Difference | HackerRank Query the difference between the maximum and minimum city p..
New Companies >> 문제 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 number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code. Note: The tab..
1] Japan Population >> 문제 Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. Input Format The CITY table is described as follows: >> 문제해결 코드 SELECT SUM(POPULATION) from CITY WHERE COUNTRYCODE = 'JPN' www.hackerrank.com/challenges/japan-population/problem Japan Population | HackerRank Query to the sum of the populations of all Japanese cities in CI..
1] 182. Duplicate Emails >> 문제 Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+ For example, your query should return the following for the above table: +---------+ | Email | +---------+ | a@b.com | +---------+ >> 문제 해결 코드 select Email from person group by Emai..
1] 595. Big Countries >> 문제 There is a table World +-----------------+------------+------------+--------------+---------------+ | name | continent | area | population | gdp | +-----------------+------------+------------+--------------+---------------+ | Afghanistan | Asia | 652230 | 25500100 | 20343000 | | Albania | Europe | 28748 | 2831741 | 12960000 | | Algeria | Africa | 2381741 | 37100000 | ..