Chapter 5
- Write a query for our
EnglishPremierLeague
data and aggregate the number of matches refereed by each referee.
Answer:
EnglishPremierLeague | summarize matches_refereed = count() by Referee
- What is the main difference between the
search
andwhere
operators?
Answer: The search
operator is simple and convenient to use, but you need to be careful with regard to the scope of the search. Searching across multiple tables and columns is an expensive operation and can cause performance issues.
- Aggregate all the event types in the
StormEvents
table forCalifornia
and render the results as a column chart.
Answer:
StormEvents | where State =~ "California" | summarize event=count() by EventType | render columnchart
- What type of join should you use if you want to include duplicate common column matches in the result set?
Answer: The inner
join returns all matches.