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
This exercise is part of the course
Improving Query Performance in SQL Server
Exercise instructions
- Add the line comment
First attempt, contains errors and inconsistent formatting
on line 2. - Block comment out your friend's query on lines 3 and 11.
- Add the line comment
Second attempt - errors corrected and formatting fixed
on line 14. - Remove the block comment syntax from your query on lines 15 and 23.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- 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;
*/