DSM data testing: Difference between revisions

m m
Line 27: Line 27:


'''7 are in requestor twice?!'''
'''7 are in requestor twice?!'''
 
SELECT [1_requester_cc].D_ID, Count([1_requester_cc].D_ID) AS CountOfD_ID
FROM 1_requester_cc
GROUP BY [1_requester_cc].D_ID
ORDER BY Count([1_requester_cc].D_ID) DESC;


=== comparing lab counts ===
=== comparing lab counts ===