Скачать или смотреть Azure Data Explorer - Turn SQL to KQL In Seconds!!!

‪@SQLBalls‬ walks you through how to turn your T-SQL Statements into KQL in seconds using the EXPLAIN command. We use the Retrosheets.org baseball dataset to determin the number of Triple Plays that have occcured from 1922 to 2016.

Why just 2016? That's the last time the Cub won the World Series!

Links:
RetroSheet.org
https://www.retrosheet.org/


Query data using T-SQL
https://learn.microsoft.com/en-us/azu...

Chapters
00:00 Introduction
00:15 About the Channel
00:41 Content to cover
02:12 TO THE DEMO
03:18 Explain & Select Count(*)
04:32 Home Team & Away Team info
05:06 Create a Table Based off a Query
06:09 Union Command
07:23 Sum() & Group By
07:51 What Is a Triple Play
08:11 Creating Final Table
08:47 Self Join Cast to Decimal & Create a Percentage
09:34 Wrap it Up