Can we create output port in SQ. and Can we write group by clasue in SQ

NOTE : [This question was asked by yvreddy]