注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
本帖最后由 匿名 于 2025-5-13 20:29 编辑
前段时间面试了买它 DSA的电话面试 现在来求米谢谢大家. .и
考了Harmful content那道题 SQL和Product都是围绕着它问的
. ----
`content_views`
| **Column Name** | **Data Type** | **Description** |
|-------------------|---------------|------------------------------------------------------------------------------------------|
| `user_id` | INTEGER | ID of the user who viewed the content. Primary Key (with `post_id` and `view_date`). |.--
... Χ
. ----
| `post_id` | INTEGER | ID of the post. Primary Key (with `user_id` and `view_date`). |. .и
| `view_count` | INTEGER | Number of views for the post on the given date. |
| `view_date` | STRING | Date when the views occurred. Primary Key (with `user_id` and `post_id`). |
| user_id | post_id | view_count | view_date |
|---------|---------|------------|-------------|
| 101 | 572 | 3 | 2021-11-01 |
.google и
| 102 | 732 | 5 | 2021-11-02 |
| 103 | 153 | 12 | 2021-11-03 |. 1point 3 acres
| 104 | 634 | 7 | 2021-11-01 |
`violating_content`. 1point3acres.com
| **Column Name** | **Data Type** | **Description** |
|-------------------------|---------------|-------------------------------------------------------------------------------------|
. ----
| `post_id` | INTEGER | ID of the post. Primary Key (with `violation_type`). |. Waral dи,
. .и
| `violation_type` | STRING | Type of violation (e.g., Spam, Scam, Nudity). Primary Key (with `post_id`). |
. 1point 3 acres
| `probability_violating`| DOUBLE | Probability that the post violates the policy. |
.google и
| post_id | violation_type | probability_violating |
|---------|----------------|------------------------|
| 572 | Spam | 0.70 |
| 732 | Scam | 0.85 |
-baidu 1point3acres
| 153 | Nudity | 0.95 |-baidu 1point3acres
.--
| 634 | Harassment | 0.50 |
. .и
-------------------------------------------------------------------
一开始先上来寒暄 相互介绍 了解背景等
SQL:
流程比较紧凑 请注意时间和节奏,即便你在对的方向上但是如果时间不够 可能也会说没关系让你继续 但是可能就已经危了。
case 的follow up 也比较细致的 基本上要听到想要的点 如果没有或者你别出心裁了 面试官也会确认自己没听错(这分扣的没错)
祝各位顺利! |