목록리트코드 (9)
On the journey of
[LeetCode]1661.Average Time of~, 1251.Average Selling Price , 1141. User Activity for the Past 30 Days I
Q. 1661 Average Time of Process per Machine Average Time of Process per Machine - LeetCode Can you solve this real interview question? Average Time of Process per Machine - Table: Activity +----------------+---------+ | Column Name | Type | +----------------+---------+ | machine_id | int | | process_id | int | | activity_type | enum | | timestam leetcode.com Table: Views +---------------+-------..
[LeetCode] 595.Big Countries,1068. Product Sales Analysis 1
Select_Big Countries Basic Joins_Customer Who Visited but Not Make Any Transactions Basic Joins_Rising Temperature Subqueries_Employees Whose Manager Left the Company 595. Big Countries https://leetcode.com/problems/big-countries/ (아래 첨부) Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-----------..
[LEETCODE] SQL50 : 595.Big Countries,1148.Article Views 1
프로그래머스에 이어 다시! 리트코드 재개한다 ...... ! 아좌 (...) 1. Big Countries : https://leetcode.com/problems/big-countries/?envType=study-plan-v2&envId=top-sql-50 Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | population | int | ..
[Leetcode] SQL50 (Recyclable&Low Fat, Customer Referee)
Source: https://leetcode.com/studyplan/top-sql-50/ SQL 50 - Study Plan - LeetCode Crack SQL Interview in 50 Qs leetcode.com : 회원가입 후(진짜 짱 간단하다! 단, 메일인증을 해야 코드 입력이 가능함) SQL 50 스터디플랜 선택하면 시작 가능(?) 크게 SELECT // Basic Joins // Basic Aggregate Functions // Sorting and Grouping // Advanced Select and Joins // Subqueries // Advanced String Functions ,Regex, Clause 카테고리로 나뉘어 있다. . 음 매일같이 풀지는 못하더라도 (그리고 ..