query

1. Current Gross Profit Achievement per Salesman
SELECT SUM(A.sales_amount) AS sales_amount, ((SUM(A.sales_amount) / B.target_amount) * 100) AS sales_percentage
FROM dwh_sales A
INNER JOIN m_target_salesman B ON A.salesman_id = B.salesman_id AND B.year_month = '201701'
WHERE A.year_month = '201701'
    AND A.salesman_id = 3596
GROUP BY B.target_amount;

2.