The information you need is sometimes split across multiple tables in the database. In the fortune500 data, industry contains some missing values. Use coalesce() to use the value of sector as the ...
-- 10.50.6525 SP3 + HF 2/9/2015 http://support.microsoft.com/kb/3033860 -- Security Update for SQL Server 2008 R2 SP3 (KB4057113) https://www.microsoft.com/en-us ...