snoww Posted April 1, 2019 Report Share Posted April 1, 2019 4 minutes ago, ekunadam_enkanna said: Another query. Find all employers, whose denials --both initial and continuous > 100 "COGNIZANT TECH SOLNS US CORP",217,996 "TATA CONSULTANCY SVCS LTD",700,832 kummesayee Quote Link to comment Share on other sites More sharing options...
snoww Posted April 1, 2019 Report Share Posted April 1, 2019 Just now, snoww said: "COGNIZANT TECH SOLNS US CORP",217,996 "TATA CONSULTANCY SVCS LTD",700,832 kummesayee How many approvals ? Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 5 minutes ago, snoww said: How many approvals ? Quote sqlite> select employer, ia, ca, (ca + ia) as total from h2019 order by total desc limit 50; TECH MAHINDRA AMERICAS INC|475|540|1015 WIPRO LIMITED|270|652|922 INFOSYS LTD|38|828|866 MICROSOFT CORPORATION|364|485|849 GOOGLE LLC|512|240|752 LARSEN AND TOUBRO INFOTECH LTD|317|417|734 AMAZON.COM SERVICES INC|606|124|730 ERNST & YOUNG US LLP|83|627|710 CAPGEMINI AMERICA INC|135|484|619 ACCENTURE LLP|100|466|566 DELOITTE CONSULTING LLP|298|164|462 FACEBOOK INC|351|97|448 MPHASIS CORPORATION|222|218|440 APPLE INC|194|234|428 HCL AMERICA INC|31|381|412 IBM INDIA PRIVATE LIMITED|15|356|371 L&T TECH SVCS LTD|51|290|341 INTEL CORPORATION|213|115|328 CISCO SYSTEMS INC|119|201|320 JPMORGAN CHASE & CO|95|211|306 MINDTREE LIMITED|58|219|277 ORACLE AMERICA INC|99|176|275 VIRTUSA CORPORATION|80|187|267 HEXAWARE TECHNOLOGIES INC|116|142|258 IBM CORPORATION|159|82|241 QUALCOMM TECHNOLOGIES INC|201|26|227 RANDSTAD TECHNOLOGIES LLC|10|216|226 DELOITTE & TOUCHE LLP|59|149|208 KFORCE INC|68|136|204 PRICEWATERHOUSECOOPERS LLP|133|62|195 CGI TECHNOLOGIES AND SOLUTIONS INC|65|126|191 WAL-MART ASSOCIATES INC|31|153|184 SALESFORCE COM INC|45|131|176 SYNECHRON INC|34|134|168 SYNTEL INC|23|144|167 NTT DATA INC|69|97|166 COGNIZANT TECH SOLNS US CORP|158|1,717|159 PRICEWATERHOUSECOOPERS ADVISORY SE|61|98|159 COMPUNNEL SOFTWARE GROUP INC|18|132|150 BANK OF AMERICA NA|62|84|146 EPAM SYSTEMS INC|78|67|145 TESLA INC|114|26|140 UST GLOBAL INC|9|129|138 EBAY INC|76|62|138 SAP AMERICA INC|88|49|137 UBER TECHNOLOGIES INC|85|46|131 DELOITTE CONSULTING LLP|125|1,072|126 GOLDMAN SACHS & CO LLC|66|59|125 MCKINSEY & COMPANY INC US|82|36|118 PAYPAL INC|60|58|118 Quote Link to comment Share on other sites More sharing options...
tacobell fan Posted April 1, 2019 Report Share Posted April 1, 2019 Employer City and State kuda add cheyyi Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 1 hour ago, snoww said: Any column available in data for H1B dependent employer ? That will mostly give Desi Mesthris count In some ghetto way, I found a semblance of an answer. Scraped h1b dependent employers from myvisajobs.com. 4863 h1b dependent employers from 2015-2017 data from myvisajobs. Quote dep table = h1b depedent employers sqlite> select count(dep.employer) from h2019, dep where h2019.employer=dep.employer; count(dep.employer) 222 sqlite> select count(distinct dep.employer) from dep, h2018 where h2018.employer=dep.employer; "count(distinct dep.employer)" 246 select count(distinct dep.employer) from dep, h2017 where h2017.employer=dep.employer; "count(distinct dep.employer)" 245 That's not an accurate answer, since USCIS data is cleaner than myvisajobs' employers names. Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 2, 2019 Author Report Share Posted April 2, 2019 sqlite> select employer, ia, ca, (ca + ia) as total, city, state from h2019 order by total desc limit 100; EMPLOYER IA CA IA+CA CITY ST ----------------------------------------------------------------------------- TATA CONSULTANCY SVCS LTD 1177 1881 3058 ROCKVILLE MD COGNIZANT TECH SOLNS US C 158 1717 1875 COLLEGE ST TX DELOITTE CONSULTING LLP 125 1072 1197 PHILADELPH PA TECH MAHINDRA AMERICAS IN 475 540 1015 SOUTH PLAI NJ WIPRO LIMITED 270 652 922 EAST BRUNS NJ INFOSYS LTD 38 828 866 PLANO TX MICROSOFT CORPORATION 364 485 849 REDMOND WA GOOGLE LLC 512 240 752 MOUNTAIN V CA LARSEN AND TOUBRO INFOTEC 317 417 734 EDISON NJ AMAZON.COM SERVICES INC 606 124 730 SEATTLE WA ERNST & YOUNG US LLP 83 627 710 SECAUCUS NJ CAPGEMINI AMERICA INC 135 484 619 CHICAGO IL ACCENTURE LLP 100 466 566 CHICAGO IL DELOITTE CONSULTING LLP 298 164 462 BOSTON MA FACEBOOK INC 351 97 448 MENLO PARK CA MPHASIS CORPORATION 222 218 440 NEW YORK NY APPLE INC 194 234 428 CUPERTINO CA HCL AMERICA INC 31 381 412 SUNNYVALE CA IBM INDIA PRIVATE LIMITED 15 356 371 DURHAM NC L&T TECH SVCS LTD 51 290 341 EDISON NJ INTEL CORPORATION 213 115 328 CHANDLER AZ CISCO SYSTEMS INC 119 201 320 SAN JOSE CA JPMORGAN CHASE & CO 95 211 306 CHICAGO IL MINDTREE LIMITED 58 219 277 WARREN NJ ORACLE AMERICA INC 99 176 275 REDWOOD CI CA VIRTUSA CORPORATION 80 187 267 SOUTHBOROU MA HEXAWARE TECHNOLOGIES INC 116 142 258 ISELIN NJ IBM CORPORATION 159 82 241 DURHAM NC QUALCOMM TECHNOLOGIES INC 201 26 227 SAN DIEGO CA RANDSTAD TECHNOLOGIES LLC 10 216 226 WOBURN MA DELOITTE & TOUCHE LLP 59 149 208 BOSTON MA KFORCE INC 68 136 204 TAMPA FL PRICEWATERHOUSECOOPERS LL 133 62 195 TAMPA FL CGI TECHNOLOGIES AND SOLU 65 126 191 FAIRFAX VA WAL-MART ASSOCIATES INC 31 153 184 BENTONVILL AR SALESFORCE COM INC 45 131 176 SAN FRANCI CA SYNECHRON INC 34 134 168 NEW YORK NY SYNTEL INC 23 144 167 TROY MI NTT DATA INC 69 97 166 CHARLESTOW MA PRICEWATERHOUSECOOPERS AD 61 98 159 TAMPA FL COMPUNNEL SOFTWARE GROUP 18 132 150 PLAINSBORO NJ BANK OF AMERICA NA 62 84 146 CHARLOTTE NC EPAM SYSTEMS INC 78 67 145 NEWTOWN PA TESLA INC 114 26 140 PALO ALTO CA UST GLOBAL INC 9 129 138 ALISO VIEJ CA EBAY INC 76 62 138 SAN JOSE CA SAP AMERICA INC 88 49 137 NEWTOWN SQ PA UBER TECHNOLOGIES INC 85 46 131 SAN FRANCI CA GOLDMAN SACHS & CO LLC 66 59 125 JERSEY CIT NJ MCKINSEY & COMPANY INC US 82 36 118 NEW YORK NY PAYPAL INC 60 58 118 SAN JOSE CA POLARIS CONSULTING & SERV 12 105 117 PISCATAWAY NJ MORGAN STANLEY SERVICES G 34 83 117 NEW YORK NY CERNER CORPORATION 93 19 112 NORTH KANS MO COMCAST CABLE COMMUNICATI 20 91 111 PHILADELPH PA CUMMINS INC 17 90 107 NASHVILLE TN AMERICAN EXPRESS TRAVEL R 9 96 105 NEW YORK NY KPMG LLP 33 66 99 DALLAS TX VMWARE INC 52 46 98 PALO ALTO CA CITIUSTECH INC 56 39 95 PRINCETON NJ BLOOMBERG LP 28 64 92 NEW YORK NY CITIBANK NA 41 50 91 NEW YORK NY BIRLASOFT INC 46 45 91 EDISON NJ NATSOFT CORPORATION 45 45 90 SOMERSET NJ OATH HOLDINGS INC 74 15 89 SUNNYVALE CA NVIDIA CORPORATION 50 39 89 SANTA CLAR CA MARLABS INC 35 52 87 PISCATAWAY NJ KPIT INFOSYSTEMS INC 42 44 86 EDISON NJ COMPUTER SCIENCES CORPORA 71 15 86 MC LEAN VA AKAMAI TECHNOLOGIES INC 58 26 84 CAMBRIDGE MA EXLSERVICE.COM LLC 49 34 83 NEW YORK NY LINKEDIN CORPORATION 52 30 82 SUNNYVALE CA NIIT TECHNOLOGIES LIMITED 22 59 81 ATLANTA GA AMAZON WEB SERVICES INC 30 47 77 SEATTLE WA HITACHI CONSULTING CORPOR 54 22 76 DALLAS TX JOHNS HOPKINS UNIVERSITY 35 38 73 BALTIMORE MD FUJITSU AMERICA INC 42 30 72 PITTSBURGH PA NTT DATA SERVICES LLC 44 27 71 CHARLESTOW MA UNIV OF MICHIGAN 45 26 71 ANN ARBOR MI NTT DATA INC 5 65 70 BOSTON MA MASTECH DIGITAL TECHNOLOG 7 63 70 CORAOPOLIS PA THE LELAND STANFORD JR UN 30 40 70 STANFORD CA SERVICENOW INC 47 22 69 SANTA CLAR CA HEWLETT PACKARD ENTERPRIS 28 41 69 AUSTIN TX T MOBILE USA INC 23 46 69 BELLEVUE WA STATE STREET BANK & TRUST 6 61 67 BOSTON MA ANTHEM INC 14 53 67 WILMINGTON DE POPULUS GROUP LLC 25 42 67 TROY MI HEADSTRONG SERVICES LLC 16 51 67 SHORT HILL NJ COLLABERA INC 15 49 64 BASKING RI NJ CAPITAL ONE SERVICES LLC 19 44 63 HENRICO VA GENERAL MOTORS COMPANY 25 37 62 DETROIT MI OPTUM SERVICES INC 9 53 62 RICHARDSON TX I5 TECH INC 35 27 62 EDISON NJ CAPITAL ONE SERVICES LLC 4 58 62 RICHMOND VA AMERICAN AIRLINES INC 28 33 61 FORT WORTH TX BARCLAYS SERVICES CORP 21 40 61 NEW YORK NY QUEST GLOBAL SERVICES-NA 43 18 61 EAST HARTF CT CYIENT INC 32 29 61 EAST HARTF CT SAPIENT CORPORATION 10 49 59 BOSTON MA Quote Link to comment Share on other sites More sharing options...
Yaman02 Posted April 2, 2019 Report Share Posted April 2, 2019 Informative thread Quote Link to comment Share on other sites More sharing options...
snoww Posted April 2, 2019 Report Share Posted April 2, 2019 44 minutes ago, ekunadam_enkanna said: sqlite> select employer, ia, ca, (ca + ia) as total, city, state from h2019 order by total desc limit 100; EMPLOYER IA CA IA+CA CITY ST ----------------------------------------------------------------------------- TATA CONSULTANCY SVCS LTD 1177 1881 3058 ROCKVILLE MD COGNIZANT TECH SOLNS US C 158 1717 1875 COLLEGE ST TX DELOITTE CONSULTING LLP 125 1072 1197 PHILADELPH PA TECH MAHINDRA AMERICAS IN 475 540 1015 SOUTH PLAI NJ WIPRO LIMITED 270 652 922 EAST BRUNS NJ INFOSYS LTD 38 828 866 PLANO TX MICROSOFT CORPORATION 364 485 849 REDMOND WA GOOGLE LLC 512 240 752 MOUNTAIN V CA LARSEN AND TOUBRO INFOTEC 317 417 734 EDISON NJ AMAZON.COM SERVICES INC 606 124 730 SEATTLE WA ERNST & YOUNG US LLP 83 627 710 SECAUCUS NJ CAPGEMINI AMERICA INC 135 484 619 CHICAGO IL ACCENTURE LLP 100 466 566 CHICAGO IL DELOITTE CONSULTING LLP 298 164 462 BOSTON MA FACEBOOK INC 351 97 448 MENLO PARK CA MPHASIS CORPORATION 222 218 440 NEW YORK NY APPLE INC 194 234 428 CUPERTINO CA HCL AMERICA INC 31 381 412 SUNNYVALE CA IBM INDIA PRIVATE LIMITED 15 356 371 DURHAM NC L&T TECH SVCS LTD 51 290 341 EDISON NJ INTEL CORPORATION 213 115 328 CHANDLER AZ CISCO SYSTEMS INC 119 201 320 SAN JOSE CA JPMORGAN CHASE & CO 95 211 306 CHICAGO IL MINDTREE LIMITED 58 219 277 WARREN NJ ORACLE AMERICA INC 99 176 275 REDWOOD CI CA VIRTUSA CORPORATION 80 187 267 SOUTHBOROU MA HEXAWARE TECHNOLOGIES INC 116 142 258 ISELIN NJ IBM CORPORATION 159 82 241 DURHAM NC QUALCOMM TECHNOLOGIES INC 201 26 227 SAN DIEGO CA RANDSTAD TECHNOLOGIES LLC 10 216 226 WOBURN MA DELOITTE & TOUCHE LLP 59 149 208 BOSTON MA KFORCE INC 68 136 204 TAMPA FL PRICEWATERHOUSECOOPERS LL 133 62 195 TAMPA FL CGI TECHNOLOGIES AND SOLU 65 126 191 FAIRFAX VA WAL-MART ASSOCIATES INC 31 153 184 BENTONVILL AR SALESFORCE COM INC 45 131 176 SAN FRANCI CA SYNECHRON INC 34 134 168 NEW YORK NY SYNTEL INC 23 144 167 TROY MI NTT DATA INC 69 97 166 CHARLESTOW MA PRICEWATERHOUSECOOPERS AD 61 98 159 TAMPA FL COMPUNNEL SOFTWARE GROUP 18 132 150 PLAINSBORO NJ BANK OF AMERICA NA 62 84 146 CHARLOTTE NC EPAM SYSTEMS INC 78 67 145 NEWTOWN PA TESLA INC 114 26 140 PALO ALTO CA UST GLOBAL INC 9 129 138 ALISO VIEJ CA EBAY INC 76 62 138 SAN JOSE CA SAP AMERICA INC 88 49 137 NEWTOWN SQ PA UBER TECHNOLOGIES INC 85 46 131 SAN FRANCI CA GOLDMAN SACHS & CO LLC 66 59 125 JERSEY CIT NJ MCKINSEY & COMPANY INC US 82 36 118 NEW YORK NY PAYPAL INC 60 58 118 SAN JOSE CA POLARIS CONSULTING & SERV 12 105 117 PISCATAWAY NJ MORGAN STANLEY SERVICES G 34 83 117 NEW YORK NY CERNER CORPORATION 93 19 112 NORTH KANS MO COMCAST CABLE COMMUNICATI 20 91 111 PHILADELPH PA CUMMINS INC 17 90 107 NASHVILLE TN AMERICAN EXPRESS TRAVEL R 9 96 105 NEW YORK NY KPMG LLP 33 66 99 DALLAS TX VMWARE INC 52 46 98 PALO ALTO CA CITIUSTECH INC 56 39 95 PRINCETON NJ BLOOMBERG LP 28 64 92 NEW YORK NY CITIBANK NA 41 50 91 NEW YORK NY BIRLASOFT INC 46 45 91 EDISON NJ NATSOFT CORPORATION 45 45 90 SOMERSET NJ OATH HOLDINGS INC 74 15 89 SUNNYVALE CA NVIDIA CORPORATION 50 39 89 SANTA CLAR CA MARLABS INC 35 52 87 PISCATAWAY NJ KPIT INFOSYSTEMS INC 42 44 86 EDISON NJ COMPUTER SCIENCES CORPORA 71 15 86 MC LEAN VA AKAMAI TECHNOLOGIES INC 58 26 84 CAMBRIDGE MA EXLSERVICE.COM LLC 49 34 83 NEW YORK NY LINKEDIN CORPORATION 52 30 82 SUNNYVALE CA NIIT TECHNOLOGIES LIMITED 22 59 81 ATLANTA GA AMAZON WEB SERVICES INC 30 47 77 SEATTLE WA HITACHI CONSULTING CORPOR 54 22 76 DALLAS TX JOHNS HOPKINS UNIVERSITY 35 38 73 BALTIMORE MD FUJITSU AMERICA INC 42 30 72 PITTSBURGH PA NTT DATA SERVICES LLC 44 27 71 CHARLESTOW MA UNIV OF MICHIGAN 45 26 71 ANN ARBOR MI NTT DATA INC 5 65 70 BOSTON MA MASTECH DIGITAL TECHNOLOG 7 63 70 CORAOPOLIS PA THE LELAND STANFORD JR UN 30 40 70 STANFORD CA SERVICENOW INC 47 22 69 SANTA CLAR CA HEWLETT PACKARD ENTERPRIS 28 41 69 AUSTIN TX T MOBILE USA INC 23 46 69 BELLEVUE WA STATE STREET BANK & TRUST 6 61 67 BOSTON MA ANTHEM INC 14 53 67 WILMINGTON DE POPULUS GROUP LLC 25 42 67 TROY MI HEADSTRONG SERVICES LLC 16 51 67 SHORT HILL NJ COLLABERA INC 15 49 64 BASKING RI NJ CAPITAL ONE SERVICES LLC 19 44 63 HENRICO VA GENERAL MOTORS COMPANY 25 37 62 DETROIT MI OPTUM SERVICES INC 9 53 62 RICHARDSON TX I5 TECH INC 35 27 62 EDISON NJ CAPITAL ONE SERVICES LLC 4 58 62 RICHMOND VA AMERICAN AIRLINES INC 28 33 61 FORT WORTH TX BARCLAYS SERVICES CORP 21 40 61 NEW YORK NY QUEST GLOBAL SERVICES-NA 43 18 61 EAST HARTF CT CYIENT INC 32 29 61 EAST HARTF CT SAPIENT CORPORATION 10 49 59 BOSTON MA Approvals column pakkana denials column kooda pettu bro. I heard WITCH companies are getting almost 33% denials. Want to see if it is truth. And compare it to American companies. Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 2, 2019 Author Report Share Posted April 2, 2019 $ cat run.sql .mode column .headers on select employer, ia, ca, (ca + ia) as totalApprovals, id, cd, (cd+id) as totalDenials, city, state from h2019 order by totalApprovals desc limit 100; $ sqlite3 blah.db < run.sql employer ia ca totalApprovals id cd totalDenials city state ------------------------- ---------- ---------- -------------- ---------- ---------- ------------ ---------- ---------- TATA CONSULTANCY SVCS LTD 1177 1881 3058 700 832 1532 ROCKVILLE MD COGNIZANT TECH SOLNS US C 158 1717 1875 217 996 1213 COLLEGE ST TX DELOITTE CONSULTING LLP 125 1072 1197 150 497 647 PHILADELPH PA TECH MAHINDRA AMERICAS IN 475 540 1015 440 78 518 SOUTH PLAI NJ WIPRO LIMITED 270 652 922 437 189 626 EAST BRUNS NJ INFOSYS LTD 38 828 866 49 423 472 PLANO TX MICROSOFT CORPORATION 364 485 849 54 15 69 REDMOND WA GOOGLE LLC 512 240 752 16 10 26 MOUNTAIN V CA LARSEN AND TOUBRO INFOTEC 317 417 734 83 55 138 EDISON NJ AMAZON.COM SERVICES INC 606 124 730 27 27 54 SEATTLE WA ERNST & YOUNG US LLP 83 627 710 65 106 171 SECAUCUS NJ CAPGEMINI AMERICA INC 135 484 619 138 266 404 CHICAGO IL ACCENTURE LLP 100 466 566 96 138 234 CHICAGO IL DELOITTE CONSULTING LLP 298 164 462 564 165 729 BOSTON MA FACEBOOK INC 351 97 448 11 4 15 MENLO PARK CA MPHASIS CORPORATION 222 218 440 60 25 85 NEW YORK NY APPLE INC 194 234 428 6 5 11 CUPERTINO CA HCL AMERICA INC 31 381 412 23 169 192 SUNNYVALE CA IBM INDIA PRIVATE LIMITED 15 356 371 5 145 150 DURHAM NC L&T TECH SVCS LTD 51 290 341 11 32 43 EDISON NJ INTEL CORPORATION 213 115 328 19 9 28 CHANDLER AZ CISCO SYSTEMS INC 119 201 320 11 4 15 SAN JOSE CA JPMORGAN CHASE & CO 95 211 306 16 10 26 CHICAGO IL MINDTREE LIMITED 58 219 277 3 27 30 WARREN NJ ORACLE AMERICA INC 99 176 275 9 6 15 REDWOOD CI CA VIRTUSA CORPORATION 80 187 267 18 18 36 SOUTHBOROU MA HEXAWARE TECHNOLOGIES INC 116 142 258 10 12 22 ISELIN NJ IBM CORPORATION 159 82 241 23 34 57 DURHAM NC QUALCOMM TECHNOLOGIES INC 201 26 227 12 7 19 SAN DIEGO CA RANDSTAD TECHNOLOGIES LLC 10 216 226 2 13 15 WOBURN MA DELOITTE & TOUCHE LLP 59 149 208 54 78 132 BOSTON MA KFORCE INC 68 136 204 32 52 84 TAMPA FL PRICEWATERHOUSECOOPERS LL 133 62 195 36 23 59 TAMPA FL CGI TECHNOLOGIES AND SOLU 65 126 191 7 12 19 FAIRFAX VA WAL-MART ASSOCIATES INC 31 153 184 8 18 26 BENTONVILL AR SALESFORCE COM INC 45 131 176 1 3 4 SAN FRANCI CA SYNECHRON INC 34 134 168 8 10 18 NEW YORK NY SYNTEL INC 23 144 167 16 84 100 TROY MI NTT DATA INC 69 97 166 11 7 18 CHARLESTOW MA PRICEWATERHOUSECOOPERS AD 61 98 159 33 93 126 TAMPA FL COMPUNNEL SOFTWARE GROUP 18 132 150 8 19 27 PLAINSBORO NJ BANK OF AMERICA NA 62 84 146 4 4 8 CHARLOTTE NC EPAM SYSTEMS INC 78 67 145 34 7 41 NEWTOWN PA TESLA INC 114 26 140 16 6 22 PALO ALTO CA UST GLOBAL INC 9 129 138 4 15 19 ALISO VIEJ CA EBAY INC 76 62 138 4 0 4 SAN JOSE CA SAP AMERICA INC 88 49 137 12 6 18 NEWTOWN SQ PA UBER TECHNOLOGIES INC 85 46 131 4 1 5 SAN FRANCI CA GOLDMAN SACHS & CO LLC 66 59 125 40 5 45 JERSEY CIT NJ MCKINSEY & COMPANY INC US 82 36 118 34 9 43 NEW YORK NY PAYPAL INC 60 58 118 3 3 6 SAN JOSE CA POLARIS CONSULTING & SERV 12 105 117 51 12 63 PISCATAWAY NJ MORGAN STANLEY SERVICES G 34 83 117 5 1 6 NEW YORK NY CERNER CORPORATION 93 19 112 6 0 6 NORTH KANS MO COMCAST CABLE COMMUNICATI 20 91 111 1 4 5 PHILADELPH PA CUMMINS INC 17 90 107 4 5 9 NASHVILLE TN AMERICAN EXPRESS TRAVEL R 9 96 105 1 2 3 NEW YORK NY KPMG LLP 33 66 99 2 19 21 DALLAS TX VMWARE INC 52 46 98 7 4 11 PALO ALTO CA CITIUSTECH INC 56 39 95 40 12 52 PRINCETON NJ BLOOMBERG LP 28 64 92 11 7 18 NEW YORK NY CITIBANK NA 41 50 91 21 1 22 NEW YORK NY BIRLASOFT INC 46 45 91 38 6 44 EDISON NJ NATSOFT CORPORATION 45 45 90 5 5 10 SOMERSET NJ OATH HOLDINGS INC 74 15 89 6 6 12 SUNNYVALE CA NVIDIA CORPORATION 50 39 89 2 2 4 SANTA CLAR CA MARLABS INC 35 52 87 23 3 26 PISCATAWAY NJ KPIT INFOSYSTEMS INC 42 44 86 7 9 16 EDISON NJ COMPUTER SCIENCES CORPORA 71 15 86 6 1 7 MC LEAN VA AKAMAI TECHNOLOGIES INC 58 26 84 0 1 1 CAMBRIDGE MA EXLSERVICE.COM LLC 49 34 83 42 4 46 NEW YORK NY LINKEDIN CORPORATION 52 30 82 0 3 3 SUNNYVALE CA NIIT TECHNOLOGIES LIMITED 22 59 81 3 11 14 ATLANTA GA AMAZON WEB SERVICES INC 30 47 77 5 11 16 SEATTLE WA HITACHI CONSULTING CORPOR 54 22 76 0 5 5 DALLAS TX JOHNS HOPKINS UNIVERSITY 35 38 73 0 2 2 BALTIMORE MD FUJITSU AMERICA INC 42 30 72 3 5 8 PITTSBURGH PA NTT DATA SERVICES LLC 44 27 71 24 2 26 CHARLESTOW MA UNIV OF MICHIGAN 45 26 71 0 1 1 ANN ARBOR MI NTT DATA INC 5 65 70 1 1 2 BOSTON MA MASTECH DIGITAL TECHNOLOG 7 63 70 2 21 23 CORAOPOLIS PA THE LELAND STANFORD JR UN 30 40 70 0 0 0 STANFORD CA SERVICENOW INC 47 22 69 2 0 2 SANTA CLAR CA HEWLETT PACKARD ENTERPRIS 28 41 69 4 1 5 AUSTIN TX T MOBILE USA INC 23 46 69 2 3 5 BELLEVUE WA STATE STREET BANK & TRUST 6 61 67 3 2 5 BOSTON MA ANTHEM INC 14 53 67 1 0 1 WILMINGTON DE POPULUS GROUP LLC 25 42 67 58 33 91 TROY MI HEADSTRONG SERVICES LLC 16 51 67 18 6 24 SHORT HILL NJ COLLABERA INC 15 49 64 13 11 24 BASKING RI NJ CAPITAL ONE SERVICES LLC 19 44 63 2 3 5 HENRICO VA GENERAL MOTORS COMPANY 25 37 62 2 0 2 DETROIT MI OPTUM SERVICES INC 9 53 62 1 1 2 RICHARDSON TX I5 TECH INC 35 27 62 14 5 19 EDISON NJ CAPITAL ONE SERVICES LLC 4 58 62 0 0 0 RICHMOND VA AMERICAN AIRLINES INC 28 33 61 2 1 3 FORT WORTH TX BARCLAYS SERVICES CORP 21 40 61 0 3 3 NEW YORK NY QUEST GLOBAL SERVICES-NA 43 18 61 26 1 27 EAST HARTF CT CYIENT INC 32 29 61 3 1 4 EAST HARTF CT SAPIENT CORPORATION 10 49 59 4 16 20 BOSTON MA 1 Quote Link to comment Share on other sites More sharing options...
snoww Posted April 2, 2019 Report Share Posted April 2, 2019 TATA CONSULTANCY SVCS LTD 1177 1881 3058 700 832 1532 ROCKVILLE MD COGNIZANT TECH SOLNS US C 158 1717 1875 217 996 1213 COLLEGE ST TX DELOITTE CONSULTING LLP 125 1072 1197 150 497 647 PHILADELPH PA TECH MAHINDRA AMERICAS IN 475 540 1015 440 78 518 SOUTH PLAI NJ WIPRO LIMITED 270 652 922 437 189 626 EAST BRUNS NJ INFOSYS LTD 38 828 866 49 423 472 PLANO TX seems right. Almost 33% applications getting denied. Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 2, 2019 Author Report Share Posted April 2, 2019 2019 or since April 2018 data: employer ia ca totalApprovals id cd totalDenials city state ------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- TATA CONSULTANCY SVCS LTD 1177 1881 3058 700 832 1532 ROCKVILLE MD COGNIZANT TECH SOLNS US C 158 1717 1875 217 996 1213 COLLEGE ST TX DELOITTE CONSULTING LLP 298 164 462 564 165 729 BOSTON MA DELOITTE CONSULTING LLP 125 1072 1197 150 497 647 PHILADELPH PA WIPRO LIMITED 270 652 922 437 189 626 EAST BRUNS NJ TECH MAHINDRA AMERICAS IN 475 540 1015 440 78 518 SOUTH PLAI NJ INFOSYS LTD 38 828 866 49 423 472 PLANO TX CAPGEMINI AMERICA INC 135 484 619 138 266 404 CHICAGO IL ACCENTURE LLP 100 466 566 96 138 234 CHICAGO IL HCL AMERICA INC 31 381 412 23 169 192 SUNNYVALE CA ERNST & YOUNG US LLP 83 627 710 65 106 171 SECAUCUS NJ IBM INDIA PRIVATE LIMITED 15 356 371 5 145 150 DURHAM NC LARSEN AND TOUBRO INFOTEC 317 417 734 83 55 138 EDISON NJ DELOITTE & TOUCHE LLP 59 149 208 54 78 132 BOSTON MA PRICEWATERHOUSECOOPERS AD 61 98 159 33 93 126 TAMPA FL SYNTEL INC 23 144 167 16 84 100 TROY MI LUSSOTECH LLC 3 0 3 100 0 100 RESTON VA POPULUS GROUP LLC 25 42 67 58 33 91 TROY MI SAIBERSYS INC 1 2 3 86 4 90 CARROLLTON TX MPHASIS CORPORATION 222 218 440 60 25 85 NEW YORK NY KFORCE INC 68 136 204 32 52 84 TAMPA FL MICROSOFT CORPORATION 364 485 849 54 15 69 REDMOND WA CLOUD BIG DATA TECHNOLOGI 2 1 3 61 3 64 DALLAS TX POLARIS CONSULTING & SERV 12 105 117 51 12 63 PISCATAWAY NJ PRINCIPLE INFORMATION TEC 6 2 8 62 0 62 HOUSTON TX PRICEWATERHOUSECOOPERS LL 133 62 195 36 23 59 TAMPA FL IBM CORPORATION 159 82 241 23 34 57 DURHAM NC SQA CONCEPTS INC 1 5 6 51 5 56 ASHBURN VA ANIRA SOLUTIONS INC 1 4 5 54 2 56 ASHBURN VA VERIDIC SOLUTIONS, LLC 28 4 32 52 3 55 DULUTH GA AMAZON.COM SERVICES INC 606 124 730 27 27 54 SEATTLE WA FRIENDLY CONSULTANTS INC 7 5 12 53 0 53 PRINCETON NJ E GIANTS TECHNOLOGIES LLC 22 7 29 49 4 53 CLIVE IA CITIUSTECH INC 56 39 95 40 12 52 PRINCETON NJ SOLOMONS INTERNATIONAL LL 1 0 1 50 0 50 HARLEYSVIL PA FRACTAL ANALYTICS INC 5 6 11 46 3 49 JERSEY CIT NJ PIONEER CONSULTING SERVIC 9 11 20 41 8 49 WEST DES M IA ERP ANALYSTS INC 7 47 54 17 30 47 DUBLIN OH EXLSERVICE.COM LLC 49 34 83 42 4 46 NEW YORK NY HCL GLOBAL SYSTEMS INC 8 39 47 27 18 45 FARMINGTON MI GOLDMAN SACHS & CO LLC 66 59 125 40 5 45 JERSEY CIT NJ RELIANT VISION GROUP INC 2 12 14 44 1 45 ISELIN NJ BIRLASOFT INC 46 45 91 38 6 44 EDISON NJ THE BOSTON CONSULTING GRO 35 21 56 41 2 43 BOSTON MA MCKINSEY & COMPANY INC US 82 36 118 34 9 43 NEW YORK NY L&T TECH SVCS LTD 51 290 341 11 32 43 EDISON NJ EPAM SYSTEMS INC 78 67 145 34 7 41 NEWTOWN PA ANTRA INC 3 4 7 39 2 41 STERLING VA COMTEK GLOBAL INC DBA CEN 0 3 3 37 2 39 PISCATAWAY NJ 3I INFOTECH INC 11 30 41 30 7 37 EDISON NJ VIRTUSA CORPORATION 80 187 267 18 18 36 SOUTHBOROU MA AVANI SYSTEMS INC 0 0 0 32 3 35 HOUSTON TX I3 INFOTEK INC 4 5 9 28 7 35 ISELIN NJ SMART IT FRAME LLC 2 0 2 33 1 34 JERSEY CIT NJ JNIT TECHNOLOGIES INC 1 0 1 33 0 33 GRAPEVINE TX VECTOR SYSTEMS INC 0 0 0 31 1 32 MATAWAN NJ XTRACIT INC 8 0 8 31 1 32 CHARLOTTE NC NEO PRISM SOLUTIONS LLC 0 8 8 26 5 31 CHARLOTTE NC GVA INFOTECH INC 6 0 6 29 2 31 ASHBURN VA VEDICSOFT SOLUTIONS LLC 9 29 38 20 11 31 ISELIN NJ ELITE IT PROFESSIONALS IN 0 0 0 31 0 31 SOMERSET NJ INFISYSTEMS LLC 1 6 7 28 2 30 CLEARWATER FL EALEARN INC 3 1 4 30 0 30 EDISON NJ VSION TECHNOLOGIES INC 7 5 12 26 4 30 CEDAR PARK TX MINDTREE LIMITED 58 219 277 3 27 30 WARREN NJ AMENSYS INC 8 1 9 26 3 29 LEWISVILLE TX LGBS SOFTWARE INC 0 0 0 29 0 29 MAHWAH NJ PROFUSION SYSS INC DBA ST 0 1 1 27 2 29 NORTH BRUN NJ V-SOFT CONSULTING GROUP I 1 50 51 7 22 29 LOUISVILLE KY CLOUD HYBRID TECHNOLOGIES 1 0 1 28 0 28 DALLAS TX MIRACLE SOFTTECH LLC 0 4 4 28 0 28 MOUNT LAUR NJ INTEL CORPORATION 213 115 328 19 9 28 CHANDLER AZ QUEST GLOBAL SERVICES-NA 43 18 61 26 1 27 EAST HARTF CT COMPUNNEL SOFTWARE GROUP 18 132 150 8 19 27 PLAINSBORO NJ JPMORGAN CHASE & CO 95 211 306 16 10 26 CHICAGO IL NTT DATA SERVICES LLC 44 27 71 24 2 26 CHARLESTOW MA BI LABS INC 7 6 13 26 0 26 ISELIN NJ PERFORMANCE RESOURCES NY 5 1 6 22 4 26 HAUPPAUGE NY MARLABS INC 35 52 87 23 3 26 PISCATAWAY NJ ANJANEYAP INC 2 1 3 25 1 26 MILPITAS CA WAL-MART ASSOCIATES INC 31 153 184 8 18 26 BENTONVILL AR GOOGLE LLC 512 240 752 16 10 26 MOUNTAIN V CA MALVI SYSTEMS LLC 0 0 0 24 1 25 CRANBURY NJ AMITI CONSULTING INC 3 2 5 24 1 25 ASHBURN VA CNET GLOBAL SOLUTIONS INC 6 13 19 15 9 24 RICHARDSON TX COLLABERA INC 15 49 64 13 11 24 BASKING RI NJ GENPACT LLC 14 26 40 20 4 24 SHORT HILL NJ WAYFAIR LLC 1 32 33 19 5 24 BOSTON MA HEADSTRONG SERVICES LLC 16 51 67 18 6 24 SHORT HILL NJ ARKA TECHNOLOGIES INC 9 3 12 23 1 24 MIAMI FL MASTECH DIGITAL TECHNOLOG 7 63 70 2 21 23 CORAOPOLIS PA RJT COMPUQUEST INC 3 8 11 16 7 23 EL SEGUNDO CA EGEN SOLUTIONS INC 12 4 16 18 5 23 NAPERVILLE IL EPITEC INC 11 8 19 21 2 23 SOUTHFIELD MI APLOMB TECHNOLOGIES INC 0 11 11 21 2 23 PRINCETON NJ MICRONET IT SOLUTIONS INC 10 0 10 21 2 23 PLEASANTON CA FIDENTIATECH LLC 0 0 0 23 0 23 RESTON VA CITIBANK NA 41 50 91 21 1 22 NEW YORK NY HEXAWARE TECHNOLOGIES INC 116 142 258 10 12 22 ISELIN NJ VORTALSOFT INC 1 6 7 22 0 22 SOMERSET NJ Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 2, 2019 Author Report Share Posted April 2, 2019 Here are all mesthris, whose visas are picked up in 2018 April Lottery; however, their h1-bs got denied later: sqlite> select employer, ia, id from h2019 where ia = 0 and id > 0 order by id desc limit 150; employer ia id --------------------------------- ---------- ---------- COMTEK GLOBAL INC DBA CENTILLIONZ 0 37 AVANI SYSTEMS INC 0 32 VECTOR SYSTEMS INC 0 31 ELITE IT PROFESSIONALS INC 0 31 LGBS SOFTWARE INC 0 29 MIRACLE SOFTTECH LLC 0 28 PROFUSION SYSS INC DBA STAFFING F 0 27 NEO PRISM SOLUTIONS LLC 0 26 MALVI SYSTEMS LLC 0 24 FIDENTIATECH LLC 0 23 TEKGROUP LLC 0 22 APLOMB TECHNOLOGIES INC 0 21 ICLOUD TECHNOLOGIES CORP 0 21 PURSUIT INC 0 19 SIARAA TECHNOLOGIES INC 0 19 T2M CONSULTING SERVICES INC 0 18 TECHALPHA LLC 0 17 EQUINOX IT SOLUTIONS LLC 0 16 NIKTOR LLC 0 16 VASTEK INC 0 15 SRIVIN INFOSYSTEMS INC DBA MAHIMA 0 14 LEARNBEYOND INC 0 13 THE SAKS IT GROUP LLC 0 13 UNITED PHARMA TECHNOLOGIES INC 0 13 SUNBIZ HOLDINGS CORP 0 13 SOFTCOM SYSTEMS INC 0 11 VSLN INTERNATIONAL INC 0 11 EQUINOX IT SOLUTIONS LLC 0 11 ICOM INC 0 11 GLOBE 2 TECHNOLOGIES INC 0 11 CRITICALRIVER INC 0 11 EXPRESS GLOBAL SOLUTIONS LLC 0 11 IT SWARM LLC 0 11 TIMESQUARE IT INC 0 11 SRIT INC 0 11 THE FOUNTAIN GROUP LLC 0 10 FISEC GLOBAL INC 0 10 SPLN LLC 0 10 SHOOLIN INC 0 9 ITEK SOFTWARE LLC 0 9 RD TECH SYSTEMS INC 0 9 SPHINX IT SOLUTIONS LLC 0 9 CYBERMINDS INC 0 9 TECHRODE INC 0 9 BA2CC SOLUTIONS INC 0 9 SECURITY IRIS INC 0 9 EXCELSOFT SERVICES INC 0 8 HORIZON SOFTECH INC 0 8 Z-AXIS TECH SOLUTIONS INC 0 8 ENGINEERING TECH ASSOC INC 0 8 IKON SYSTEMS LLC 0 8 TECHSTAR SOLUTIONS INC 0 8 PETA SYSTEMS INC 0 8 FIREFLY PROS INC 0 8 SLALOM LLC 0 8 PERIGON INFOTECH INC 0 7 INFOYUGA TECHNOLOGIES INC 0 7 CYBERBRAINS INC 0 7 STECK SYSTEMS INC 0 7 BDSN INTERNATIONAL INC 0 7 TECHGURUS CONSULTING LLC 0 7 INDUS GROUP INC 0 7 PEK SYSTEMS INC 0 7 BHRIGUS INC 0 6 BUSINESS TECH SOFTWARE SOLUTIONS 0 6 ITVISION INC 0 6 SOFTWARE MERCHANT INC 0 6 SRNL INTERNATIONAL INC 0 6 CITY GURUS INC 0 6 ENTERPRISE QA LABS INC 0 6 RUBIKTEK INC 0 6 DATAMINDSOLUTIONS LLC 0 6 DIGITAL ITECHNOLOGY LLC 0 6 SUPERIOR SOFTWARE & TECH SOLUTION 0 6 IT HOPPERS INC 0 6 VDRIVEINFO INC 0 6 MOBILECOMM PROFESSIONALS INC 0 6 TEKREANT INC 0 6 FUTURE IT SOLUTIONS LLC 0 6 XPRESS GLOBAL IT SOLUTIONS LLC 0 6 APPISOFT INC 0 5 GLOBAL BRIDGE INFOTECH INC 0 5 INFO KEYS INC 0 5 AUROPRO SYSTEMS INC 0 5 INTELLIGROUP USA LIMITED 0 5 ANTRA INC 0 5 AMERICAN TECHNOLOGY CONSULTING LL 0 5 SUDHI INFOMATICS INC 0 5 ARKRIT LLC 0 5 YASHRAJ TECHNOLOGIES INC 0 5 PRITNA INC 0 5 MYAPPSHUB LLC 0 5 NUWAY SOLUTIONS LLC 0 5 PIEZOS TECH SOLUTIONS INC 0 5 AZURE CONSULTING SERVICES LLC 0 5 UNICAREER LLC 0 5 CYBERSOLVE IT INC 0 5 ICF RESOURCES LLC 0 5 SPENSYS INC 0 5 MERLIN SIGHT LLC 0 5 SOFTPATH TECHNOLOGIES LLC 0 5 KEY BUSINESS SOLUTIONS INC 0 5 CLICKSOFTWARE INC 0 5 DEUTSCHE BANK TRUST CO AMERICAS 0 4 SIMPSON THACHER & BARTLETT LLP 0 4 PANTAR SOLUTIONS INC 0 4 AGILESOFT INC 0 4 MVSOFTTECH INC DBA SVSS INFOTECH 0 4 ORPINE INC 0 4 YES HARDSOFT SOLUTIONS INC 0 4 MILLENIUM INFO TECH INC 0 4 CANVAS INFOTECH INC 0 4 IBUSINESS SOLUTION LLC 0 4 REMOTE TIGER INC 0 4 COMPUTE TECH INC 0 4 SSB SOFTWARE TECHNOLOGIES INC 0 4 MINDSYS INC 0 4 WAVE SOLUTIONS INC 0 4 GSK SOLUTIONS INC 0 4 WHOLEREN LLC 0 4 IDEAL SOURCE INC 0 4 IBM GLOBAL SYSTEMS INC DBA JOLT 0 4 VISUAL TECHNOLOGIES LLC 0 4 AMOR SYSTEMS LLC 0 4 BRIGHTECH INTERNATIONAL LLC 0 4 ALTIMETRIK CORP 0 4 INDUS USA INC 0 4 UBERTAL INC D/B/A UBERTAL TECH 0 4 MSRCOSMOS LLC 0 4 ASCII GROUP LLC 0 4 TEG ANALYTICS LLC 0 4 VOLANTSOFT INC 0 4 RESOURCE INFORMATICS GROUP INC 0 4 AZEE SYSTEMS INC 0 4 MARVELL TECH LLC 0 4 TSQ SYSTEMS INC 0 4 FINDREAM LLC 0 4 NEXUS IT INC 0 4 APPS GLOBE 0 4 CIGNITI TECHNOLOGIES INC 0 4 HILLSOFT BUSINESS SOLUTIONS LLC 0 4 AA SOLUTIONS INC 0 4 MULBERRY MANAGEMENT CORPORATION 0 4 RAK ITPRENEURS LLC 0 4 LEO PROJECTS CORPORATION 0 4 LOGIXHUB LLC 0 4 E BASE TECHNOLOGIES INC 0 4 ZENITH LIFESCIENCE LLC 0 4 FELTON GROUP INC 0 4 HELIOZ SOLUTIONS INC 0 4 1 Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 2, 2019 Author Report Share Posted April 2, 2019 2019 Total Intial Approvals, Total Intial Denials. What happened to 85000 H1-B quota? sqlite> select sum(ia),sum(id), sum(ia+id) from h2019; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 33366.0 15345.0 48711 2018, here we see the total as 116070. Maybe, some are cap-exempt, like those H1-Bs sought by non-profit unis. sqlite> select sum(ia),sum(id), sum(ia+id) from h2018; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 87889.0 28181.0 116070 sqlite> select sum(ia),sum(id), sum(ia+id) from h2017; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 96166.0 14518.0 110684 sqlite> select sum(ia),sum(id), sum(ia+id) from h2016; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 105092.0 11295.0 116387 sqlite> select sum(ia),sum(id), sum(ia+id) from h2015; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 111846.0 7644.0 119490 sqlite> select sum(ia),sum(id), sum(ia+id) from h2014; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 130616.0 10645.0 141261 sqlite> select sum(ia),sum(id), sum(ia+id) from h2013; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 130736.0 9596.0 140332 sqlite> select sum(ia),sum(id), sum(ia+id) from h2012; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 140809.0 7401.0 148210 sqlite> select sum(ia),sum(id), sum(ia+id) from h2011; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 114863.0 8583.0 123446 sqlite> select sum(ia),sum(id), sum(ia+id) from h2010; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 84038.0 7352.0 91390 sqlite> select sum(ia),sum(id), sum(ia+id) from h2009; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 99790.0 18099.0 117889 1 Quote Link to comment Share on other sites More sharing options...
snoww Posted April 2, 2019 Report Share Posted April 2, 2019 GP @ekunadam_enkanna Quote Link to comment Share on other sites More sharing options...
snoww Posted April 2, 2019 Report Share Posted April 2, 2019 3 hours ago, ekunadam_enkanna said: 2019 Total Intial Approvals, Total Intial Denials. What happened to 85000 H1-B quota? sqlite> select sum(ia),sum(id), sum(ia+id) from h2019; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 33366.0 15345.0 48711 2018, here we see the total as 116070. Maybe, some are cap-exempt, like those H1-Bs sought by non-profit unis. sqlite> select sum(ia),sum(id), sum(ia+id) from h2018; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 87889.0 28181.0 116070 sqlite> select sum(ia),sum(id), sum(ia+id) from h2017; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 96166.0 14518.0 110684 sqlite> select sum(ia),sum(id), sum(ia+id) from h2016; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 105092.0 11295.0 116387 sqlite> select sum(ia),sum(id), sum(ia+id) from h2015; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 111846.0 7644.0 119490 sqlite> select sum(ia),sum(id), sum(ia+id) from h2014; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 130616.0 10645.0 141261 sqlite> select sum(ia),sum(id), sum(ia+id) from h2013; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 130736.0 9596.0 140332 sqlite> select sum(ia),sum(id), sum(ia+id) from h2012; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 140809.0 7401.0 148210 sqlite> select sum(ia),sum(id), sum(ia+id) from h2011; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 114863.0 8583.0 123446 sqlite> select sum(ia),sum(id), sum(ia+id) from h2010; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 84038.0 7352.0 91390 sqlite> select sum(ia),sum(id), sum(ia+id) from h2009; sum(ia) sum(id) sum(ia+id) ---------- ---------- ---------- 99790.0 18099.0 117889 Almost 1 in 3 applications getting rejected. MAGA Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.