How To Compute Volume analysis using Groovy?

1
2

import groovy.transform.TypeChecked
import static groovy.sql.Sql.newInstance

1
2

def sql = newInstance("jdbc:mysql://localhost:3306/mydatabase", "username", "password")
def data = sql.firstRow("SELECT volume FROM transactions WHERE date = '2022-01-01'")

1
2
3
4
5

def totalVolume = data.volume
def averageVolume = sql.firstRow("SELECT AVG(volume) FROM transactions")
def maxVolume = sql.firstRow("SELECT MAX(volume) FROM transactions")

// You can perform other calculations as needed

1
2
3

println "Total Volume: $totalVolume"
println "Average Volume: $averageVolume"
println "Maximum Volume: $maxVolume"