slc's comments

"folks" aren't thinking straight ? This sort of attitude is a huge part of the problem. This is why people don't seek mental help - dehumanization.

The army officials who deny mental health care to soldiers who later completely unpredictably off themselves at a rate higher than combat casualties must have read some of the same literature.

This is stupid. And I can't believe it doesn't sound stupid to those who are the most likely to attempt suicide seriously.

Why doesn't anyone talk about "misery prevention" ?

You forgot to compare the treatment of the russian speaking people in the baltic states to the treatment of jews in the nazi germany. Both were treated poorly.

No, I haven't. I live in Latvia. I'm sure that the older generation of Estonians don't like the russians, because they blame them for the ~50 years of life under a communist dicatorship, the relatives lost in the siberian death camps and so on. But comparing this dislike to the history of slavery and segregation, linchings and so on of african americans seems stupid and the qualification of "to some extent" doesn't remedy that. Again, can't really speak about Estonia, if you would claim that the russian speaking people can't sit in the front of the bus, I wouldn't be able to refute it other than to express my sincere disbelief.

If you're 15, then you have already received free government funded latvian language courses for 9 years in school. It's part of the curriculum. You'd have to be especially lazy to not be able to pass the citizenship exams.

Can't speak about Estonia but in case of Latvia the idea of russian speaking people emigrating because of hostility is just ridiculous.

There are already local "franchises" of the large companies like Tietonator and Accenture. The computer science department of the Latvian University, which provides free government funded education in computer science is basically controlled by stock holders of such large offshoring companies. The problem is - the country is very small. About 2 million people. So even taking into account the free education, the absolute number of competent programmers will be quite small. It is already a challenge to find employees for basic web development positions.

Mixing in the non-citizens in a discussion about demographics seems wrong. Most of the non-citizens are people around retirement age - factory workers who were sent in the country from other soviet countries, military families and so on. The cause for reduction in numbers of non-citizens is simple - they died.

Also claiming that they have an incentive to leave the country seems wrong, because the requirements to acquire citizenship are so easy. You just have to prove that you understand the Latvian language at a very basic level. If you can do that, then you get citizenship. Much easier than moving to a different country.

In your example, for each row of the result set

* "em.departmentId" will contain one of the distinct values from the "departmentId" column

* "salary" will contain the maximum value of the "salary" column of the table rows whose "departmentId" equals "em.departmentId" of the given result set row.

* "em.EmployeeID" will contain the value of the "EmployeeID" column of one the table rows, whose "departmentID" equals "em.departmentId" of the given result set row, but it is UNDEFINED which one. It IS NOT quaranteed to be the one whose "salary" column equals "MAX(salary)".

See here for examples of how to achieve what is actually needed: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-colum...

As I said, tricky, and, judging from the difficulty level of the other questions, I suspect that the authors of the article have fallen for it themselves.

Probably not the best idea to group on the Departments.Name instead of Departments.DepartmentId ..

The second question is actually trickier than one might think.

The obvious answer - something like

select Name, MAX(Salary) from Employees group by DepartmentId

is wrong.