Exercise

STATISTICS TIME in queries

A friend is writing a training course on how the command STATISTICS TIME can be used to tune query performance and asks for your help to complete a presentation. He requires two queries that return NBA team details where the host city had a 2017 population of more than two million. Both queries use the NBA Season 2017-2018 and Earthquakes databases.

Each query uses a different filter on the Teams table.

Query 1

Filters the Teams table using IN and three sub-queries

Query 2

Filters the Teams table using EXISTS

Instructions 1/4

XP

1
2
3
4

Turn on STATISTICS TIME.

Take Hint (-7 XP)