CORR

1
SELECT
2
  ROUND(CORR(units_sold, price), 3) as price_sales_corr
3
FROM products;

1
SELECT
2
  ROUND(CORR(revenue, marketing_spend), 3) as revenue_marketing,
3
  ROUND(CORR(revenue, num_employees), 3) as revenue_employees,
4
  ROUND(CORR(revenue, customer_count), 3) as revenue_customers
5
FROM company_metrics;

1
SELECT
2
  category,
3
  COUNT(*) as sample_size,
4
  ROUND(CORR(rating, price), 3) as rating_price_corr
5
FROM products
6
GROUP BY category
7
HAVING COUNT(*) >= 30;