Pandas

문제Table: Employee+---------------+---------+| Column Name | Type |+---------------+---------+| employee_id | int || department_id | int || primary_flag | varchar |+---------------+---------+(employee_id, department_id) is the primary key (combination of columns with unique values) for this table.employee_id is the id of the employee.department_id is the id of the department to wh..

문제Table: Products+-------------+---------+| Column Name | Type |+-------------+---------+| product_id | int || low_fats | enum || recyclable | enum |+-------------+---------+product_id is the primary key (column with unique values) for this table.low_fats is an ENUM (category) of type ('Y', 'N') where 'Y' means this product is low fat and 'N' means it is not.recyclable is an EN..

문제Table: Employees+-------------+------+| Column Name | Type |+-------------+------+| emp_id | int || event_day | date || in_time | int || out_time | int |+-------------+------+(emp_id, event_day, in_time) is the primary key (combinations of columns with unique values) of this table.The table shows the employees' entries and exits in an office.event_day is the day at which this ..

문제Table: Employees+-------------+----------+| Column Name | Type |+-------------+----------+| employee_id | int || name | varchar || reports_to | int || age | int |+-------------+----------+employee_id is the column with unique values for this table. This table contains information about the employees and the id of the manager they report to. Some employees do..

문제Table: Followers+-------------+------+| Column Name | Type |+-------------+------+| user_id | int || follower_id | int |+-------------+------+(user_id, follower_id) is the primary key (combination of columns with unique values) for this table.This table contains the IDs of a user and a follower in a social media app where the follower follows the user. Write a solution that will, for eac..

문제Table: DailySales+-------------+---------+| Column Name | Type |+-------------+---------+| date_id | date || make_name | varchar || lead_id | int || partner_id | int |+-------------+---------+There is no primary key (column with unique values) for this table. It may contain duplicates.This table contains the date and the name of the product sold and the IDs of the lead..

문제Table: Tweets+----------------+---------+| Column Name | Type |+----------------+---------+| tweet_id | int || content | varchar |+----------------+---------+tweet_id is the primary key (column with unique values) for this table.This table contains all the tweets in a social media app.Write a solution to find the IDs of the invalid tweets. The tweet is invalid if the num..

문제Table: Users+----------------+---------+| Column Name | Type |+----------------+---------+| user_id | int || name | varchar |+----------------+---------+user_id is the primary key (column with unique values) for this table.This table contains the ID and the name of the user. The name consists of only lowercase and uppercase characters.Write a solution to fix the name..

문제Table: Activity+----------------+---------+| Column Name | Type |+----------------+---------+| machine_id | int || process_id | int || activity_type | enum || timestamp | float |+----------------+---------+The table shows the user activities for a factory website.(machine_id, process_id, activity_type) is the primary key (combination of columns with unique valu..

문제Table: Users+-------------+---------+| Column Name | Type |+-------------+---------+| user_id | int || user_name | varchar |+-------------+---------+user_id is the primary key (column with unique values) for this table.Each row of this table contains the name and the id of a user.Table: Register+-------------+---------+| Column Name | Type |+-------------+---------+| contest_id..