Bigdata
close
프로필 배경
프로필 로고

Bigdata

  • 분류 전체보기 (299)
    • BS (0)
      • review (0)
      • study (0)
      • submission (0)
    • Computer Science (20)
      • Data Structure (0)
      • Algorithm (19)
      • OS (0)
      • ML, DL (0)
      • AI (0)
      • NLP (0)
      • Linear Algebra (0)
    • Statistics (33)
      • BSA (33)
      • ANOVA (0)
      • MSA (0)
      • Regression Analysis (0)
    • SQL (95)
    • Tableau (0)
    • Java (1)
    • DA (26)
    • TIL (0)
    • SAS (0)
    • Python (9)
    • DACON (8)
      • Project (0)
    • ST (2)
      • Deep Learning project (22-1.. (0)
      • Kaggle project (22-1) (0)
      • DACON_BASIC (22-1) (0)
      • Data (0)
      • Data Mining (0)
      • Kaggle project (21-2) (1)
      • Deep Learning (1)
    • C (103)
    • Etc (1)
  • 홈
  • 태그
  • 방명록
#106. [LeetCode / MySQL] 610. Triangle Judgement

#106. [LeetCode / MySQL] 610. Triangle Judgement

문제 입력 코드 1. SELECT x, y, z, (CASE WHEN x+y Y, "Yes", "No") AS Triangle FROM Triangle 코드 설명 #SELECT #CASE WHEN #ELSE #IF 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com

  • format_list_bulleted SQL
  • · 2023. 10. 2.
  • textsms
#94. [LeetCode / MySQL] 1193. Monthly Transactions I

#94. [LeetCode / MySQL] 1193. Monthly Transactions I

문제 입력 코드 1. SELECT DATE_FORMAT(trans_date, '%Y-%m') AS month, country, COUNT(*) AS trans_count, SUM(IF(state='approved', 1, 0)) AS approved_count, SUM(amount) AS trans_total_amount, SUM(IF(state='approved', amount, 0)) AS approved_total_amount FROM Transactions GROUP BY month, country 2. SELECT SUBSTR(trans_date, 1, 7) AS month, country, COUNT(*) AS trans_count, SUM(CASE WHEN state = 'approved' ..

  • format_list_bulleted SQL
  • · 2023. 9. 20.
  • textsms
#93. [LeetCode / MySQL] 1211. Queries Quality and Percentage

#93. [LeetCode / MySQL] 1211. Queries Quality and Percentage

문제 입력 코드 1. IF SELECT query_name, ROUND(AVG(rating/position), 2) AS quality, ROUND(AVG(IF(rating < 3, 1, 0))*100, 2) AS poor_query_percentage FROM Queries GROUP BY query_name 2. CASE WHEN SELECT query_name, ROUND(AVG(rating/position), 2) AS quality, ROUND(SUM( CASE WHEN rating < 3 THEN 1 ELSE 0 END ) * 100 / COUNT(*), 2) AS poor_query_percentage FROM Queries GROUP BY query_name 코드 설명 #SELECT #RO..

  • format_list_bulleted SQL
  • · 2023. 9. 19.
  • textsms
  • navigate_before
  • 1
  • navigate_next
공지사항
전체 카테고리
  • 분류 전체보기 (299)
    • BS (0)
      • review (0)
      • study (0)
      • submission (0)
    • Computer Science (20)
      • Data Structure (0)
      • Algorithm (19)
      • OS (0)
      • ML, DL (0)
      • AI (0)
      • NLP (0)
      • Linear Algebra (0)
    • Statistics (33)
      • BSA (33)
      • ANOVA (0)
      • MSA (0)
      • Regression Analysis (0)
    • SQL (95)
    • Tableau (0)
    • Java (1)
    • DA (26)
    • TIL (0)
    • SAS (0)
    • Python (9)
    • DACON (8)
      • Project (0)
    • ST (2)
      • Deep Learning project (22-1.. (0)
      • Kaggle project (22-1) (0)
      • DACON_BASIC (22-1) (0)
      • Data (0)
      • Data Mining (0)
      • Kaggle project (21-2) (1)
      • Deep Learning (1)
    • C (103)
    • Etc (1)
최근 글
인기 글
최근 댓글
태그
  • #Where
  • #백준
  • #join
  • #수학
  • #count
  • #group by
  • #반복문
  • #C언어
  • #order by
  • #select
전체 방문자
오늘
어제
전체
Copyright © 쭈미로운 생활 All rights reserved.
Designed by JJuum

티스토리툴바