데이터 분석 공부

SQL Project Planning SQL Project Planning | HackerRank Write a query to output the start and end dates of projects listed by the number of days it took to complete the project in ascending order. www.hackerrank.com # Problem You are given a table, Projects, containing three columns: Task_ID, Start_Date and End_Date. It is guaranteed that the difference between the End_Date and the Start_Date is ..

Ollivander's Inventory 문제에 대한 자세한 내용은 다음 링크에서 확인하실 수 있습니다 Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com # Problem Harry Potter and his friends are at Ollivander's with Ron, finally replacing Charlie's old broken wand. Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non-evil wand of high power ..

Challenges Challenges | HackerRank Print the total number of challenges created by hackers. www.hackerrank.com # Problem Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same..

Placements Placements | HackerRank Write a query to output the names of those students whose best friends got offered a higher salary than them. www.hackerrank.com # Problem 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 Salar..

The Report The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com # Problem You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the N..

1. The Blunder 2. Population Census 3. African Cities 4. Higher Than 75 Marks HackerRank HackerRank is the market-leading technical assessment and remote interview solution for hiring developers. Learn how to hire technical talent from anywhere! www.hackerrank.com 1. The Blunder 조건 1) salary 값의 평균에서 잘못 계산한 salary의 평균 빼기 조건 2) 올림으로 계산하기 SELECT CEIL(AVG(salary) - AVG(REGEXP_REPLACE(salary, '[0]', ..

1. Employee Names 2. Employee Salaries 3. Revising Aggregations - The Sum Function 4. Revising Aggregations - The Count Function 5. Revising Aggregations - Averages HackerRank HackerRank is the market-leading technical assessment and remote interview solution for hiring developers. Learn how to hire technical talent from anywhere! www.hackerrank.com 1. Employee Names SELECT name FROM employee OR..

1. Revising the Select Query 1 2. Revising the Select Query 2 3. Select All 4. Select By ID 5. Average Population 6. Population Density Difference 7. Japan Population 8. Japanese Cities’ Names 9. Japanese Cities’ Attributes HackerRank HackerRank is the market-leading technical assessment and remote interview solution for hiring developers. Learn how to hire technical talent from anywhere! www.ha..

프로그래머스 SQL 고득점 Kit를 풀어봤습니다. https://programmers.co.kr/learn/challenges?tab=sql_practice_kit 코딩테스트 연습 기초부터 차근차근, 직접 코드를 작성해 보세요. programmers.co.kr SELECT 모든 레코드 조회하기 SELECT * from animal_ins order by animal_id; 역순 정렬하기 SELECT name, datetime from animal_ins order by animal_id desc; 아픈 동물 찾기 SELECT animal_id ,name from animal_ins where intake_condition = 'sick' order by animal_id; 어린 동물 찾기 SELECT a..