File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree Original file line number Diff line number Diff line change @@ -559,14 +559,14 @@ <h1 id="Aggregation">Aggregation<a class="anchor-link" href="#Aggregation">¶
559559</ div >
560560< div class ="cell border-box-sizing code_cell rendered ">
561561< div class ="input ">
562- < div class ="prompt input_prompt "> In [16 ]:</ div >
562+ < div class ="prompt input_prompt "> In [17 ]:</ div >
563563< div class ="inner_cell ">
564564 < div class ="input_area ">
565565< div class =" highlight hl-ipython3 "> < pre > < span > </ span > < span class ="n "> sql</ span > < span class ="o "> =</ span > < span class ="s2 "> """</ span >
566566< span class ="s2 "> SELECT</ span >
567567< span class ="s2 "> f.country_code,</ span >
568568< span class ="s2 "> MAX(r.temp) AS max_temp,</ span >
569- < span class ="s2 "> MIN(r.temp) as min_temp</ span >
569+ < span class ="s2 "> MIN(r.temp) AS min_temp</ span >
570570< span class ="s2 "> FROM readings AS r JOIN flights AS f</ span >
571571< span class ="s2 "> ON r.flight = f.name</ span >
572572< span class ="s2 "> GROUP BY f.country_code</ span >
@@ -584,7 +584,7 @@ <h1 id="Aggregation">Aggregation<a class="anchor-link" href="#Aggregation">¶
584584
585585< div class ="output_area ">
586586
587- < div class ="prompt output_prompt "> Out[16 ]:</ div >
587+ < div class ="prompt output_prompt "> Out[17 ]:</ div >
588588
589589
590590
You can’t perform that action at this time.
0 commit comments