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-68053fbd92b48435370341/] Input Data for table T2: [crayon-68053fbd92b55108181318/] Expected Output: [crayon-68053fbd92b57232085638/] Create two sample tables: [crayon-68053fbd92b59408239429/] Insert sample records: [crayon-68053fbd92b5c732043344/] Solution: [crayon-68053fbd92b5e988966427/] Please try the different solution for this puzzle and share it via […]

January 16, 2018 3 SQL Puzzle