SQL Puzzle: SQL Advance Query – Calculate SUM between Two Tables

Check the below input data and expected output for calculating SUM between two tables in SQL Server. Input Data for table T1: [crayon-6a9529c191660762657867/] Input Data for table T2: [crayon-6a9529c191662836115217/] Expected Output: [crayon-6a9529c191663247968271/] Create two sample tables: [crayon-6a9529c191664220025587/] Insert sample records: [crayon-6a9529c191665351129229/] Solution: [crayon-6a9529c191666082046964/] Please try the different solution for this puzzle and share it via […]

January 16, 2018 SQL Puzzle