当前位置:网站首页>每日sql:求好友申请通过率
每日sql:求好友申请通过率
2022-08-11 05:35:00 【吃再多糖也不长胖】
每日sql :求好友申请通过率
背景
模拟两张表。1为好友申请表,2为申请通过表
问题1:好友申请通过率
ddl
Create table If Not Exists friend_request ( sender_id INT NOT NULL, send_to_id INT NULL, request_date DATE NULL);Create table If Not Exists request_accepted ( requester_id INT NOT NULL, accepter_id INT NULL, accept_date DATE NULL);insert into friend_request (sender_id, send_to_id, request_date) values (1, 2, '2016/06/01');insert into friend_request (sender_id, send_to_id, request_date) values (1, 3, '2016/06/01');insert into friend_request (sender_id, send_to_id, request_date) values (1, 4, '2016/06/01');insert into friend_request (sender_id, send_to_id, request_date) values (2, 3, '2016/06/02');insert into friend_request (sender_id, send_to_id, request_date) values (3, 4, '2016/06/09');insert into request_accepted (requester_id, accepter_id, accept_date) values (1, 2, '2016/06/03');insert into request_accepted (requester_id, accepter_id, accept_date) values (1, 3, '2016/06/08');insert into request_accepted (requester_id, accepter_id, accept_date) values (2, 3, '2016/06/08');insert into request_accepted (requester_id, accepter_id, accept_date) values (3, 4, '2016/06/09');insert into request_accepted (requester_id, accepter_id, accept_date) values (3, 4, '2016/06/10');
sql
select round( (select count(*) from (select distinct requester_id,accepter_id from request_accepted) as b) / (select count(*) from (select distinct sender_id,send_to_id from friend_request) as a) ,2)
边栏推荐
猜你喜欢
图文带你理解什么是Few-shot Learning
My meeting of the OA project (meeting seating & review)
OA项目之待开会议&历史会议&所有会议
grep、sed、awk
TOP2 Add two numbers
京东商品详情API调用实例讲解
【LeetCode】306.累加数(思路+题解)
HCIP-Spanning Tree (802.1D, Standard Spanning Tree/802.1W: RSTP Rapid Spanning Tree/802.1S: MST Multiple Spanning Tree)
MySQL导入导出&视图&索引&执行计划
八股文之mysql
随机推荐
导航定位中的坐标系
Class definition, class inheritance, and the use of super
windows10安全中心显示“修正未完成”
iptables nat
什么是Inductive learning和Transductive learning
核方法 Kernel method
华为防火墙-6
MySQL之CRUD
Top20 bracket matching
iptables的状态
华为防火墙-5-NAT
《Show, Attend and Tell: Neural Image Caption Generation with Visual Attention》论文阅读(详细)
arcgis填坑_3
华为防火墙-4-安全策略
局域网文件传输
HCIP BGP built adjacent experiment
CLUSTER DAY04 (Block Storage Use Cases, Distributed File Systems, Object Storage)
淘宝sku API 接口(PHP示例)
1688商品详情接口
阿里巴巴规范之POJO类中布尔类型的变量都不要加is前缀详解