FreeStyleWiki

HackerRank(SQL)

このエントリーをはてなブックマークに追加

[競技プログラミング,SQL]

HackerRank(SQL)

なんか会社の人がSQL好きなようなので、自分も勉強しとく

  Basic Select

タイトル URL SQL要素 解けた? 解き方
Revising the Select Query I https://www.hackerrank.com/challenges/revising-the-select-query Solved
Revising the Select Query II https://www.hackerrank.com/challenges/revising-the-select-query-2 Solved
Select All https://www.hackerrank.com/challenges/select-all-sql Solved
Select By ID https://www.hackerrank.com/challenges/select-by-id WHERE句 Solved
Japanese Cities' Attributes https://www.hackerrank.com/challenges/japanese-cities-attributes Solved
Japanese Cities' Names https://www.hackerrank.com/challenges/japanese-cities-name 関数 サブクエリ DISTINCT Solved ようやくこの辺から頭を使う。サブクエリでIDの余りをMOD(ID,2)で取得し、それをWHEREで絞り込む。
Weather Observation Station 1 https://www.hackerrank.com/challenges/weather-observation-station-1 Solved
Weather Observation Station 3 https://www.hackerrank.com/challenges/weather-observation-station-3 Solved
Weather Observation Station 4 https://www.hackerrank.com/challenges/weather-observation-station-4 Solved
Weather Observation Station 5 https://www.hackerrank.com/challenges/weather-observation-station-5 Solved このへんを見て max(length(field)) in mysql
Higher Than 75 Marks https://www.hackerrank.com/challenges/more-than-75-marks/problem Solved このへんを見て 文字列の右側から文字列を取り出す (RIGHT)
Employee Names https://www.hackerrank.com/challenges/name-of-employees/problem Solved

  Advanced Select

タイトル URL SQL要素 解けた? 解き方
Type of Triangle https://www.hackerrank.com/challenges/what-type-of-triangle/problem CASE文 Solved case文が使えればOK