Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
onlinedb [2022/03/09 11:35] qcbs [Exercise 3 - SELECT statement] |
onlinedb [2022/03/09 11:38] (current) qcbs [Exercise 4 - GROUPING] |
||
|---|---|---|---|
| Line 451: | Line 451: | ||
| **Question 5** :?: - Which province has the lake with the highest maximum temperature (column tmax_ann)? | **Question 5** :?: - Which province has the lake with the highest maximum temperature (column tmax_ann)? | ||
| - | \\ ++answer| BRITISH COLUMBIA 14.60 ++ \\ | + | \\ ++answer| SELECT province, max(tmax_ann) FROM lakes GROUP BY province ORDER BY max DESC LIMIT 1; |
| + | BRITISH COLUMBIA 14.60 ++ \\ | ||
| Update statement: | Update statement: | ||
