Number of Persona active accounts without Github auth

gistfile1.sql

SELECT count(*) 
FROM 
(SELECT * 
FROM `socialaccount_socialaccount`
WHERE `socialaccount_socialaccount`.`provider`="persona") A
LEFT JOIN 
(SELECT * 
FROM `socialaccount_socialaccount`
WHERE `socialaccount_socialaccount`.`provider`="github") B
ON A.`user_id` = B.`user_id`
JOIN `auth_user` ON `auth_user`.`id` = A.`user_id`
WHERE B.`user_id` IS NULL
AND `auth_user`.`is_active` = 1;