804. 唯一摩尔斯密码词 / 197. 上升的温度 / 607. 销售员 / 1141. 查询近30天活跃用户数 / 1693. 每天的领导和合伙人 / 1729. 求关注者的数量

804. 唯一摩尔斯密码词【简单题】【每日一题】

思路：【简单模拟】

1. 定义字符串数组存储每个字母对应的摩斯字符串，定义哈希set存储唯一摩斯码。
2. 遍历每一个单词，定义可变字符串sb，遍历当前单词的每一个字母，将字母对应的摩斯码追加到sb中，最后将sb固化为String存入哈希set。
3. 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;