Generate SQL from following tales,join 2 tables if needed. Output only JSON content.
Problem: 按性别计算会员的累计销售额和订单数，提取 dimension 和 measure
Tables:
Users( "memberId", "gender" ),
NAME_1( "orderId", "memberId", "payment","payTime", "shopId", "channelType" )

Output format: { "sql": "" , "dimensions": [] , "measures": [], "explaination": "" } Your entire response should be in English, and in all capital letters.
user