Flow Control Statements: IF and CASE

Build on your knowledge of SQL statements by learning about controlling their flow.

We'll cover the following

With our running example of parts for car models, imagine that we are tasked to create a report for the assembly progress of each car model. That is, each car model should have one of three associated states: pending, in progress, or completed. Here, pending means that none of the three parts have been assembled; in progress denotes one or two parts that have been assembled. Finally, completed means that all parts have been successfully assembled.

Get hands-on with 1400+ tech skills courses.