804. 唯一摩尔斯密码词【简单题】【每日一题】
思路:【简单模拟】
- 定义字符串数组存储每个字母对应的摩斯字符串,定义哈希set存储唯一摩斯码。
- 遍历每一个单词,定义可变字符串sb,遍历当前单词的每一个字母,将字母对应的摩斯码追加到sb中,最后将sb固化为String存入哈希set。
- set的大小结尾唯一摩斯码词的数量。
代码:
class Solution {
public int uniqueMorseRepresentations(String[] words) {
String[] keys = {".-","-...","-.-.","-..",".","..-.","--.","....","..",".---","-.-",
".-..","--","-.","---",".--.","--.-",".-.","...","-","..-","...-",".--","-..-","-.--","--.."};
Set<String> set = new HashSet<>();
for (String word : words) {
StringBuilder sb = new StringBuilder();
for (char c : word.toCharArray()) {
sb.append(keys[c-'a']);
}
set.add(sb.toString());
}
return set.size();
}
}
197. 上升的温度【简单题】
代码:
# Write your MySQL query statement below
select w1.id
from Weather w1,Weather w2
where
w1.Temperature > w2.Temperature
and
datediff(w1.RecordDate,w2.RecordDate) = 1;
607. 销售员【简单题】
代码:
# Write your MySQL query statement below
select s.name as `name`
from SalesPerson s
where s.sales_id not in (
select o.sales_id
from Orders o left join Company c
on o.com_id = c.com_id
where c.name = 'RED'
);
1141. 查询近30天活跃用户数【简单题】
代码:
# Write your MySQL query statement below
select activity_date as `day`,count(distinct user_id) as `active_users`
from Activity
where datediff('2019-07-27',activity_date) < 30
group by activity_date;
1693. 每天的领导和合伙人【简单题】
代码:
# Write your MySQL query statement below
select date_id,make_name,count(distinct lead_id) as `unique_leads`,count(distinct partner_id) as `unique_partners`
from DailySales
group by date_id,make_name;
1729. 求关注者的数量【简单题】
代码:
# Write your MySQL query statement below
select user_id,count(user_id) as `followers_count`
from Followers
group by user_id
order by user_id;