Question: I desperately need to build 64-bit of my application since Google Play does not accept 32-bit apps anymore. Mono builds just fine but when I switch to IL2CPP it says it can't locate NDK. **However, NDK is automatically installed via \*\*Unity Hub**.\*\* 

I saw similar posts regarding to NDK in previous versions of Unity but I thought this would be fixed by now with latest Unity version. I have also tried to use a different NDK but I was still getting the same error.

Please help....

Answer: 
The error means that you are missing a `group by` clause:

```
select designation, max(salary) 
from empsalary 
where designation = 'manager' or designation = 'clerk'
group by designation 

```

If you need the ids of clerks and managers with the maximum salary, you must join this query to the table:

```
select empid, designation, salary
from empsalary e inner join (
    select designation, max(salary) 
    from empsalary 
    where designation = 'manager' or designation = 'clerk'
    group by designation
) g on g.designation = e.designation and g.salary = e.salary

```
You don't need the empid in the select part of your query.
Move the `designation` field to this part.

```sql
SELECT designation, Max(salary)
FROM   empsalary
WHERE  designation = 'manager' OR designation = 'clerk' 
GROUP BY designation ;

```

The output should be 2 rows (assuming there is at least one record with 'manager' and 'clerk' values).