Untitled

SQL - joining 2 subqueries of total and weekly total
SELECT user_id,sum(amount) AS total_amount
FROM sales
LEFT JOIN users
ON sales.user_id = users.id
WHERE users.department = 1
GROUP BY user_id

SELECT user_id,sum(amount) AS total_amount
FROM sales
LEFT JOIN users
ON sales.user_id = users.id
WHERE users.department = 1 AND date > (NOW()-INTERVAL 1 WEEK)
GROUP BY user_id

SELECT  user_id
,       sum(amount) as total
,       sum(case when date > (NOW()-INTERVAL 1 WEEK) then amount end) as weekly
FROM    sales
LEFT JOIN
        users
ON      sales.user_id = users.id
WHERE   users.department = 1
GROUP BY
        user_id