Questions

Before moving on to the next chapter, test your knowledge by trying these exercises. The answers can be found at the back of the book.

1. Write a query for our EnglishPremierLeague data and aggregate the number of matches refereed by each referee.
2. What is the main difference between the search and where operators?
3. Aggregate all the event types in the StormEvents table for California and render the results as a column chart.
4. Which type of join should you use if you want to include duplicate common column matches in the result set?