菲斯不可 SQL面经题 超全总结 标准答案 (无权限,求加米)

本人收集到的SQL 题 with 标准答案 还请大家帮忙加米!不设置任何积分权限!
FB: Popularity Percentage
Find the popularity percentage for each user on FB. the popularity percentage is defined as the total number of friends the user  has divide by the total number of users on the platform
--total number of friends the user has/total number of users on the platform
--total number of users on the platform: union user 1 and user 2
--total number of friends the user has: union user1 and user2, user2 and user1
Select user1,count(*)/max(tuu.all_users) *100  from (
Select coin(*) as all_users from (
Select distinct user1 from facebook_friends
Union
Select distinct user2 from facebook_friends) total_unique_users
)tuu
Join (
. 1point3acres.com Select user1,user2 from facebook_friends
Union
Select user2 as user1, user1 as user2 from facebook_friends) b
On 1=1
Group by user1
Order by user1 asc
FB: SMS confirmation from users
Fb sends SMS texts when users 2f to logoin at which time they must confirm they received the sms text. Confirmation texts are only valid on the date they were sent. Unfortunately, there was an ETL problem where friend requests  and invalid confirmation records were inserted into the fb_sms_sends table. fortunately , the fb_confirmers table contains valid confirmation records.
Calculate pct of confirmed SMS texts for august 4, 2020
--filter out type=confirmation and type=friend request
--filter for ds=’08-04’2020’
--left join fb confirmers with fb-sms sends on phone number
--count(phone numbers from fb_confirms)/count(phone_numers from fb_sms_sends)
Select count(b.phone_number)/count(a.phone_number)*100 as pct from fb_sms_sends a
Left join fb_confirmers b
On a.phone_number=b.phone_number and b.dat

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

21159. 市场分析 II
Table: Users


+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| user_id        | int     |
| join_date      | date    |
| favorite_brand | varchar |
+----------------+---------+
user_id is the primary key of this table.
. 1point 3 acresThis table has the info of the users of an online shopping website where users can sell and buy items.
Table: Orders
+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| order_id      | int     |
| order_date    | date    |
| item_id       | int     |
| buyer_id      | int     |
. Waral dи,| seller_id     | int     |
+---------------+---------+
order_id is the primary key of this table.
item_id is a foreign key to the Items table.
buyer_id and seller_id are foreign keys to the Users table.
Table: Items
+---------------+---------+

这帖必须点赞评分收藏一键三联啊！

请问一下LZ：“L21159. 市场分析 II”的L21159是什么意思？好像不是Leetcode里面的题号
多谢啦！

谢谢lz lz好人！

好多密码。。。感谢楼主的分享！