Correlation Function (CORR)

Problem

A statistics team wants to see if high-budget movies always translate to higher ratings. They request a correlation coefficient. Write a query that outputs concept with the value: "CORR(y, x) returns the Pearson correlation coefficient between two numeric variables, ranging from -1.0 to 1.0."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution