#NEWLINE# def _case_cte_factor_distinct_but_equal( self ) : #NEWLINE# #INDENT# t = self . con . table ( 'alltypes' ) #NEWLINE# tt = self . con . table ( 'alltypes' ) #NEWLINE# expr1 = t . group_by ( 'g' ) . aggregate ( t . f . sum ( ) . name ( 'metric' ) ) #NEWLINE# expr2 = tt . group_by ( 'g' ) . aggregate ( tt . f . sum ( ) . name ( 'metric' ) ) . view ( ) #NEWLINE# expr = expr1 . join ( expr2 , ( expr1 . g == expr2 . g ) ) [ [ expr1 ] ] #NEWLINE# return expr