https://leetcode.com/problems/article-views-i/submissions/1140600137/?envType=study-plan-v2&envId=top-sql-50 LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 전체 코드 SELECT DISTINCT(viewer_id) as id FROM Views WHERE author_id ..
Coding Test/SQL
https://leetcode.com/problems/big-countries/description/?envType=study-plan-v2&envId=top-sql-50 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 전체 코드 S..
https://leetcode.com/problems/find-customer-referee/description/?envType=study-plan-v2&envId=top-sql-50 Find Customer Referee - LeetCode Can you solve this real interview question? Find Customer Referee - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+ In SQL, id is the leetc..
https://leetcode.com/problems/recyclable-and-low-fat-products/description/?envType=study-plan-v2&envId=top-sql-50 Recyclable and Low Fat Products - LeetCode Can you solve this real interview question? Recyclable and Low Fat Products - Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +--------..
