#sql How to handle NULL while aggregation | SUM() | AVG() | Data Analyst | Data Engineer |Math calc

Hi All,
My name is Ankit Shrivastava and I am a Data Engineer.
Today this #vlog is regarding #sql How to handle NULL while aggregation or performing any mathematical calculation.

Please find the below DDL for practice:-

create table product_sales (prd_id int,sale_amt int)
insert into product_sales values (1,100);
insert into product_sales values (2,200);
insert into product_sales values (3,null);
insert into product_sales values (4,300);


#sqlinterviewquestions #dataanalyst #dataengineering #dataanalysis

Please find the link of my all previous videos:-
#sql Calculate start & end time and average time spent in successful transaction | startup interview
Link https://youtu.be/7uo450TmTak

#sql to achieve last NOT NULL value from the record | Analytical Function | Data Engg | Data Analyst
Link https://www.youtube.com/watch?v=labrMZYw1JQ&t=146s

#sql to identify Top Performing Product every Quarter of each year | Highest sale every quarter
Link https://www.youtube.com/watch?v=p98zctwvZq0&t=28s

#sql Interview Question - Calculate Running Total | Cumulative sum | UNBOUNDED PRECEDING FOLLOWING
Link https://www.youtube.com/watch?v=-_DlNOUph5c&t=249s

#sql Interview question - Schedule cricket match between teams and generate points table using SQL
Link https://lnkd.in/dsM8Pe8B

#sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values
Link https://lnkd.in/dJttWQBB

#sql Interview Question - What is the difference between COUNT(*), COUNT(1) and COUNT(-1)
Link https://lnkd.in/dVHMWxKj

#SQL Interview Question - How to delete duplicate record from table
Link https://lnkd.in/dcVyhC7X

#SQL Interview Question -Second highest salary using dense rank analytical function
Link https://lnkd.in/daBumQfB

#SQL to pull unique record after combination of column

#SELFJOIN
Link https://lnkd.in/d6tXYXCv