Databases: What does Then 1 else 0 mean in a CASE expression used with an aggregate function?

Details
Title | Databases: What does Then 1 else 0 mean in a CASE expression used with an aggregate function? |
Author | Roel Van de Paar |
Duration | 1:54 |
File Format | MP3 / MP4 |
Original URL | https://youtube.com/watch?v=YTBiNjr9e1E |
Description
Databases: What does Then 1 else 0 mean in a CASE expression used with an aggregate function?
Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar
With thanks & praise to God, and with thanks to the many people who have made this project possible! | Content (except music & images) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing | Music: https://www.bensound.com/licensing | Images: https://stocksnap.io/license & others | With thanks to user Ravi (dba.stackexchange.com/users/73986), user Jonathan Fite (dba.stackexchange.com/users/46773), user Aaron Bertrand (dba.stackexchange.com/users/1186), and the Stack Exchange Network (dba.stackexchange.com/questions/120003). Trademarks are property of their respective owners. Disclaimer: All information is provided "AS IS" without warranty of any kind. You are responsible for your own actions. Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com