The following sample SQL query retrieves the count of CompanyIDs within S&P Capital IQ Latest Financials with non-Null revenue for each Calendar Year and groups them into revenue bands of less than 10 million, between 10 and 50 million, and greater than 50 million. All revenue figures are converted to USD