SELECT
        [Activity - Send Email].[id],
        [Activity - Send Email].[Mailing_ID],
        [Activity - Send Email].[Campaign_Run_ID],
        [Activity - Send Email].[Choice_Number],
        [Activity - Send Email].[Has_Predictive],
        [Activity - Send Email].[Step_ID],
        [Activity - Send Email].[Test_Variant],
        [Activity - Send Email].[Lead_ID],
        [Activity - Send Email].[Campaign_ID],
        [Activity - Send Email].[Activity_Date]
FROM
        [activity6] AS [Activity - Send Email]

SELECT
        [Campaigns].[id] AS [id (Campaigns)],
        [Campaigns].[name],
        [Campaigns].[description],
        [Campaigns].[programName],
        [Campaigns].[programId],
        [Campaigns].[workspaceName],
        [Campaigns].[createdAt],
        [Campaigns].[updatedAt],
        [Campaigns].[active]
FROM
        [campaignsTable] AS [Campaigns]

SELECT
        [Activity - Email Delivered].[id] AS [id (Activity - Email Delivered)],
        [Activity - Email Delivered].[Mailing_ID] AS [Mailing_ID (Activity - Email Delivered)],
        [Activity - Email Delivered].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Email Delivered)],
        [Activity - Email Delivered].[Choice_Number] AS [Choice_Number (Activity - Email Delivered)],
        [Activity - Email Delivered].[Has_Predictive] AS [Has_Predictive (Activity - Email Delivered)],
        [Activity - Email Delivered].[Step_ID] AS [Step_ID (Activity - Email Delivered)],
        [Activity - Email Delivered].[Test_Variant] AS [Test_Variant (Activity - Email Delivered)],
        [Activity - Email Delivered].[Lead_ID] AS [Lead_ID (Activity - Email Delivered)],
        [Activity - Email Delivered].[Campaign_ID] AS [Campaign_ID (Activity - Email Delivered)],
        [Activity - Email Delivered].[Activity_Date] AS [Activity_Date (Activity - Email Delivered)]
FROM
        [activity7] AS [Activity - Email Delivered]

SELECT
        [Activity - Open Email].[id] AS [id (Activity - Open Email)],
        [Activity - Open Email].[Mailing_ID] AS [Mailing_ID (Activity - Open Email)],
        [Activity - Open Email].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Open Email)],
        [Activity - Open Email].[Choice_Number] AS [Choice_Number (Activity - Open Email)],
        [Activity - Open Email].[Device],
        [Activity - Open Email].[Has_Predictive] AS [Has_Predictive (Activity - Open Email)],
        [Activity - Open Email].[Is_Mobile_Device],
        [Activity - Open Email].[Platform],
        [Activity - Open Email].[Step_ID] AS [Step_ID (Activity - Open Email)],
        [Activity - Open Email].[Test_Variant] AS [Test_Variant (Activity - Open Email)],
        [Activity - Open Email].[User_Agent],
        [Activity - Open Email].[Lead_ID] AS [Lead_ID (Activity - Open Email)],
        [Activity - Open Email].[Campaign_ID] AS [Campaign_ID (Activity - Open Email)],
        [Activity - Open Email].[Activity_Date] AS [Activity_Date (Activity - Open Email)]
FROM
        [activity10] AS [Activity - Open Email]

SELECT
        [Activity - Click Email].[id] AS [id (Activity - Click Email)],
        [Activity - Click Email].[Mailing_ID] AS [Mailing_ID (Activity - Click Email)],
        [Activity - Click Email].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Click Email)],
        [Activity - Click Email].[Choice_Number] AS [Choice_Number (Activity - Click Email)],
        [Activity - Click Email].[Device] AS [Device (Activity - Click Email)],
        [Activity - Click Email].[Is_Mobile_Device] AS [Is_Mobile_Device (Activity - Click Email)],
        [Activity - Click Email].[Is_Predictive],
        [Activity - Click Email].[Link],
        [Activity - Click Email].[Link_ID],
        [Activity - Click Email].[Platform] AS [Platform (Activity - Click Email)],
        [Activity - Click Email].[Step_ID] AS [Step_ID (Activity - Click Email)],
        [Activity - Click Email].[Test_Variant] AS [Test_Variant (Activity - Click Email)],
        [Activity - Click Email].[User_Agent] AS [User_Agent (Activity - Click Email)],
        [Activity - Click Email].[Lead_ID] AS [Lead_ID (Activity - Click Email)],
        [Activity - Click Email].[Campaign_ID] AS [Campaign_ID (Activity - Click Email)],
        [Activity - Click Email].[Activity_Date] AS [Activity_Date (Activity - Click Email)]
FROM
        [activity11] AS [Activity - Click Email]