#NEWLINE# def _case_aggregate_count_joined( self ) : #NEWLINE# #INDENT# region = self . con . table ( 'tpch_region' ) #NEWLINE# nation = self . con . table ( 'tpch_nation' ) #NEWLINE# join_expr = ( region . r_regionkey == nation . n_regionkey ) #NEWLINE# joined = region . inner_join ( nation , join_expr ) #NEWLINE# table_ref = nation [ ( nation , region . r_name . name ( 'region' ) ) ] #NEWLINE# return table_ref . count ( )