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)
  • 홈
  • 태그
  • 방명록
#116. [LeetCode / MySQL] 585. Investments in 2016

#116. [LeetCode / MySQL] 585. Investments in 2016

문제  입력 코드SELECT ROUND(SUM(TIV_2016),2) AS tiv_2016FROM insuranceWHERE tiv_2015 IN (SELECT tiv_2015 FROM insurance GROUP BY tiv_2015 HAVING COUNT(pid) > 1) AND (lat, lon) IN (SELECT lat, lon FROM insurance GROUP BY lat, lon HAVING COUNT(pid) = 1);  코드 설명#SELECT #ROUND #SUM #GROUP BY #HAVING #COUNT #IN  문제 출처https://leetcode.com/problems/investments-in-2..

  • format_list_bulleted SQL
  • · 2024. 6. 19.
  • textsms
#115. [LeetCode / MySQL] 602. Friend Requests II: Who Has the Most Friends

#115. [LeetCode / MySQL] 602. Friend Requests II: Who Has the Most Friends

문제  입력 코드WITH base AS (SELECT requester_id AS id FROM RequestAcceptedUNION ALLSELECT accepter_id AS id FROM RequestAccepted)SELECT id, COUNT(*) AS num FROM base GROUP BY 1 ORDER BY 2 DESCLIMIT 1  코드 설명#UNION #UNION ALL #SELECT #COUNT #GROUP BY #ORDER BY #DESC #LIMIT  문제 출처https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/description/?envType=study-plan-v2&envId=top-sql-50

  • format_list_bulleted SQL
  • · 2024. 6. 19.
  • textsms
#114. [LeetCode / MySQL] 1321. Restaurant Growth

#114. [LeetCode / MySQL] 1321. Restaurant Growth

문제  입력 코드1. SELECT visited_on,SUM(SUM(amount)) OVER (ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS amount,ROUND(AVG(SUM(amount)) OVER (ROWS BETWEEN 6 PRECEDING AND CURRENT ROW),2) AS average_amountFROM CustomerGROUP BY visited_onORDER BY visited_on LIMIT 999999 OFFSET 6;  2. SELECT visited_on, amount, ROUND(average_amount,2) AS average_amountFROM (SELECT visited_on, SUM(amount) OVER (ORDER B..

  • format_list_bulleted SQL
  • · 2024. 6. 18.
  • textsms
#113. [LeetCode / MySQL] 1341. Movie Rating

#113. [LeetCode / MySQL] 1341. Movie Rating

문제  입력 코드1. (SELECT name AS resultsFROM MovieRating JOIN Users USING(user_id)GROUP BY nameORDER BY COUNT(*) DESC, nameLIMIT 1)UNION ALL(SELECT title AS resultsFROM MovieRating JOIN Movies USING(movie_id)WHERE EXTRACT(YEAR_MONTH FROM created_at) = 202002GROUP BY titleORDER BY AVG(rating) DESC, titleLIMIT 1);  2. WITH TheMostActiveUser AS ( SELECT name FROM Users NATURAL JOIN ..

  • format_list_bulleted SQL
  • · 2024. 6. 18.
  • textsms
#112. [LeetCode / MySQL] 626. Exchange Seats

#112. [LeetCode / MySQL] 626. Exchange Seats

문제  입력 코드1. SELECT CASE WHEN id = (SELECT MAX(id) FROM Seat) AND (id % 2 = 1) THEN id WHEN id % 2 = 1 THEN id + 1 ELSE id - 1 END AS id, studentFROM SeatORDER BY id;  2. SELECT S.id, IFNULL( IF(S.id % 2 = 0, (SELECT student FROM Seat WHERE id = S.id - 1), (SELECT student FROM Seat WHERE id = S.id + 1) ..

  • format_list_bulleted SQL
  • · 2024. 6. 17.
  • textsms
#111. [LeetCode / MySQL] 1978. Employees Whose Manager Left the Company

#111. [LeetCode / MySQL] 1978. Employees Whose Manager Left the Company

문제  입력 코드1. SUBQUERYSELECT employee_id FROM EmployeesWHERE salary   2. LEFT JOINSELECT e1.employee_id FROM Employees AS e1LEFT JOIN Employees AS e2ON e1.manager_id = e2.employee_idWHERE e1.salary   코드 설명#SELECT #WHERE #NOT IN #ORDER BY #LEFT JOIN # JOIN #NULL #AS #ON  문제 출처https://leetcode.com/problems/employees-whose-manager-left-the-company/description/?envType=study-plan-v2&envId=top-sql-50

  • format_list_bulleted SQL
  • · 2024. 6. 17.
  • textsms
  • navigate_before
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • ···
  • 50
  • 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
  • #반복문
  • #select
  • #join
  • #C언어
  • #group by
  • #수학
  • #order by
  • #count
전체 방문자
오늘
어제
전체
Copyright © 쭈미로운 생활 All rights reserved.
Designed by JJuum

티스토리툴바