Must contain at least one string or date column and one numeric column.

Column	Type
First	string or date
Other	numeric

Examples

✨ Example

The first column, city, is a string. The second column, population, is numeric.

select city, population
from population

✨ Example

The first column, dname, is a string. The additional columns are numeric.

select	dname				as "Department"
,		sum(ifnull(sal,0))	as "Total Salary"
,		avg(ifnull(sal,0))	as "Average Salary"
from emp right join dept on emp.deptno = dept.deptno
where (dname like httpGet['dname'] or httpGet['dname'] is null)
and (dname like shortCodeParam['dname'] or shortCodeParam['dname'] is null)
group by dname
order by dname