Formatting - player BMI
In this exercise, you are working with a team on a data analytics project, which has been asked to provide some statistics on NBA players to a health care company. You want to create a query that returns the Body Mass Index (BMI) for each player from North America.
$$BMI = \dfrac{weight (kg)}{height (cm)^2}$$
A colleague has passed you a query he was working on:
select PlayerName, Country,
round(Weight_kg/SQUARE(Height_cm/100),2) BMI
from Players Where Country = 'USA'
Or Country = 'Canada'
order by BMI
To make some sense of the code, you want to structure and format it in a way that is consistent and easy to read.
Diese Übung ist Teil des Kurses
Improving Query Performance in SQL Server
Anleitung zur Übung
- Change all SQL syntax (clauses, operators, and functions) to UPPERCASE.
- Make sure all SQL syntax begins on a new line.
- Add an indent to the calculated
BMIcolumn andORstatement.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
select PlayerName, Country,
round(Weight_kg/SQUARE(Height_cm/100),2) BMI
from Players Where Country = 'USA'
Or Country = 'Canada'
order by BMI;