Issue Note12 Group sold products by the date - SQL I encountered an issue while solving the LeetCode question "Group sold products by date. Question더보기Table Activities:+-------------+---------+| Column Name | Type |+-------------+---------+| sell_date | date || product | varchar |+-------------+---------+There is no primary key (column with unique values) for this table. It may contain duplicates.Each row of this table contains the p.. 2024. 6. 27. Delete Duplicate Emails [SQL] This time, I encountered an SQL question that is supposed to be easy, but it wasn't as easy as expected. It was a problem about deleting duplicate emails. I tried to solve it using SELECT and GROUP BY, but it didn't work. Question더보기Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || email | varchar |+-------------+---------+id.. 2024. 6. 25. Movie rating - SQL Question Movie Rating.Table: Movies+---------------+---------+| Column Name | Type |+---------------+---------+| movie_id | int || title | varchar |+---------------+---------+movie_id is the primary key (column with unique values) for this table.title is the name of the movie. Table: Users+---------------+---------+| Column Name | Type |+---------------+---------+| use.. 2024. 6. 12. Join And function there was an issue in the process of solving the SQL questions due to problems with date setting. Table: Prices +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | start_date | date | | end_date | date | | price | int | +---------------+---------+ (product_id, start_date, end_date) is the primary key (combination of columns with unique values) fo.. 2024. 4. 19. 1934. Confirmation Rate While I was trying to solve below SQL question on LeetCode, I encountered an unfamiliar issue. In order to solve the problem, I attempted to use 'case when' to calculate the counts of 'timeout' and 'confirmed', and then utilize the sum to derive the value of 'confirmation_Rate'. However, despite multiple attempts, I couldn't solve it due to errors in the code. Table: Signups +----------------+--.. 2024. 4. 12. The count of divisors and addition Two integers, left and right, are given as parameters. Complete the solution function to return the sum of numbers from left to right, where the count of divisors is even, and subtract the sum of numbers where the count of divisors is odd. When I first encountered this question, my initial approach was to first find the divisors, then distinguish between even and odd counts, and finally proceed .. 2024. 4. 9. 이전 1 2 다음
