Case Statement and Decode in SQL | Snowflake Case Statement

#sql #sqlinterviewquestionsandanswers #sqlinterviewquestions #sqllearning #learningvideos #learning

Case Statement Use Case
-------------Sample Data:
CREATE TABLE VACCINE_DETAILS(NAME VARCHAR2(100),
DOSES NUMBER);

INSERT INTO VACCINE_DETAILS VALUES('Praveen',1);
INSERT INTO VACCINE_DETAILS VALUES('KuMAR',2);
INSERT INTO VACCINE_DETAILS VALUES('RAJ',3);
INSERT INTO VACCINE_DETAILS VALUES('Ravi',4);
INSERT INTO VACCINE_DETAILS VALUES('Suresh',0);
INSERT INTO VACCINE_DETAILS VALUES('RaJU',5);