Зарплаты H1B программистов

Скачиваем фаил www.foreignlaborcert.doleta.gov/...b_iCert_LCA_FY2011_Q4.mdb.
Конвертируем в MySql например вот этой прожкой: www.bullzip.com/products/a2m/info.php
Заливаем дамп в базу.
Играем с запросами.

Средние ЗП программистов в гугле:

mysql> select avg(LCA_CASE_WAGE_RATE_FROM) from h1b where LCA_CASE_EMPLOYER_NAME like '%GOOGLE%' and LCA_CASE_JOB_TITLE like '%SOFTWARE%' and LCA_CASE_WAGE_RATE_UNIT = 'Year';
+------------------------------+
| avg(LCA_CASE_WAGE_RATE_FROM) |
+------------------------------+
|             127002.776666667 |
+------------------------------+
1 row in set (0.50 sec)

Средние ЗП программистов в фейсбуке:

mysql> select avg(LCA_CASE_WAGE_RATE_FROM) from h1b where LCA_CASE_EMPLOYER_NAME like '%FACEBOOK%' and LCA_CASE_JOB_TITLE like '%SOFTWARE%' and LCA_CASE_WAGE_RATE_UNIT = 'Year'; 
+------------------------------+
| avg(LCA_CASE_WAGE_RATE_FROM) |
+------------------------------+
|             112699.306748466 |
+------------------------------+
1 row in set (0.52 sec)

Средние ЗП программистов в амазоне:

mysql> select avg(LCA_CASE_WAGE_RATE_FROM) from h1b where LCA_CASE_EMPLOYER_NAME like '%AMAZON%' and LCA_CASE_JOB_TITLE like '%SOFTWARE%' and LCA_CASE_WAGE_RATE_UNIT = 'Year';+------------------------------+
| avg(LCA_CASE_WAGE_RATE_FROM) |
+------------------------------+
|             100463.294117647 |
+------------------------------+
1 row in set (0.48 sec)

Средние ЗП программистов в епаме:

mysql> select avg(LCA_CASE_WAGE_RATE_FROM) from h1b where LCA_CASE_EMPLOYER_NAME like '%EPAM%' and LCA_CASE_JOB_TITLE like '%SOFTWARE%' and LCA_CASE_WAGE_RATE_UNIT = 'Year';
+------------------------------+
| avg(LCA_CASE_WAGE_RATE_FROM) |
+------------------------------+
|             72310.7142857143 |
+------------------------------+
1 row in set (0.49 sec)

Средние ЗП программистов в luxoft-e:

mysql> select avg(LCA_CASE_WAGE_RATE_FROM) from h1b where LCA_CASE_EMPLOYER_NAME like '%LUXOFT%' and LCA_CASE_JOB_TITLE like '%SOFTWARE%' and LCA_CASE_WAGE_RATE_UNIT = 'Year';
+------------------------------+
| avg(LCA_CASE_WAGE_RATE_FROM) |
+------------------------------+
|                        95000 |
+------------------------------+
1 row in set (0.44 sec)

enjoy
eom