SQLize Online / PHPize Online  /  SQLtest Online

Create table f_req (s_id int, s_to_id int, req_date date); insert into f_req (s_id, s_to_id, req_date) values (1,2,'2016_06-01'); insert into f_req (s_id, s_to_id, req_date) values (1,3,'2016_06-01'); insert into f_req (s_id, s_to_id, req_date) values (1,4,'2016_06-01'); insert into f_req (s_id, s_to_id, req_date) values (2,3,'2016_06-02'); insert into f_req (s_id, s_to_id, req_date) values (3,4,'2016_06-09'); Create table a_req (r_id int, a_id int, a_date date); insert into a_req (r_id, a_id, a_date) values (1,2,'2016_06-03'); insert into a_req (r_id, a_id, a_date) values (1,3,'2016_06-08'); insert into a_req (r_id, a_id, a_date) values (2,3,'2016_06-08'); insert into a_req (r_id, a_id, a_date) values (3,4,'2016_06-09'); insert into a_req (r_id, a_id, a_date) values (3,4,'2016_06-10'); select * from f_req; select * from a_req; select ifnull((round(accepts/requests, 2)), 0.0) as accept_rate from (select count(distinct s_id,s_to_id) as requests from f_req) as t1, (select count(distinct r_id,a_id) as accepts from a_req) as t2