Table 1 PERSON: "Id" "Age" "education" "sex" "citizenship" "family members" "previous state" "previous region" "Hispanic origin" "employment stat"

Table 2 JOB: "occ_id" "Detailed Industry code" "detailed occupation code" "major industry code" "major occupation code"

Table 3 PAY: "job_id" "Wage per hour" "weeks worked per year"

dbGetQuery(db, "SELECT [major industry code] FROM JOB WHERE JOB.[occ_id] = (SELECT [job_id], MAX([Wage per hour]) FROM PAY WHERE JOB.[occ_id] = PAY[job_id])")