I am having issues with constructing a sql query (see below)
<code> SELECT
g.col1,
g.col2
g.col3,
g.col4,
SUM(num1) ,
SUM(num2) ,
SUM(num3)
FROM tablename g
WHERE 1=1
AND g.col1 IN ( 'name1','name2')
AND g.col2 IN
('proc0','proc1','proc2','proc3','proc4','proc5'
)
AND g.col4 IN ( '2024-04-30')
GROUP BY 1,2,3,4
ORDER BY 2,1 desc;
</code>
<code> SELECT
g.col1,
g.col2
g.col3,
g.col4,
SUM(num1) ,
SUM(num2) ,
SUM(num3)
FROM tablename g
WHERE 1=1
AND g.col1 IN ( 'name1','name2')
AND g.col2 IN
('proc0','proc1','proc2','proc3','proc4','proc5'
)
AND g.col4 IN ( '2024-04-30')
GROUP BY 1,2,3,4
ORDER BY 2,1 desc;
</code>
SELECT
g.col1,
g.col2
g.col3,
g.col4,
SUM(num1) ,
SUM(num2) ,
SUM(num3)
FROM tablename g
WHERE 1=1
AND g.col1 IN ( 'name1','name2')
AND g.col2 IN
('proc0','proc1','proc2','proc3','proc4','proc5'
)
AND g.col4 IN ( '2024-04-30')
GROUP BY 1,2,3,4
ORDER BY 2,1 desc;
that produces an output of such that has all col 1 singular instance of col 2 ordered as last or first(as seen in the table below).
| col1 | col2 | col3 |
|---|---|---|
| name1 | proc1 | Three |
| name2 | proc1 | Three |
| name1 | proc2 | Three |
| name2 | proc2 | Three |
| name1 | proc5 | Three |
| name2 | proc5 | Three |
| name1 | proc0 | Three |
| name1 | proc4 | Three |