데이터로 보는 세상 데이터로 보는 세상

문제난이도 Hard | Topics | Companies | SQL Schema > Pandas SchemaTable: Employee+--------------+---------+| Column Name | Type |+--------------+---------+| id | int || name | varchar || salary | int || departmentId | int |+--------------+---------+id is the primary key (column with unique values) for this table.departmentId is a foreign key (reference column) o..

문제난이도 : MediumSQL Schema > Pandas SchemaTable: Activity+--------------+---------+| Column Name | Type |+--------------+---------+| player_id | int || device_id | int || event_date | date || games_played | int |+--------------+---------+(player_id, event_date) is the primary key (combination of columns with unique values) of this table.This table shows the activity of p..

문제Table: Product+--------------+---------+| Column Name | Type |+--------------+---------+| product_id | int || product_name | varchar || unit_price | int |+--------------+---------+product_id is the primary key (column with unique values) of this table.Each row of this table indicates the name and the price of each product.Table: Sales+-------------+---------+| Column Name | Typ..