adonisjs query builder code example

Example 1: adonis js sort by

await DataBase.query().orderBy('u.username','desc');

Example 2: adonis andwhere

payments.where('amount', '>', 1000).andWhere('type', 'CASH')