在同一查询中选择并插入查询记录

Question

SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
CASE WHEN credit > debit
THEN SUM( credit - debit ) 
END AS del, price, created
FROM accounts
WHERE created
BETWEEN  '2013-11-04'
AND  '2013-11-11'
AND description LIKE  '%Amount Earned%'
OR description =  'S'
OR description =  'B'
GROUP BY user_id

1. 此查询的问题是，此查询正在根据user_id从accounts表中选择所有记录。我希望选择仅在“2013-11-04”和“2013-11-11”之间创建的记录。
2. 我希望选择这些记录，并需要在同一个查询中插入记录。

要求:我想从上周由user_id、Sum (借方)和Sum(贷方)和Del ->(贷方借方)组成的帐户表中选择记录，并将和和插入到相同的帐户表中。

Answer 1

insert into (other table ) 
  SELECT user_id, description, SUM( Credit ) AS cre, SUM( debit ) AS deb, 
     CASE WHEN credit > debit
     THEN SUM( credit - debit ) 
  END AS del, price, created
FROM accounts
WHERE 
( created BETWEEN  '2013-11-04' AND  '2013-11-11' )
AND
( description LIKE  '%Amount Earned%'
  OR description =  'S'
  OR description =  'B' )
GROUP BY user_id, created