What is a result of the query below for table with 10 rows when there are 2 clients with the headcount column having a NULL value, there are 7 customers with 1 head and 1 customer with 2 heads?
SELECT SUM(headcount) FROM clients
/*
ClientId
HeadCount
1
1
2
NULL
3
1
4
2
5
1
6
NULL
7
1
8
1
9
1
10
1
*/
Experience Level: Not defined
Tags: DatabasesSQL
Answer
Related Databases job interview questions
What is the processing order of logical parts of the following query?
DatabasesSQL Not definedWhen you use SQL Server, what is a difference between local and global temporary table?
DatabasesMS SQL ServerSQL Not definedWhat is a result of the following query for table with 10 rows when there are 2 clients with the name column having a NULL value?
DatabasesSQL Not defined