Commenting - how many Kiwis in the NBA?
You and a friend would like to know how many New Zealanders (affectionately known as Kiwis) play in the NBA. Your friend attempts to write a query, but it is not very well formatted and contains several errors. You re-write the query, but you want to keep his original for comparison and future reference.
This exercise requires you to create line comments and comment out blocks of code
Este exercício faz parte do curso
Improving Query Performance in SQL Server
Instruções do exercício
- Add the line comment
First attempt, contains errors and inconsistent formattingon line 2. - Block comment out your friend's query on lines 3 and 11.
- Add the line comment
Second attempt - errors corrected and formatting fixedon line 14. - Remove the block comment syntax from your query on lines 15 and 23.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Your friend's query
select PlayerName, p.Country,sum(ps.TotalPoints)
AS TotalPoints
FROM PlayerStats ps inner join Players On ps.PlayerName = p.PlayerName
WHERE p.Country = 'New Zeeland'
Group
by PlayerName, Country
order by Country;
-- Your query
/*
SELECT p.PlayerName, p.Country,
SUM(ps.TotalPoints) AS TotalPoints
FROM PlayerStats ps
INNER JOIN Players p
ON ps.PlayerName = p.PlayerName
WHERE p.Country = 'New Zealand'
GROUP BY p.PlayerName, p.Country;
*/