adonis where code example

Example 1: adonis js sort by

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

Example 2: adonis lucid join

await Database
  .table('users')
  .innerJoin('accounts', 'user.id', 'accounts.user_id')