With the native JSON features in SQL Server 2016, the landscape changes and using SQL Server in an Event Sourcing scenario becomes realistic. However, how would you query JSON from a database table?

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...