tree 81fff91de7d75875e138c52166d9050047b1f3fb
parent a0cab761b851fe2df8e2ca6f66656fcaa286d16c
author Conor <cpdeethree@users.noreply.github.com> 1655480868 -0500
committer GitHub <noreply@github.com> 1655480868 +0530
gpgsig -----BEGIN PGP SIGNATURE-----
 
 wsBcBAABCAAQBQJirKIkCRBK7hj4Ov3rIwAA+ukIAHIjMUW+IOno2MBpMbnjHBHs
 Rcfz66UxPITiQYToJsxe1djzU0t8ynzcVPy3TuyCieUXH2ZheL2ge4U2YR+/AYY2
 qWMngVgJ9Dj1dxMiqQRYAjqZ4hi5vW44lc5xUK6XDZiXCnDf33Sf7RyxCnDCTgzg
 zwtRYCxQNAOrMwvNS5eNd6fX7u0hUB+89evS08S0k2SWmUGr1YcbCuNrXXi6jDOv
 /hUGutbqH7mPEtGS+ALK0/ykxgJEbXab9xHrYzgeLC+ae9I+R6igiwP0SRAGFbWS
 l7x3bw47K0y88m7pwMJtqT9Ui+FXBb+7e93vdkP++AsF2dOU5bYfTJ10+OPlvx0=
 =AK4J
 -----END PGP SIGNATURE-----
 

refactor: if() to CASE WHEN (#31360)

* refactor: if() to CASE WHEN

* fix: remove duplicate order by

* fix: remove extraneous table

* style: reformat to black spec

Co-authored-by: Ankush Menat <ankush@frappe.io>