Apache Drill - SQL Operator BETWEEN

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select name,age,addr from dfs.`/Users/../workspace/Drill-samples/student_list.json`
   where mark1 between 50 and 70;

Result

name  age      addr
Adam  12  23 new street
Bob   12  10 cross street
David 12  15 express avenue
Esha  12  20 garden street
Jack  13  2 park street