https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true The Report | HackerRankWrite a query to generate a report containing three columns: Name, Grade and Mark.www.hackerrank.com SELECT CASE WHEN b.Grade >= 8 THEN a.Name ELSE NULL END AS Name, b.Grade, a.MarksFROM Students aJOIN Grades b ON a.Marks BETWEEN b.Min_Mark AND b.Max_MarkORDER BY b...

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true Weather Observation Station 5 | HackerRankWrite a query to print the shortest and longest length city name along with the length of the city names.www.hackerrank.com SELECT CITY, LENGTH(CITY) FROM STATIONORDER BY LENGTH(CITY) ASC, CITYLIMIT 1)UNION( SELECT CITY, LENGTH(CITY)FROM STATIONOR..

1.이커머스(E-commerce)란인터넷과 디지털 기술을 활용해 상품이나 서비스의 거래(판매,구매,결제,배송)가 이루어지는 모든 활동을 말합니다.즉, 오프라인 상점에서 일어나는 상거래를 온라인 공간으로 옮겨온 것입니다.2.이커머스의 특징온라인 기반 : 장소에 구애받지 않고 웹/앱을 통해 거래가 이루어집니다실시간 거래 : 주문, 결제, 재고 확인이 실시간으로 가능합니다.데이터 중심 : 고객 행동 데이터(클릭, 조회, 장바구니, 결제)를 분석하여 마케팅과 운영에 활용합니다규모의 확장성 : 오프라인 매장 대비 훨씬 넓은 시장으로 글로벌 진출에 용이합니다.3.이커머스의 거래 유형: B2C, C2C, B2B, D2C유형full name거래 주체예시B2CBusiness to Consumer기업 → 개인쿠팡, G마켓..

https://www.hackerrank.com/challenges/placements/problem?isFullScreen=true Placements | HackerRankWrite a query to output the names of those students whose best friends got offered a higher salary than them.www.hackerrank.comSELECT S.NameFROM Students AS S LEFT JOIN Friends AS F ON S.ID=F.ID LEFT JOIN Packages AS P ON S.ID = P.ID LEFT JOIN Packages AS P_F ON F.Friend_ID = P_F.IDWHERE P_F.S..

https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true Weather Observation Station 20 | HackerRankQuery the median of Northern Latitudes in STATION and round to 4 decimal places.www.hackerrank.comSELECT ROUND(AVG(T1.LAT_N), 4)FROM ( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N ASC) AS row_asc, ROW_NUMBER() OVER (ORDER BY LAT_N DES..

New Companies | HackerRank New Companies | HackerRankFind total number of employees.www.hackerrank.comSELECT C.company_code, C.founder, COUNT(DISTINCT LM.lead_manager_code) AS total_lead_managers, COUNT(DISTINCT SM.senior_manager_code) AS total_senior_managers, COUNT(DISTINCT M.manager_code) AS total_managers, COUNT(DISTINCT E.employee_code) AS total_employeesFROM Company AS..

https://www.hackerrank.com/challenges/weather-observation-station-19/problem?isFullScreen=true Weather Observation Station 19 | HackerRankQuery the Euclidean Distance between two points and round to 4 decimal digits.www.hackerrank.comSELECT ROUND( SQRT( POWER(MAX(LAT_N)- MIN(LAT_N), 2) + POWER(MAX(LONG_W) - MIN(LONG_W),2) ), 4) AS euclidean_distanceFROM STATION; POINT!1) SQRT() ..

https://www.hackerrank.com/challenges/weather-observation-station-18/problem?isFullScreen=true Weather Observation Station 18 | HackerRankQuery the Manhattan Distance between two points, round or truncate to 4 decimal digits.www.hackerrank.comSELECT ROUND(ABS(MIN(LAT_N) - MAX(LAT_N)) + ABS(MIN(LONG_W) - MAX(LONG_W)), 4)FROM STATION; 하나의 쿼리에서 네 개의 좌표 값(a,b,c,d)을 모두 계산합니다.POINT! Manhattan Distanc..

The PADShttps://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true The PADS | HackerRankQuery the name and abbreviated occupation for each person in OCCUPATIONS.www.hackerrank.com 조건 1) OCCUPATIONS 테이블에 모든 이름을 조회해라 단, 알파벳 순서대로 immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses).각 직업 바로 뒤에 해당 직업의 첫글자를 추가하라 이때 첫글자는 괄호(parent..

1. The Blunderhttps://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true The Blunder | HackerRankQuery the amount of error in Sam's result, rounded up to the next integer.www.hackerrank.com Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calc..