반응형 Algorithm/LeetCode_SQL3 [LeetCode_SQL] 1484. Group Sold Products By The Date - Oracle & MySQL Table Activities: +-------------+---------+ | Column Name | Type | +-------------+---------+ | sell_date | date | | product | varchar | +-------------+---------+ There is no primary key for this table, it may contain duplicates. Each row of this table contains the product name and the date it was sold in a market. Write an SQL query to find for each date the number of different products sold and.. 2022. 8. 13. [LeetCode_SQL] 1667. Fix Names in a Table - Oracle & MySQL Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ user_id is the primary key for this table. This table contains the ID and the name of the user. The name consists of only lowercase and uppercase characters. Write an SQL query to fix the names so that only the first character is uppercas.. 2022. 8. 13. [LeetCode_SQL] 196. Delete Duplicate Emails - Oracle & MySQL 196. Delete Duplicate Emails Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key column for this table. Each row of this table contains an email. The emails will not contain uppercase letters. Write an SQL query to delete all the duplicate emails, keeping only one unique email wi.. 2022. 8. 13. 이전 1 다음 300x250
