Stock Data analysis

You should answer the following questions through SQL queries with the table gold.g_ticker_value.

Descriptive Statistics

Calculate the average closing price, highest closing price, lowest closing price, and total trading volume for each stock in the dataset.

Determine the number of trading days and average daily trading volume for each stock in the dataset.

Calculate the correlation coefficient between the closing prices of two specific stocks

Compute the standard deviation of closing prices for each stock to measure its volatility.

Identify the top 5 most volatile stocks based on the standard deviation of their daily returns (LAG 5 days).

Retrieve the top 10 performing stocks based on their cumulative returns over a specific period.