-- Output will be same but if the new 'state' gets added or removed from the database then we don't have to enter it manually. This query -- will take care of it and that's why this is Dyanmic.

Relational tables store one value per row — freight per order, sales per order line, a score per student per exam. This is the correct normalized form for storage and querying. But for reporting, ...

You will often find that data stored in rows in normalized tables isn't in the prettiest form to display to an end user. Often, data will make more of an impact if it is displayed as a single row for ...