[1543#] Fix Product Name Format
·
SQL/LeetCode
보호되어 있는 글입니다.
[1517#] Find Users With Valid E-Mails
·
SQL/LeetCode
보호되어 있는 글입니다.
[1495#] Friendly Movies Streamed Last Month
·
SQL/LeetCode
보호되어 있는 글입니다.
[1484] Group Sold Products By The Date
·
SQL/LeetCode
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..
[1435#] Create a Session Bar Chart
·
SQL/LeetCode
보호되어 있는 글입니다.
[1407] Top Travellers
·
SQL/LeetCode
Top Travellers - LeetCode 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 문제 조건 유저별 이동한 거리를 출력하시오 travelled_distance를 기준으로 내림차순하고, 같을 경우 name을 기준으로 오름차순 정렬하시오. # LEFT JOIN SELECT name, SUM(COALESCE(R.distance,0)) AS travelled_distance FROM Users U LEFT JOIN Rides R ON U.id = R.user_id GROUP..
[1378#] Replace Employee ID With The Unique Identifier
·
SQL/LeetCode
보호되어 있는 글입니다.
[1350#] Students With Invalid Departments
·
SQL/LeetCode
보호되어 있는 글입니다.