Correlation

What's the relationship between a company's revenue and its other financial attributes? Compute the correlation between revenues and other financial variables with the corr() function.

This exercise is part of the course

Exploratory Data Analysis in SQL

View Course

Exercise instructions

Compute the correlation between revenues and profits.
Compute the correlation between revenues and assets.
Compute the correlation between revenues and equity.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Correlation between revenues and profit
SELECT ___ AS rev_profits,
	   -- Correlation between revenues and assets
       ___ AS rev_assets,
       -- Correlation between revenues and equity
       ___ AS rev_equity 
  FROM fortune500;

Edit and Run Code