Case Statement and Decode in SQL | Snowflake Case and Decode #sqlvideos

#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);