Sort by column which is aggregate function

[gneb]

if i have this column

->withColumn('MAX(column.status)', 'status')

how can i able to sort by this

->orderBy("MAX(column.status)", "ASC")

it does not include MAX function in sort so sql does not work