[데이터분석] 코드카타 Lv.6 77~80

77. Recyclable and Low Fat Products

 

https://leetcode.com/problems/recyclable-and-low-fat-products/description/

 

문제 주석 잘 봐야함!  1, 3만 찍는게 아니라 값을 보고 나오게끔 유도하는 식..^_ㅠ

select product_id

from products

where low_fats = "Y" and recyclable ="Y"

 

 

 

 

78. Find Customer Referee

 

https://leetcode.com/problems/find-customer-referee/description/

 

 

Output이 나와야함!

 

select name

from customer

where referee_id != 2 or referee_id is null

 

 

 

79. Big Countries

https://leetcode.com/problems/big-countries/

(오답) 답은 같은데 뭐가 문젤까 확

 

select name, population, area

from world

where continent >=3000000 or population >=25000000

 

(정답)  컥.. 조건에 continent를 적음.-ㅁ-

select name, population, area

from world

where area >=3000000 or population >=25000000

 

80. Article Views I

https://leetcode.com/problems/article-views-i/

 

와 이게된다고 ?  정답!

select distinct author_id 'id'

from views

where author_id = viewer_id

order by 1

 

 

참고

https://nyamin9-data.tistory.com/149

🔓 09. LeetCode SQL 50 Easy LEVEL 문제풀이

 

줄바꿈 / 챗GPT / 스택오버플로우  질문답변

https://stackoverflow.com/

Stack Overflow - Where Developers Learn, Share, & Build Careers

 

colab

AI 어디서 에러 났는지 수정방안까지 제안   -> 파이썬 // 

에러  밑에 Explain  error 클릭 -> 오른쪽 화면 해결 제안 //