This query returns the GVKEYs and the Company Names for U.S. and Canadian companies with fundamental data. Note:To get fundamental data for active companies use: WHERE ( A.costat = A ), To get fundamental data for inactive companies use: WHERE ( A.costat = I ). To get the number of active and inactive Canadian companies with fundamental data available for the 2012 fiscal year use: AND ( b.datadate = 6/30/2012 AND b.datadate = 5/31/2013 )