Exercise

EXPLAINing query behavior

Many times, queries have a different execution plan than you might expect. Earlier in the course, you ran a query to get all the December readings for air_temp in Coffee County for the regular report type FM-15. You used a CTE to limit it to the dates and then a select statement to filter the report types so it would be easy to shift timelines via the CTE. Let's look at an explanation of that statement.

Instructions

100 XP

Run EXPLAIN on the entire statement.
Update the temp_reading condition to be between Nov 1st and 30th of 2023.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise