Идентичность запроса

CREATE TABLE dbo.myTable1 ([column_id1] INT, [column_id2] INT, [column3] INT, [column4] INT);
INSERT INTO dbo.myTable1 VALUES
(1,1,10,100),(1,2,20,200),(2,1,30,300),(2,2,40,400),(1,1,10,100),(1,2,20,200),(2,1,30,300),(2,2,40,400);
 
CREATE TABLE dbo.myTable2 ([column_id1] INT, [column5] VARCHAR(4));
INSERT INTO dbo.myTable2 VALUES
(1,'a'), (2,'b'), (3,'c'), (4,'d');
 
CREATE TABLE dbo.myTable3 ([column_id2] INT, [column6] VARCHAR(4));
INSERT INTO dbo.myTable3 VALUES
(1,'aa'), (2,'bb');

SELECT
    t1.[column_id2]
    ,SUM(t1.[column3]) AS [column3]
FROM
    dbo.myTable1 t1
INNER JOIN
    dbo.myTable2 t2
ON
    t1.[column_id1] = t2.[column_id1]
    AND
    t2.[column5] = 'a'
INNER JOIN
    dbo.myTable3 t3
ON
    t1.[column_id2] = t3.[column_id2]
    AND
    t3.[column6] = 'aa'
GROUP BY
    t1.[column_id2]
;

SELECT
    t1.[column_id2]
    ,SUM(t1.[column3]) AS [column3]
FROM
    dbo.myTable1 t1
INNER JOIN
    dbo.myTable2 t2
ON
    t1.[column_id1] = t2.[column_id1]
INNER JOIN
    dbo.myTable3 t3
ON
    t1.[column_id2] = t3.[column_id2]
WHERE
    t2.[column5] = 'a'
    AND
    t3.[column6] = 'aa'
GROUP BY
    t1.[column_id2]
;