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)
  • 홈
  • 태그
  • 방명록
#110. [LeetCode / MySQL] 1907. Count Salary Categories

#110. [LeetCode / MySQL] 1907. Count Salary Categories

문제 입력 코드 (SELECT "Low Salary" AS category, (SELECT COUNT(account_id) FROM Accounts WHERE income = 20000 and income 50000) AS accounts_count) 코드 설명 #SELECT #COUNT #UNION #UNION ALL 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your ..

  • format_list_bulleted SQL
  • · 2023. 10. 6.
  • textsms
#105. [LeetCode / MySQL] 1789. Primary Department for Each Employee

#105. [LeetCode / MySQL] 1789. Primary Department for Each Employee

문제 입력 코드 1. SELECT employee_id, department_id FROM Employee GROUP BY employee_id HAVING COUNT(employee_id) = 1 UNION SELECT employee_id, department_id FROM Employee WHERE primary_flag = 'Y' 2. SELECT DISTINCT employee_id, department_id FROM Employee WHERE employee_id IN ( SELECT employee_id FROM Employee GROUP BY employee_id HAVING COUNT(*) = 1 ) OR primary_flag = 'Y' ORDER BY employee_id; 코드 설명..

  • format_list_bulleted SQL
  • · 2023. 10. 1.
  • textsms
#104. [LeetCode / MySQL] 1731. The Number of Employees Which Report to Each Employee

#104. [LeetCode / MySQL] 1731. The Number of Employees Which Report to Each Employee

문제 입력 코드 SELECT e2.employee_id, e2.name, COUNT(*) AS reports_count, ROUND(AVG(e1.age)) AS average_age FROM Employees AS e1 INNER JOIN Employees AS e2 ON e1.reports_to = e2.employee_id GROUP BY e2.employee_id, e2.name ORDER BY e2.employee_id 코드 설명 #SELECT #COUNT #ROUND #AVG #INNER JOIN #GROUP BY #ORDER BY 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your codi..

  • format_list_bulleted SQL
  • · 2023. 9. 30.
  • textsms
#103. [LeetCode / MySQL] 1045. Customers Who Bought All Products

#103. [LeetCode / MySQL] 1045. Customers Who Bought All Products

문제 입력 코드 SELECT customer_id FROM Customer GROUP BY customer_id HAVING COUNT(DISTINCT(product_key)) = (SELECT COUNT(product_key) FROM Product); 코드 설명 #SELECT #GROUP BY #HAVING #COUNT #DISTINCT 문제 출처 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 i..

  • format_list_bulleted SQL
  • · 2023. 9. 29.
  • textsms
#102. [LeetCode / MySQL] 619. Biggest Single Number

#102. [LeetCode / MySQL] 619. Biggest Single Number

문제 입력 코드 SELECT MAX(num) as num FROM MyNumbers WHERE num NOT IN ( SELECT num FROM MyNumbers GROUP BY num HAVING COUNT(*) > 1) 코드 설명 #SELECT #MAX #NOT IN #GROUP BY #HAVING #COUNT 문제 출처 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. leet..

  • format_list_bulleted 카테고리 없음
  • · 2023. 9. 28.
  • textsms
#101. [LeetCode / MySQL] 1729. Find Followers Count

#101. [LeetCode / MySQL] 1729. Find Followers Count

문제 입력 코드 SELECT user_id, COUNT(follower_id) AS followers_count FROM Followers GROUP BY user_id ORDER BY user_id ASC; 코드 설명 #SELECT #COUNT #GROUP BY #ORDER BY 문제 출처 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. 9. 27.
  • textsms
  • navigate_before
  • 1
  • 2
  • 3
  • 4
  • 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)
최근 글
인기 글
최근 댓글
태그
  • #수학
  • #반복문
  • #select
  • #백준
  • #C언어
  • #Where
  • #count
  • #order by
  • #join
  • #group by
전체 방문자
오늘
어제
전체
Copyright © 쭈미로운 생활 All rights reserved.
Designed by JJuum

티스토리툴바