added test case for layer+floor sql query