문제링크 https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/description/?envType=study-plan-v2&envId=top-sql-50 Customer Who Visited but Did Not Make Any Transactions - LeetCode Can you solve this real interview question? Customer Who Visited but Did Not Make Any Transactions - Table: Visits +-------------+---------+ | Column Name | Type | +-------------+---------+ ..

문제 링크 https://leetcode.com/problems/product-sales-analysis-i/?envType=study-plan-v2&envId=top-sql-50 Product Sales Analysis I - LeetCode Can you solve this real interview question? Product Sales Analysis I - Table: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | int | | quantity | int | | price | int | +----------- leet..

문제링크 https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/description/?envType=study-plan-v2&envId=top-sql-50 Replace Employee ID With The Unique Identifier - LeetCode Can you solve this real interview question? Replace Employee ID With The Unique Identifier - Table: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | na..

문제링크 https://leetcode.com/problems/invalid-tweets/description/ Invalid Tweets - LeetCode Can you solve this real interview question? Invalid Tweets - Table: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | varchar | +----------------+---------+ tweet_id is the primary key (c leetcode.com 문제 소스코드 # Write your MySQL query statem..

문제링크 https://leetcode.com/problems/article-views-i/description/ Article Views I - LeetCode Can you solve this real interview question? Article Views I - Table: Views +---------------+---------+ | Column Name | Type | +---------------+---------+ | article_id | int | | author_id | int | | viewer_id | int | | view_date | date | +---------------+--- leetcode.com 문제 소스코드 # Write your MySQL query stat..

문제링크 https://leetcode.com/problems/big-countries/description/ Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | population | int | | gdp | bigint | +----------- leetcode.com 문제 소스코드 # Write your MySQL query statemen..