In this advanced SQL course, you will learn how to add if-else logic to queries using CASE statements and how to use string functions to get exactly the portion of text you need. Subqueries allow you to dynamically pull data from anywhere in a database and use that result within another query. Yo...