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-6a23780560736757262392/] Input Data for table T2: [crayon-6a23780560738047421617/] Expected Output: [crayon-6a23780560739713822298/] Create two sample tables: [crayon-6a2378056073a522511448/] Insert sample records: [crayon-6a2378056073b351589206/] Solution: [crayon-6a2378056073c334354329/] Please try the different solution for this puzzle and share it via […]

January 16, 2018 SQL Puzzle