개발 창고(주인장: 파뱁)

LENGTH() 함수를 써보는 문제https://leetcode.com/problems/invalid-tweets/description/?envType=study-plan-v2&envId=top-sql-50⬆️ 문제 전문 링크 Table: Tweets+----------------+---------+| Column Name | Type |+----------------+---------+| tweet_id | int || content | varchar |+----------------+---------+tweet_id is the primary key (column with unique values) for this table.content consists of..

select와 distinct, as, order by 를 사용하는 문제이다.https://leetcode.com/problems/article-views-i/description/?envType=study-plan-v2&envId=top-sql-50⬆️ 문제 전문 링크 Table: Views+---------------+---------+| Column Name | Type |+---------------+---------+| article_id | int || author_id | int || viewer_id | int || view_date | date |+---------------+---------+There is no primar..

다음은 or 조건을 사용하는 문제이다https://leetcode.com/problems/big-countries/description/?envType=study-plan-v2&envId=top-sql-50⬆️ 문제 전문 링크 Table: World+-------------+---------+| Column Name | Type |+-------------+---------+| name | varchar || continent | varchar || area | int || population | int || gdp | bigint |+-------------+---------+name is the primary key (column wi..

이번 것도 역시 select 쿼리를 사용하는 문제이다https://leetcode.com/problems/find-customer-referee/description/?envType=study-plan-v2&envId=top-sql-50⬆️ 문제 전문 링크 Table: Customer+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar || referee_id | int |+-------------+---------+In SQL, id is the primary key column for this table.Each row of ..

너어어어무 알고리즘 및 sql 에 손 떼고 있어서 (물론 회사 업무의 sql은 했었음)쉬운거 부터 하나 가져왔어요https://leetcode.com/problems/recyclable-and-low-fat-products/?envType=study-plan-v2&envId=top-sql-50⬆️문제 전문 Table: Products+-------------+---------+| Column Name | Type |+-------------+---------+| product_id | int || low_fats | enum || recyclable | enum |+-------------+---------+product_id is the primary key (colum..