随笔分类 -  LeetCode

LeetCode SQL [Hard] 1384. 按年度列出销售总额
摘要：建表语句与原题： Create table If Not Exists Product (product_id int, product_name varchar(30)) Create table If Not Exists Sales (product_id varchar(30), perio 阅读全文
posted @ 2020-04-12 02:57 一拳Coder 阅读(444) 评论(0) 推荐(0)
LeetCode 1259. Handshakes That Don't Cross
摘要：一、原题描述 You are given an even number of people num_people that stand around a circle and each person shakes hands with someone else, so that there are  阅读全文
posted @ 2019-11-17 11:29 一拳Coder 阅读(621) 评论(0) 推荐(0)
LeetCode 1255. Maximum Score Words Formed by Letters
摘要：1、原题目描述： Given a list of words, list of single letters (might be repeating) and score of every character. Return the maximum score of any valid set of 阅读全文
posted @ 2019-11-10 15:46 一拳Coder 阅读(445) 评论(0) 推荐(0)
LeetCode 1227. Airplane Seat Assignment Probability
摘要：一、原题描述 n passengers board an airplane with exactly n seats. The first passenger has lost the ticket and picks a seat randomly. But after that, the res 阅读全文
posted @ 2019-10-18 16:38 一拳Coder 阅读(903) 评论(0) 推荐(1)
LeetCode 1225. Report Contiguous Dates (MYSQL + hive UDTF版本)
摘要：一、原题描述 Table: Failed Table: Succeeded A system is running one task every day. Every task is independent of the previous tasks. The tasks can fail or s 阅读全文
posted @ 2019-10-17 10:18 一拳Coder 阅读(1027) 评论(0) 推荐(0)
LeetCode 1212. Team Scores in Football Tournament
摘要：leetcode ,sql 阅读全文
posted @ 2019-10-03 11:35 一拳Coder 阅读(932) 评论(0) 推荐(0)
LeetCode 1127.User Purchase Platform
摘要：Table: Spending Write an SQL query to find the total number of users and the total amount spent using mobile only, desktop only and both mobile and de 阅读全文
posted @ 2019-09-28 23:42 一拳Coder 阅读(705) 评论(0) 推荐(0)
LeetCode 1097. Game Play Analysis V
摘要：1、题目描述 We define the install date of a player to be the first login day of that player.We also define day 1 retention of some date X to be the number 阅读全文
posted @ 2019-09-28 00:57 一拳Coder 阅读(555) 评论(0) 推荐(0)