SQL Queries||How to write a sub-query with in Case Statement in SQL?

Published --