I have a lot of data in my DB. i'm use Mysql.

for this case, i try to show 3rd week data by using some query:

```
SELECT Line, (SUM(S) + SUM(A) + SUM(B)*0.4 + SUM(C)*0.1)/COUNT(Serial_number) AS 3rd
FROM inspection_report
WHERE DAY(Inspection_datetime) BETWEEN 15 AND 21
GROUP BY Line, WEEK(Inspection_datetime), YEAR(Inspection_datetime)

```

but the result show as:

```
line        count
fa 01      0.0000
fa 01      0.0000
fa 02      0.0000
fa 02      0.0000
fa 03      0.0000
fa 03      0.0260

```

It makes the data show two times.Then i try this query:

```
SELECT id,A.Line,week3.3rd
FROM inspection_report AS A
LEFT JOIN(
    SELECT Line, (SUM(S) + SUM(A) + SUM(B)*0.4 + SUM(C)*0.1)/COUNT(Serial_number) AS 3rd
    FROM inspection_report
    WHERE DAY(Inspection_datetime) BETWEEN 15 AND 21
    GROUP BY Line, WEEK(Inspection_datetime), YEAR(Inspection_datetime)
    ) AS week3 USING (Line)
WHERE MONTH(Inspection_datetime) = MONTH(CURRENT_DATE)
AND YEAR(Inspection_datetime) = YEAR(CURRENT_DATE)
GROUP BY Line

```

but the result show like:

```
line                  count
fa 01                0.0000
fa 02                0.0000
fa 03                0.0000    //must be 0.0260

```

how do i do to resolve this?
thank's