SQL | LeetCode 1978. 조건에 맞는 직원 찾기 (NOT IN)
·
Computer Science/SQL
Table: Employees+-------------+----------+| Column Name | Type |+-------------+----------+| employee_id | int || name | varchar || manager_id | int || salary | int |+-------------+----------+In SQL, employee_id is the primary key for this table.This table contains information about the employees, their salary, and the ID of their manager. Some employees do not ha..
SQL | LeetCode 1907. Salary 범주별 계좌 수 세기 (UNION vs. UNION ALL)
·
Computer Science/SQL
Table: Accounts+-------------+------+| Column Name | Type |+-------------+------+| account_id | int || income | int |+-------------+------+account_id is the primary key (column with unique values) for this table.Each row contains information about the monthly income for one bank account. Write a solution to calculate the number of bank accounts for each salary category. The salary catego..
SQL | LeetCode 1204. 버스 정원 제한에 따라 탈 수 있는 마지막 사람 구하기
·
Computer Science/SQL
Table: Queue+-------------+---------+| Column Name | Type |+-------------+---------+| person_id | int || person_name | varchar || weight | int || turn | int |+-------------+---------+person_id column contains unique values.This table has the information about all people waiting for a bus.The person_id and turn columns will contain all numbers from 1 to n, where n is ..
Pandas | LeetCode 1683. 15자를 초과한 트윗 찾기
·
BI & Visualization/Python
Table: Tweets+----------------+---------+| Column Name | Type |+----------------+---------+| tweet_id | int || content | varchar |+----------------+---------+tweet_id is the primary key (column with unique values) for this table.content consists of alphanumeric characters, '!', or ' ' and no other special characters.This table contains all the tweets in a social media app...
Pandas | LeetCode 1148. 자신이 쓴 글을 본 작가 찾기
·
BI & Visualization/Python
Table: Views+---------------+---------+| Column Name | Type |+---------------+---------+| article_id | int || author_id | int || viewer_id | int || view_date | date |+---------------+---------+There is no primary key (column with unique values) for this table, the table may have duplicate rows.Each row of this table indicates that some viewer viewed an article ..
Pandas | LeetCode 183. 주문하지 않은 고객 찾기
·
BI & Visualization/Python
Table: Customers+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table indicates the ID and name of a customer. Table: Orders+-------------+------+| Column Name | Type |+-------------+------+| id | int || ..
올리브한입
'분류 전체보기' 카테고리의 글 목록 (6 Page)