Assessment 2.md

Assessment 2

Go To http://www.sqlfiddle.com/#!18/04905/295

Ensure in the top left by the logo it shows MS SQL Server 2017.

Write a SQL query that does the following:

1. Selects "username" and "deathyear" for stooges who died after than 1970 or are still alive
2. If stooge is still alive, use "N/A" as the deathyear.

NOTE: Username is defined as "last_name, first_name middle_name"

Completion

Email us your SQL query and a screen shot of the data output table.