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.
Bu egzersiz
Exploratory Data Analysis in SQL
kursunun bir parçasıdırEgzersiz talimatları
- Compute the correlation between
revenuesandprofits. - Compute the correlation between
revenuesandassets. - Compute the correlation between
revenuesandequity.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- 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;