데이터 공부를 기록하는 공간

↑https://www.hackerrank.com/domains/sql?filters%5Bskills%5D%5B%5D=SQL%20%28Intermediate%29 Solve SQL Code Challenges A special-purpose language designed for managing data held in a relational database. www.hackerrank.com ☆The Report select if(g.Grade >=8, s.Name, NULL), g.Grade, s.Marks from Students s left join Grades g on s.Marks between g.Min_Mark and g.Max_Mark order by g.Grade desc, s.Name ..

https://www.hackerrank.com/domains/sql?filters%5Bskills%5D%5B%5D=SQL%20%28Intermediate%29 Solve SQL Code Challenges A special-purpose language designed for managing data held in a relational database. www.hackerrank.com intermediate ☆Binary Tree Nodes select N, case when P is null then "Root" when N not in (select distinct P from BST where P is not null) then "Leaf" else "Inner" end from BST ord..

HACKERRANK _ SQL https://www.hackerrank.com/domains/sql?filters%5Bskills%5D%5B%5D=SQL%20%28Basic%29 Solve SQL Code Challenges A special-purpose language designed for managing data held in a relational database. www.hackerrank.com SKILLS (BASIC / INTERMEDIATE / Advanced ) 中 BASIC ! Revising the Select Query I select * from CITY where POPULATION > 100000 and COUNTRYCODE = "USA" Revising the Select..

코드카데미(codecademy) SQL 연습해보기 https://www.codecademy.com/courses/learn-sql/lessons/manipulation/exercises/manipulation-review Cheating Sheet https://www.codecademy.com/learn/learn-sql/modules/learn-sql-manipulation/cheatsheet LESSON 1 Manipulation CREATE TABLE CREATE TABLE celebs ( id INTEGER, name TEXT, age INTEGER ); INSERT TABLE INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Bieber', 22)..