전체 글1523 leetcode 1517. Find Users With Valid E-Mails https://leetcode.com/problems/find-users-with-valid-e-mails/solutions/748172/mysql-regexp-with-explanation/?envType=study-plan-v2&envId=top-sql-50 1 2 3 4 # Write your MySQL query statement below select * from Users where mail regexp '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode[.]com$' cs 정규식에서 . dot은 임의의 문자 하나에 해당하는 사실..! 잊지 않고 푸시길 바랍니다 in the regular expression. The fact that dot corresponds to any sing.. 2023. 6. 7. 백준 28113 정보섬의 대중교통 https://www.acmicpc.net/problem/28113 28113번: 정보섬의 대중교통 버스에 더 먼저 탑승할 수 있으면 Bus, 지하철에 더 먼저 탑승할 수 있으면 Subway, 버스와 지하철에 탑승하게 되는 시간이 동일하면 Anything을 출력한다. www.acmicpc.net 1 2 3 4 5 6 7 8 9 10 11 12 13 def solution(n, a, b): if a == b: return 'Anything' elif a 2023. 6. 7. leetcode 1633. Percentage of Users Attended a Contest https://leetcode.com/problems/percentage-of-users-attended-a-contest/description/?envType=study-plan-v2&envId=top-sql-50 Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-----------.. 2023. 6. 1. leetcode 570. Managers with at Least 5 Direct Reports https://leetcode.com/problems/managers-with-at-least-5-direct-reports/?envType=study-plan-v2&envId=top-sql-50 Managers with at Least 5 Direct Reports - LeetCode Can you solve this real interview question? Managers with at Least 5 Direct Reports - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | varchar | | m.. 2023. 6. 1. leetcode 570. Managers with at Least 5 Direct Reports https://leetcode.com/problems/managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50 Managers with at Least 5 Direct Reports - LeetCode Can you solve this real interview question? Managers with at Least 5 Direct Reports - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | v.. 2023. 5. 31. leetcode 584. Find Customer Referee https://leetcode.com/problems/find-customer-referee/description/?envType=study-plan-v2&id=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 | +-------------+---------+ id is the primary leetcode.. 2023. 5. 29. leetcode 1757. Recyclable and Low Fat Products https://leetcode.com/problems/recyclable-and-low-fat-products/description/?envType=study-plan-v2&id=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 | +-----------.. 2023. 5. 29. leetcode 2652. Sum Multiples https://leetcode.com/problems/sum-multiples/description/ Sum Multiples - LeetCode Can you solve this real interview question? Sum Multiples - Given a positive integer n, find the sum of all integers in the range [1, n] inclusive that are divisible by 3, 5, or 7. Return an integer denoting the sum of all numbers in the given range satisf leetcode.com 1 2 3 4 5 6 7 8 class Solution(object): def su.. 2023. 5. 16. Google Analytics Data API과 Python을 활용한 데이터 수집(Data collection using Google Analytics Data API and Python) https://developers.google.com/analytics/devguides/reporting/data/v1/quickstart-client-libraries?hl=en#python developers.google.com 위 링크의 내용을 따라 진행하시면 되고 (영어로!) Step 2 내용은 내려받은 json 파일에서 client_email에 해당하는 부분을 사용하시면 됩니다. You can proceed by following the link above. For Step 2, use the part corresponding to client_email in the downloaded json file. 13300685251740183869 | Google Analytics Data API .. 2023. 5. 11. Google Analytics Data API를 활용한 제품 데이터 분석 및 태블로 시각화(Product data analysis and visualization using Google Analytics Data API, Tableau) - EP1 https://public.tableau.com/app/profile/.62312393/viz/GA4DataDashboard/1?publish=yes 개요 Data Source : 본인 티스토리 블로그를 방문한 유저 의 GA4 행동 데이터 (수집 과정 https://sunchol21.tistory.com/1684) Data Source: GA4 behavioral data of users who visited their Tistory blog (Collection process https://sunchol21.tistory.com/1684) 구현내역 : 필터 - 기간 설정 Implementation details: Filter - set time period 데이터 원본 - Active Users,, s.. 2023. 5. 4. 백준 27959 초코바 https://www.acmicpc.net/problem/27959 27959번: 초코바 밤고는 $100$원 동전을 $N$개 갖고 있고, 그 돈으로 가격이 $M$원인 초코바를 사 먹으려고 한다. 밤고는 갖고 있는 돈으로 초코바를 사 먹을 수 있는지 알고 싶어 한다. 밤고가 가진 돈이 초코바의 www.acmicpc.net 1 2 3 4 5 6 7 8 9 10 11 dddddef sol(n, m): if n * 100 >= m: return 'Yes' else: return 'No' if __name__ == '__main__': n, m = map(int, input().split()) print(sol(n, m)) Colored by Color Scripter cs 2023. 4. 25. leetcode https://leetcode.com/problems/last-person-to-fit-in-the-bus/ https://leetcode.com/problems/last-person-to-fit-in-the-bus/ Last Person to Fit in the Bus - LeetCode Can you solve this real interview question? Last Person to Fit in the Bus - 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 1 2 3 4 5 6 7 8 SELECT person_name FROM ( SELECT person_id, perso.. 2023. 4. 21. 이전 1 ··· 10 11 12 13 14 15 16 ··· 127 다음
