如何使用spark sql估算基本统计组数据？

import org.apache.spark.sql.SparkSession
import org.apache.spark.sql.functions._

val spark = SparkSession.builder()
  .appName("Spark SQL Example")
  .config("spark.some.config.option", "some-value")
  .getOrCreate()

val data = spark.read.format("csv")
  .option("header", "true")
  .load("path/to/data.csv")

data.createOrReplaceTempView("myTable")

val result = spark.sql("SELECT category, COUNT(*) as count, AVG(price) as avg_price, MAX(price) as max_price, MIN(price) as min_price FROM myTable GROUP BY category")

result.show()