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.
Latihan ini adalah bagian dari kursus
Exploratory Data Analysis in SQL
Petunjuk latihan
- Compute the correlation between
revenuesandprofits. - Compute the correlation between
revenuesandassets. - Compute the correlation between
revenuesandequity.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- 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;