1. $query = new Query;              
2. $query->select('ID, City,State,StudentName') 
3.       ->from('student')                                
4.       ->where(['IsActive' => 1]) 
5.       ->andWhere(['not', ['City' => null]]) 
6.       ->andWhere(['not', ['State' => null]]) 
7.       ->orderBy(['rand()' => SORT_DESC]) 
8.       ->limit(10);