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.
Questo esercizio fa parte del corso
Exploratory Data Analysis in SQL
Istruzioni dell'esercizio
- Compute the correlation between
revenuesandprofits. - Compute the correlation between
revenuesandassets. - Compute the correlation between
revenuesandequity.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- 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;