Viewing profile — slc

"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…

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 dicato…

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…

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…

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 …

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…

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.