I use the following query to get the total of all workers for approvals, and denials.

SELECT `Industry (NAICS) Code` AS NAICS, (sum(`Initial Approval`) + sum(`Continuing Approval`) ) AS APPROVED FROM `2024h1bhub` where `Industry (NAICS) Code` IS NOT NULL group by `Industry (NAICS) Code`

Can anybody explain the denials to me in more detail?

---

A suggestion I received which I think is a good one.

I think it would be helpful if you clarified that a NAICS code does not indicate the specific occupation being carried out by the H-1B worker.

For example, a mechanical engineer with an H-1B visa may very well work in the construction industry.