CREATE TABLE done_by
    ([Var_ID] int, [Var_name] varchar(3), [Q1_by] varchar(2), [Q2_by] varchar(3), [Q3_by] varchar(3), [Q4_by] varchar(3))
;
 
INSERT INTO done_by
    ([Var_ID], [Var_name], [Q1_by], [Q2_by], [Q3_by], [Q4_by])
VALUES
    (1, 'abc', 'me', 'me', 'me', 'you'),
    (1, 'cba', 'me', 'me', 'you', 'you'),
    (2, 'abd', 'me', 'you', 'you', 'me')
;
SELECT ((
SELECT Count(Q1_by)
FROM done_by
WHERE Q1_by = 'me' 
)+
(
SELECT Count(Q2_by)
FROM done_by
WHERE Q2_by = 'me' 
)+
(
SELECT Count(Q3_by)
FROM done_by
WHERE Q3_by = 'me' 
)+
(
SELECT Count(Q4_by)
FROM done_by
WHERE Q4_by = 'me' 
)) AS MeCount,
((
SELECT Count(Q1_by)
FROM done_by
WHERE Q1_by = 'you' 
)+
(
SELECT Count(Q2_by)
FROM done_by
WHERE Q2_by = 'you' 
)+
(
SELECT Count(Q3_by)
FROM done_by
WHERE Q3_by = 'you' 
)+
(
SELECT Count(Q4_by)
FROM done_by
WHERE Q4_by = 'you' 
)) AS YouCount
FROM done_by
 
 
 
 
;

CgpDUkVBVEUgVEFCTEUgZG9uZV9ieQogICAgKFtWYXJfSURdIGludCwgW1Zhcl9uYW1lXSB2YXJjaGFyKDMpLCBbUTFfYnldIHZhcmNoYXIoMiksIFtRMl9ieV0gdmFyY2hhcigzKSwgW1EzX2J5XSB2YXJjaGFyKDMpLCBbUTRfYnldIHZhcmNoYXIoMykpCjsKICAgIApJTlNFUlQgSU5UTyBkb25lX2J5CiAgICAoW1Zhcl9JRF0sIFtWYXJfbmFtZV0sIFtRMV9ieV0sIFtRMl9ieV0sIFtRM19ieV0sIFtRNF9ieV0pClZBTFVFUwogICAgKDEsICdhYmMnLCAnbWUnLCAnbWUnLCAnbWUnLCAneW91JyksCiAgICAoMSwgJ2NiYScsICdtZScsICdtZScsICd5b3UnLCAneW91JyksCiAgICAoMiwgJ2FiZCcsICdtZScsICd5b3UnLCAneW91JywgJ21lJykKOwpTRUxFQ1QgKCgKU0VMRUNUIENvdW50KFExX2J5KQpGUk9NIGRvbmVfYnkKV0hFUkUgUTFfYnkgPSAnbWUnIAopKwooClNFTEVDVCBDb3VudChRMl9ieSkKRlJPTSBkb25lX2J5CldIRVJFIFEyX2J5ID0gJ21lJyAKKSsKKApTRUxFQ1QgQ291bnQoUTNfYnkpCkZST00gZG9uZV9ieQpXSEVSRSBRM19ieSA9ICdtZScgCikrCigKU0VMRUNUIENvdW50KFE0X2J5KQpGUk9NIGRvbmVfYnkKV0hFUkUgUTRfYnkgPSAnbWUnIAopKSBBUyBNZUNvdW50LAooKApTRUxFQ1QgQ291bnQoUTFfYnkpCkZST00gZG9uZV9ieQpXSEVSRSBRMV9ieSA9ICd5b3UnIAopKwooClNFTEVDVCBDb3VudChRMl9ieSkKRlJPTSBkb25lX2J5CldIRVJFIFEyX2J5ID0gJ3lvdScgCikrCigKU0VMRUNUIENvdW50KFEzX2J5KQpGUk9NIGRvbmVfYnkKV0hFUkUgUTNfYnkgPSAneW91JyAKKSsKKApTRUxFQ1QgQ291bnQoUTRfYnkpCkZST00gZG9uZV9ieQpXSEVSRSBRNF9ieSA9ICd5b3UnIAopKSBBUyBZb3VDb3VudApGUk9NIGRvbmVfYnkKCgoKCjs=