Piggy SQL Merit Explorer queries 1 -> https://albertoit.github.io/Merit-Explorer-SQL/

gistfile1.txt

-- The Pharmacist <> LoyceV
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
Where FromUser.UserName = "The Pharmacist" AND ToUser.UserName = "LoyceV"
);
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
-- Where FromUser = "LoyceV" AND ToUser = "DdmrDdmr"
-- Where FromUser = "DdmrDdmr" AND ToUser = "LoyceV"
Where FromUser.UserName = "LoyceV" AND ToUser.UserName = "The Pharmacist"
);

-- LoyceV <> DdmrDdmr
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
Where FromUser.UserName = "DdmrDdmr" AND ToUser.UserName = "LoyceV"
);
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
-- Where FromUser = "LoyceV" AND ToUser = "DdmrDdmr"
-- Where FromUser = "DdmrDdmr" AND ToUser = "LoyceV"
Where FromUser.UserName = "LoyceV" AND ToUser.UserName = "DdmrDdmr"
);

-- The Pharmacist <> DdmrDdmr
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
Where FromUser.UserName = "The Pharmacist" AND ToUser.UserName = "DdmrDdmr"
);
SELECT  FromUser, ToUser, SUM(Merit) as Merit from (
SELECT Date, Merit, FromUser.UserName as FromUser, ToUser.UserName as ToUser from MeritData
INNER JOIN UserData as FromUser on MeritData.FromID = FromUser.UserId
INNER JOIN UserData as ToUser on MeritData.ToID = ToUser.UserId 
-- Where FromUser = "LoyceV" AND ToUser = "DdmrDdmr"
-- Where FromUser = "DdmrDdmr" AND ToUser = "LoyceV"
Where FromUser.UserName = "DdmrDdmr" AND ToUser.UserName = "The Pharmacist"
);