YAQL Queires Examples

"employees": [{
"name": "abc1",
"age": 35,
"salary": 450000,
"department": 1
},
...
{
"name": "abc10",
"age": 25,
"salary": 50000,
"department": 2
}

To find distinct employee names

$.employees.select($.name).distinct()

To find low salary employee in each department

$.employees.groubBy($.department).select([$.name, min($.salary)])
                

Sort by department and followed by employee name.

$.employees.orderBy($.department).thenBy($.name)
                

Fileter only employees in department is 1

$.employees.where($.department = 1)