hkl22 블로그

SQL AlgorithmLeetCode181. Employees Earning More Than Their Managers Column Name Type id int namevarcharsalary int managerId int id is the primary key (column with unique values) for this table.Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager.Write a solution to find the employees who earn more than their managers.Return the result table in..

SQL AlgorithmLeetCode1890. Recyclable and Low Fat Products Column Name Type user_idinttime_stampdatetime(user_id, time_stamp) is the primary key (combination of columns with unique values) for this table.Each row contains information about the login time for the user with ID user_id.Write a solution to report the latest login for all users in the year 2020. Do not include the users who did not ..

SQL AlgorithmLeetCode1757. Recyclable and Low Fat Products Column Name Type product_id int low_fats enum recyclable enumproduct_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 ENUM (category) of types ('Y', 'N') where 'Y' means this product is recy..

SQL AlgorithmLeetCode1741. Find Total Time Spent by Each EmployeeColumn NameTypeemp_idintevent_daydatein_timeintout_timeint(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 event happened, in_time is the minute at which the employee entered the..