n this assignment, you will continue to Build$/$Implement your Database in MS SQL Server. You have four tasks:

Review this source for how to create SQL SERVER JOINS Tutorial $$ INNER, LEFT, RIGHT, OUTER

Review this source for how to create SQL Server IF$...$ELSE Condition Statement $$ Learn with T$-$SQL Select Query

Review this source for how to create CASE Statement & Nested Case in SQL Server $$ Learn with T$-$SQL Example

Review this source for how to create Substring$()$ in SQL Server $$ How to use Function with Example

Using the four tasks, write SQL statements to illustrate each task using your implemented database.

What to Submit

Upload screenshots for each of the above in a Word file explaining your process and what problems you experienced.

Include ALL SQL logic used during the implementation. Code should be included in a SQL file