(Solved): gold prices Table Use the following table for these queries. Table name: gold_prices 4. Write a SQ ...

gold prices Table Use the following table for these queries. Table name: gold_prices 4. Write a SQL statement which returns the average price on a Monday. The statement should group results by the day_of_week, month, and year and order the results by the year. Include the average and the day_of_week,month and year columns in the SELECT list. 5. Write a SQL statement which returns the average gold price grouped by year. The statement should contain the average and the year column in the SELECT list. 6. Write a \( S Q L \) statement which returns the average price grouped by year and day_of_week. Include the year and average price in the SELECT list. Show this result only for the years \( 1965,1975,1985 \), and 1995.