MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the COUNT function in MSSQL, and how do you use it?

How do you use the SUM function in MSSQL?

What is the AVG function in MSSQL, and how is it used?

How do you use the MIN function in MSSQL, and what does it do?

How do you find the maximum value in a column using the MAX function in MSSQL?

How do you combine COUNT, SUM, AVG, MIN, and MAX functions in a single query in MSSQL?

How do you use aggregate functions with the GROUP BY clause in MSSQL?

How do you use the HAVING clause with aggregate functions in MSSQL?

How do you handle NULL values in aggregate functions in MSSQL?

Explain a scenario where using COUNT, SUM, AVG, MIN, and MAX functions is crucial for a business application in MSSQL and describe how you would implement it.