SELECT rg.Major, rg.Major_category, rg.Total AS Total_Undergrad_Grads, gs.Grad_total AS Total_Grad_Students, AVG(rg.Unemployment_rate) AS Avg_Undergrad_Unemployment_Rate, AVG(gs.Grad_unemployment_rate) AS Avg_Grad_Unemployment_Rate, AVG(rg.Median) AS Avg_Undergrad_Median_Salary, AVG(gs.Grad_median) AS Avg_Grad_Median_Salary FROM RecentGradsDB rg JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code GROUP BY rg.Major_category, rg.Major, rg.Total, gs.Grad_total HAVING AVG(rg.Unemployment_rate) < 0.06 ORDER BY rg.Total DESC;
[Row(Major='NURSING', Major_category='Health', Total_Undergrad_Grads=209394, Total_Grad_Students=573467, Avg_Undergrad_Unemployment_Rate=0.04486272484064102, Avg_Grad_Unemployment_Rate=0.02126673422753811, Avg_Undergrad_Median_Salary=48000.0, Avg_Grad_Median_Salary=84000.0), Row(Major='MECHANICAL ENGINEERING', Major_category='Engineering', Total_Undergrad_Grads=91227, Total_Grad_Students=347342, Avg_Undergrad_Unemployment_Rate=0.057342279702425, Avg_Grad_Unemployment_Rate=0.03544933348894119, Avg_Undergrad_Median_Salary=60000.0, Avg_Grad_Median_Salary=100000.0), Row(Major='ELECTRICAL ENGINEERING', Major_category='Engineering', Total_Undergrad_Grads=81527, Total_Grad_Students=482767, Avg_Undergrad_Unemployment_Rate=0.05917384475469589, Avg_Grad_Unemployment_Rate=0.03623051196336746, Avg_Undergrad_Median_Salary=60000.0, Avg_Grad_Median_Salary=106000.0), Row(Major='MULTI-DISCIPLINARY OR GENERAL SCIENCE', Major_category='Physical Sciences', Total_Undergrad_Grads=62052, Total_Grad_Students=223467, Avg_Undergrad_Unemployment_Rate=0.05580681562423706, Avg_Grad_Unemployment_Rate=0.02810649946331978, Avg_Undergrad_Median_Salary=35000.0, Avg_Grad_Median_Salary=86000.0), Row(Major='GENERAL ENGINEERING', Major_category='Engineering', Total_Undergrad_Grads=61152, Total_Grad_Students=268473, Avg_Undergrad_Unemployment_Rate=0.05982423201203346, Avg_Grad_Unemployment_Rate=0.035998474806547165, Avg_Undergrad_Median_Salary=56000.0, Avg_Grad_Median_Salary=100000.0), Row(Major='HUMAN RESOURCES AND PERSONNEL MANAGEMENT', Major_category='Business', Total_Undergrad_Grads=24497, Total_Grad_Students=72548, Avg_Undergrad_Unemployment_Rate=0.059569649398326874, Avg_Grad_Unemployment_Rate=0.06471596658229828, Avg_Undergrad_Median_Salary=36000.0, Avg_Grad_Median_Salary=70000.0), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Major_category='Engineering', Total_Undergrad_Grads=18968, Total_Grad_Students=86791, Avg_Undergrad_Unemployment_Rate=0.04287554323673248, Avg_Grad_Unemployment_Rate=0.03862462192773819, Avg_Undergrad_Median_Salary=57000.0, Avg_Grad_Median_Salary=98000.0), Row(Major='MANAGEMENT INFORMATION SYSTEMS AND STATISTICS', Major_category='Business', Total_Undergrad_Grads=18713, Total_Grad_Students=41970, Avg_Undergrad_Unemployment_Rate=0.058239612728357315, Avg_Grad_Unemployment_Rate=0.03871464356780052, Avg_Undergrad_Median_Salary=51000.0, Avg_Grad_Median_Salary=89000.0), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Major_category='Health', Total_Undergrad_Grads=15914, Total_Grad_Students=47029, Avg_Undergrad_Unemployment_Rate=0.036982789635658264, Avg_Grad_Unemployment_Rate=0.025552736595273018, Avg_Undergrad_Median_Salary=45000.0, Avg_Grad_Median_Salary=76000.0), Row(Major='AGRICULTURE PRODUCTION AND MANAGEMENT', Major_category='Agriculture & Natural Resources', Total_Undergrad_Grads=14240, Total_Grad_Students=17488, Avg_Undergrad_Unemployment_Rate=0.05003083497285843, Avg_Grad_Unemployment_Rate=0.03483833000063896, Avg_Undergrad_Median_Salary=40000.0, Avg_Grad_Median_Salary=67000.0), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Major_category='Business', Total_Undergrad_Grads=11732, Total_Grad_Students=15056, Avg_Undergrad_Unemployment_Rate=0.04785870388150215, Avg_Grad_Unemployment_Rate=0.02284832112491131, Avg_Undergrad_Median_Salary=50000.0, Avg_Grad_Median_Salary=94000.0), Row(Major='MEDICAL ASSISTING SERVICES', Major_category='Health', Total_Undergrad_Grads=11123, Total_Grad_Students=18654, Avg_Undergrad_Unemployment_Rate=0.04250652715563774, Avg_Grad_Unemployment_Rate=0.025342833250761032, Avg_Undergrad_Median_Salary=42000.0, Avg_Grad_Median_Salary=80000.0), Row(Major='GENERAL AGRICULTURE', Major_category='Agriculture & Natural Resources', Total_Undergrad_Grads=10399, Total_Grad_Students=44306, Avg_Undergrad_Unemployment_Rate=0.019642462953925133, Avg_Grad_Unemployment_Rate=0.02932492271065712, Avg_Undergrad_Median_Salary=40000.0, Avg_Grad_Median_Salary=68000.0), Row(Major='MISCELLANEOUS ENGINEERING TECHNOLOGIES', Major_category='Engineering', Total_Undergrad_Grads=8804, Total_Grad_Students=14816, Avg_Undergrad_Unemployment_Rate=0.05253852158784866, Avg_Grad_Unemployment_Rate=0.03169781714677811, Avg_Undergrad_Median_Salary=40000.0, Avg_Grad_Median_Salary=80000.0), Row(Major='MECHANICAL ENGINEERING RELATED TECHNOLOGIES', Major_category='Engineering', Total_Undergrad_Grads=4790, Total_Grad_Students=6065, Avg_Undergrad_Unemployment_Rate=0.05635707825422287, Avg_Grad_Unemployment_Rate=0.0652356892824173, Avg_Undergrad_Median_Salary=40000.0, Avg_Grad_Median_Salary=78000.0), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Major_category='Engineering', Total_Undergrad_Grads=4631, Total_Grad_Students=19885, Avg_Undergrad_Unemployment_Rate=0.028308097273111343, Avg_Grad_Unemployment_Rate=0.03927059471607208, Avg_Undergrad_Median_Salary=46000.0, Avg_Grad_Median_Salary=84500.0), Row(Major='ENGINEERING TECHNOLOGIES', Major_category='Engineering', Total_Undergrad_Grads=3600, Total_Grad_Students=11724, Avg_Undergrad_Unemployment_Rate=0.05503038316965103, Avg_Grad_Unemployment_Rate=0.0453583300113678, Avg_Undergrad_Median_Salary=50000.0, Avg_Grad_Median_Salary=74000.0), Row(Major='ENGINEERING AND INDUSTRIAL MANAGEMENT', Major_category='Engineering', Total_Undergrad_Grads=2906, Total_Grad_Students=20177, Avg_Undergrad_Unemployment_Rate=0.03365166112780571, Avg_Grad_Unemployment_Rate=0.0946376696228981, Avg_Undergrad_Median_Salary=44000.0, Avg_Grad_Median_Salary=107000.0), Row(Major='ELECTRICAL, MECHANICAL, AND PRECISION TECHNOLOGIES AND PRODUCTION', Major_category='Industrial Arts & Consumer Services', Total_Undergrad_Grads=2435, Total_Grad_Students=3187, Avg_Undergrad_Unemployment_Rate=0.029479503631591797, Avg_Grad_Unemployment_Rate=0.13851498067378998, Avg_Undergrad_Median_Salary=38400.0, Avg_Grad_Median_Salary=62000.0), Row(Major='SOCIAL PSYCHOLOGY', Major_category='Psychology & Social Work', Total_Undergrad_Grads=1386, Total_Grad_Students=7007, Avg_Undergrad_Unemployment_Rate=0.02964959666132927, Avg_Grad_Unemployment_Rate=0.061080656945705414, Avg_Undergrad_Median_Salary=36000.0, Avg_Grad_Median_Salary=71000.0), Row(Major='NAVAL ARCHITECTURE AND MARINE ENGINEERING', Major_category='Engineering', Total_Undergrad_Grads=1258, Total_Grad_Students=10801, Avg_Undergrad_Unemployment_Rate=0.05012531206011772, Avg_Grad_Unemployment_Rate=0.031891971826553345, Avg_Undergrad_Median_Salary=70000.0, Avg_Grad_Median_Salary=102000.0), Row(Major='COURT REPORTING', Major_category='Law & Public Policy', Total_Undergrad_Grads=1148, Total_Grad_Students=1542, Avg_Undergrad_Unemployment_Rate=0.011689691804349422, Avg_Grad_Unemployment_Rate=0.0, Avg_Undergrad_Median_Salary=54000.0, Avg_Grad_Median_Salary=75000.0), Row(Major='MATHEMATICS AND COMPUTER SCIENCE', Major_category='Computers & Mathematics', Total_Undergrad_Grads=609, Total_Grad_Students=4810, Avg_Undergrad_Unemployment_Rate=0.0, Avg_Grad_Unemployment_Rate=0.10289017111063004, Avg_Undergrad_Median_Salary=42000.0, Avg_Grad_Median_Salary=98000.0)]
SELECT rg.Major, rg.Total AS Total_Undergrad_Grads, gs.Grad_total AS Total_Grad_Students, rg.Median AS Undergrad_Median_Salary, gs.Grad_median AS Grad_Median_Salary FROM RecentGradsDB rg JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code WHERE rg.Total > 10000 ORDER BY rg.Total DESC, rg.Median DESC LIMIT 5;
[Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Total_Undergrad_Grads=329927, Total_Grad_Students=813399, Undergrad_Median_Salary=38000, Grad_Median_Salary=77000), Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Total_Undergrad_Grads=329927, Total_Grad_Students=813399, Undergrad_Median_Salary=38000, Grad_Median_Salary=77000), Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Total_Undergrad_Grads=329927, Total_Grad_Students=813399, Undergrad_Median_Salary=38000, Grad_Median_Salary=77000), Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Total_Undergrad_Grads=329927, Total_Grad_Students=813399, Undergrad_Median_Salary=38000, Grad_Median_Salary=77000), Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Total_Undergrad_Grads=329927, Total_Grad_Students=813399, Undergrad_Median_Salary=38000, Grad_Median_Salary=77000)]
SELECT Major, 'Undergrad' AS Degree_Level, Total AS Total_Students FROM RecentGradsDB WHERE Total > 5000 UNION SELECT Major, 'Graduate' AS Degree_Level, Grad_total AS Total_Students FROM GradStudentsDB WHERE Grad_total > 5000 ORDER BY Total_Students DESC;
[Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Degree_Level='Graduate', Total_Students=813399), Row(Major='GENERAL BUSINESS', Degree_Level='Graduate', Total_Students=602964), Row(Major='NURSING', Degree_Level='Graduate', Total_Students=573467), Row(Major='ACCOUNTING', Degree_Level='Graduate', Total_Students=569677), Row(Major='ECONOMICS', Degree_Level='Graduate', Total_Students=517614), Row(Major='ELECTRICAL ENGINEERING', Degree_Level='Graduate', Total_Students=482767), Row(Major='SOCIOLOGY', Degree_Level='Graduate', Total_Students=368710), Row(Major='MECHANICAL ENGINEERING', Degree_Level='Graduate', Total_Students=347342), Row(Major='BUSINESS MANAGEMENT AND ADMINISTRATION', Degree_Level='Undergrad', Total_Students=329927), Row(Major='COMPUTER SCIENCE', Degree_Level='Graduate', Total_Students=324402), Row(Major='FINANCE', Degree_Level='Graduate', Total_Students=301650), Row(Major='GENERAL ENGINEERING', Degree_Level='Graduate', Total_Students=268473), Row(Major='COMMUNICATIONS', Degree_Level='Graduate', Total_Students=266084), Row(Major='GENERAL BUSINESS', Degree_Level='Undergrad', Total_Students=234590), Row(Major='MULTI-DISCIPLINARY OR GENERAL SCIENCE', Degree_Level='Graduate', Total_Students=223467), Row(Major='COMMUNICATIONS', Degree_Level='Undergrad', Total_Students=213996), Row(Major='LIBERAL ARTS', Degree_Level='Graduate', Total_Students=213970), Row(Major='NURSING', Degree_Level='Undergrad', Total_Students=209394), Row(Major='MARKETING AND MARKETING RESEARCH', Degree_Level='Undergrad', Total_Students=205211), Row(Major='PHYSICAL AND HEALTH EDUCATION TEACHING', Degree_Level='Graduate', Total_Students=202105), Row(Major='ACCOUNTING', Degree_Level='Undergrad', Total_Students=198633), Row(Major='CIVIL ENGINEERING', Degree_Level='Graduate', Total_Students=196344), Row(Major='MARKETING AND MARKETING RESEARCH', Degree_Level='Graduate', Total_Students=190996), Row(Major='CRIMINAL JUSTICE AND FIRE PROTECTION', Degree_Level='Graduate', Total_Students=188228), Row(Major='POLITICAL SCIENCE AND GOVERNMENT', Degree_Level='Undergrad', Total_Students=182621), Row(Major='FINE ARTS', Degree_Level='Graduate', Total_Students=181514), Row(Major='FINANCE', Degree_Level='Undergrad', Total_Students=174506), Row(Major='THEOLOGY AND RELIGIOUS VOCATIONS', Degree_Level='Graduate', Total_Students=165460), Row(Major='CRIMINAL JUSTICE AND FIRE PROTECTION', Degree_Level='Undergrad', Total_Students=152824), Row(Major='FAMILY AND CONSUMER SCIENCES', Degree_Level='Graduate', Total_Students=149084), Row(Major='ARCHITECTURE', Degree_Level='Graduate', Total_Students=148255), Row(Major='TREATMENT THERAPY PROFESSIONS', Degree_Level='Graduate', Total_Students=142285), Row(Major='ECONOMICS', Degree_Level='Undergrad', Total_Students=139247), Row(Major='COMPUTER SCIENCE', Degree_Level='Undergrad', Total_Students=128319), Row(Major='JOURNALISM', Degree_Level='Graduate', Total_Students=119953), Row(Major='PHYSICAL FITNESS PARKS RECREATION AND LEISURE', Degree_Level='Graduate', Total_Students=119489), Row(Major='COMMERCIAL ART AND GRAPHIC DESIGN', Degree_Level='Undergrad', Total_Students=103480), Row(Major='MECHANICAL ENGINEERING', Degree_Level='Undergrad', Total_Students=91227), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Degree_Level='Graduate', Total_Students=86791), Row(Major='EARLY CHILDHOOD EDUCATION', Degree_Level='Graduate', Total_Students=82430), Row(Major='COMPUTER ENGINEERING', Degree_Level='Graduate', Total_Students=82102), Row(Major='ELECTRICAL ENGINEERING', Degree_Level='Undergrad', Total_Students=81527), Row(Major='GENERAL SOCIAL SCIENCES', Degree_Level='Graduate', Total_Students=73350), Row(Major='JOURNALISM', Degree_Level='Undergrad', Total_Students=72619), Row(Major='HUMAN RESOURCES AND PERSONNEL MANAGEMENT', Degree_Level='Graduate', Total_Students=72548), Row(Major='MATHEMATICS', Degree_Level='Undergrad', Total_Students=72397), Row(Major='COMPUTER AND INFORMATION SYSTEMS', Degree_Level='Graduate', Total_Students=71527), Row(Major='DRAMA AND THEATER ARTS', Degree_Level='Graduate', Total_Students=66560), Row(Major='CHEMISTRY', Degree_Level='Undergrad', Total_Students=66530), Row(Major='GENERAL MEDICAL AND HEALTH SERVICES', Degree_Level='Graduate', Total_Students=64284), Row(Major='MULTI-DISCIPLINARY OR GENERAL SCIENCE', Degree_Level='Undergrad', Total_Students=62052), Row(Major='GENERAL ENGINEERING', Degree_Level='Undergrad', Total_Students=61152), Row(Major='ANIMAL SCIENCES', Degree_Level='Graduate', Total_Students=56807), Row(Major='ART HISTORY AND CRITICISM', Degree_Level='Graduate', Total_Students=56666), Row(Major='COMMERCIAL ART AND GRAPHIC DESIGN', Degree_Level='Graduate', Total_Students=53864), Row(Major='ADVERTISING AND PUBLIC RELATIONS', Degree_Level='Undergrad', Total_Students=53162), Row(Major='CIVIL ENGINEERING', Degree_Level='Undergrad', Total_Students=53153), Row(Major='GEOGRAPHY', Degree_Level='Graduate', Total_Students=52147), Row(Major='MISCELLANEOUS HEALTH MEDICAL PROFESSIONS', Degree_Level='Graduate', Total_Students=51566), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Degree_Level='Graduate', Total_Students=47029), Row(Major='ARCHITECTURE', Degree_Level='Undergrad', Total_Students=46420), Row(Major='HEALTH AND MEDICAL ADMINISTRATIVE SERVICES', Degree_Level='Graduate', Total_Students=45452), Row(Major='GENERAL AGRICULTURE', Degree_Level='Graduate', Total_Students=44306), Row(Major='ENVIRONMENTAL SCIENCE', Degree_Level='Graduate', Total_Students=43612), Row(Major='MASS MEDIA', Degree_Level='Graduate', Total_Students=42915), Row(Major='MANAGEMENT INFORMATION SYSTEMS AND STATISTICS', Degree_Level='Graduate', Total_Students=41970), Row(Major='COMPUTER ENGINEERING', Degree_Level='Undergrad', Total_Students=41542), Row(Major='NUTRITION SCIENCES', Degree_Level='Graduate', Total_Students=40740), Row(Major='BIOCHEMICAL SCIENCES', Degree_Level='Undergrad', Total_Students=39107), Row(Major='COMPUTER AND INFORMATION SYSTEMS', Degree_Level='Undergrad', Total_Students=36698), Row(Major='COMMUNITY AND PUBLIC HEALTH', Degree_Level='Graduate', Total_Students=35543), Row(Major='ADVERTISING AND PUBLIC RELATIONS', Degree_Level='Graduate', Total_Students=33928), Row(Major='PRE-LAW AND LEGAL STUDIES', Degree_Level='Graduate', Total_Students=33137), Row(Major='INTERCULTURAL AND INTERNATIONAL STUDIES', Degree_Level='Graduate', Total_Students=32549), Row(Major='CHEMICAL ENGINEERING', Degree_Level='Undergrad', Total_Students=32260), Row(Major='PHYSICS', Degree_Level='Undergrad', Total_Students=32142), Row(Major='AREA ETHNIC AND CIVILIZATION STUDIES', Degree_Level='Undergrad', Total_Students=31195), Row(Major='INTERNATIONAL BUSINESS', Degree_Level='Graduate', Total_Students=30985), Row(Major='PLANT SCIENCE AND AGRONOMY', Degree_Level='Graduate', Total_Students=30983), Row(Major='INTERDISCIPLINARY SOCIAL SCIENCES', Degree_Level='Graduate', Total_Students=30233), Row(Major='BUSINESS ECONOMICS', Degree_Level='Graduate', Total_Students=30210), Row(Major='NATURAL RESOURCES MANAGEMENT', Degree_Level='Graduate', Total_Students=29357), Row(Major='HUMAN SERVICES AND COMMUNITY ORGANIZATION', Degree_Level='Graduate', Total_Students=29262), Row(Major='STUDIO ARTS', Degree_Level='Graduate', Total_Students=28883), Row(Major='INTERNATIONAL RELATIONS', Degree_Level='Undergrad', Total_Students=28187), Row(Major='ELECTRICAL ENGINEERING TECHNOLOGY', Degree_Level='Graduate', Total_Students=28155), Row(Major='HUMANITIES', Degree_Level='Graduate', Total_Students=27477), Row(Major='TRANSPORTATION SCIENCES AND TECHNOLOGIES', Degree_Level='Graduate', Total_Students=27410), Row(Major='MISCELLANEOUS ENGINEERING', Degree_Level='Graduate', Total_Students=26032), Row(Major='ENVIRONMENTAL SCIENCE', Degree_Level='Undergrad', Total_Students=25965), Row(Major='INTERNATIONAL BUSINESS', Degree_Level='Undergrad', Total_Students=25894), Row(Major='INFORMATION SCIENCES', Degree_Level='Graduate', Total_Students=25799), Row(Major='FORESTRY', Degree_Level='Graduate', Total_Students=24713), Row(Major='FILM VIDEO AND PHOTOGRAPHIC ARTS', Degree_Level='Graduate', Total_Students=24525), Row(Major='HUMAN RESOURCES AND PERSONNEL MANAGEMENT', Degree_Level='Undergrad', Total_Students=24497), Row(Major='HOSPITALITY MANAGEMENT', Degree_Level='Graduate', Total_Students=24417), Row(Major='PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION', Degree_Level='Undergrad', Total_Students=23551), Row(Major='MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION', Degree_Level='Graduate', Total_Students=22553), Row(Major='ECOLOGY', Degree_Level='Graduate', Total_Students=21535), Row(Major='COMPOSITION AND RHETORIC', Degree_Level='Graduate', Total_Students=21250), Row(Major='ENGINEERING AND INDUSTRIAL MANAGEMENT', Degree_Level='Graduate', Total_Students=20177), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Degree_Level='Graduate', Total_Students=19885), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Degree_Level='Undergrad', Total_Students=18968), Row(Major='MANAGEMENT INFORMATION SYSTEMS AND STATISTICS', Degree_Level='Undergrad', Total_Students=18713), Row(Major='MEDICAL ASSISTING SERVICES', Degree_Level='Graduate', Total_Students=18654), Row(Major='CRIMINOLOGY', Degree_Level='Graduate', Total_Students=18499), Row(Major='CONSTRUCTION SERVICES', Degree_Level='Undergrad', Total_Students=18498), Row(Major='GEOGRAPHY', Degree_Level='Undergrad', Total_Students=18480), Row(Major='VISUAL AND PERFORMING ARTS', Degree_Level='Graduate', Total_Students=18324), Row(Major='MOLECULAR BIOLOGY', Degree_Level='Undergrad', Total_Students=18300), Row(Major='MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION', Degree_Level='Undergrad', Total_Students=17947), Row(Major='AGRICULTURE PRODUCTION AND MANAGEMENT', Degree_Level='Graduate', Total_Students=17488), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Degree_Level='Undergrad', Total_Students=15914), Row(Major='MICROBIOLOGY', Degree_Level='Undergrad', Total_Students=15232), Row(Major='AEROSPACE ENGINEERING', Degree_Level='Undergrad', Total_Students=15058), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Degree_Level='Graduate', Total_Students=15056), Row(Major='BIOMEDICAL ENGINEERING', Degree_Level='Undergrad', Total_Students=14955), Row(Major='MISCELLANEOUS ENGINEERING TECHNOLOGIES', Degree_Level='Graduate', Total_Students=14816), Row(Major='AGRICULTURAL ECONOMICS', Degree_Level='Graduate', Total_Students=14800), Row(Major='FOOD SCIENCE', Degree_Level='Graduate', Total_Students=14521), Row(Major='MULTI/INTERDISCIPLINARY STUDIES', Degree_Level='Graduate', Total_Students=14405), Row(Major='AGRICULTURE PRODUCTION AND MANAGEMENT', Degree_Level='Undergrad', Total_Students=14240), Row(Major='PRE-LAW AND LEGAL STUDIES', Degree_Level='Undergrad', Total_Students=13528), Row(Major='MISCELLANEOUS HEALTH MEDICAL PROFESSIONS', Degree_Level='Undergrad', Total_Students=13386), Row(Major='BUSINESS ECONOMICS', Degree_Level='Undergrad', Total_Students=13302), Row(Major='INFORMATION SCIENCES', Degree_Level='Undergrad', Total_Students=11913), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Degree_Level='Undergrad', Total_Students=11732), Row(Major='ENGINEERING TECHNOLOGIES', Degree_Level='Graduate', Total_Students=11724), Row(Major='ELECTRICAL ENGINEERING TECHNOLOGY', Degree_Level='Undergrad', Total_Students=11565), Row(Major='COMPUTER NETWORKING AND TELECOMMUNICATIONS', Degree_Level='Graduate', Total_Students=11165), Row(Major='MEDICAL ASSISTING SERVICES', Degree_Level='Undergrad', Total_Students=11123), Row(Major='GEOLOGY AND EARTH SCIENCE', Degree_Level='Undergrad', Total_Students=10972), Row(Major='NAVAL ARCHITECTURE AND MARINE ENGINEERING', Degree_Level='Graduate', Total_Students=10801), Row(Major='GENERAL AGRICULTURE', Degree_Level='Undergrad', Total_Students=10399), Row(Major='COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY', Degree_Level='Graduate', Total_Students=10290), Row(Major='MISCELLANEOUS ENGINEERING', Degree_Level='Undergrad', Total_Students=9133), Row(Major='COMMUNICATION TECHNOLOGIES', Degree_Level='Graduate', Total_Students=9109), Row(Major='BIOLOGICAL ENGINEERING', Degree_Level='Undergrad', Total_Students=8925), Row(Major='MISCELLANEOUS ENGINEERING TECHNOLOGIES', Degree_Level='Undergrad', Total_Students=8804), Row(Major='COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY', Degree_Level='Undergrad', Total_Students=8066), Row(Major='COMPUTER NETWORKING AND TELECOMMUNICATIONS', Degree_Level='Undergrad', Total_Students=7613), Row(Major='PETROLEUM ENGINEERING', Degree_Level='Graduate', Total_Students=7479), Row(Major='SOCIAL PSYCHOLOGY', Degree_Level='Graduate', Total_Students=7007), Row(Major='ARCHITECTURAL ENGINEERING', Degree_Level='Graduate', Total_Students=6466), Row(Major='STATISTICS AND DECISION SCIENCE', Degree_Level='Undergrad', Total_Students=6251), Row(Major='MINING AND MINERAL ENGINEERING', Degree_Level='Graduate', Total_Students=6083), Row(Major='MECHANICAL ENGINEERING RELATED TECHNOLOGIES', Degree_Level='Graduate', Total_Students=6065), Row(Major='PUBLIC POLICY', Degree_Level='Undergrad', Total_Students=5978), Row(Major='PUBLIC ADMINISTRATION', Degree_Level='Undergrad', Total_Students=5629), Row(Major='COMPUTER PROGRAMMING AND DATA PROCESSING', Degree_Level='Graduate', Total_Students=5611), Row(Major='COSMETOLOGY SERVICES AND CULINARY ARTS', Degree_Level='Graduate', Total_Students=5411), Row(Major='MISCELLANEOUS AGRICULTURE', Degree_Level='Graduate', Total_Students=5032)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs
ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05 -- High undergraduate employment rate
AND gs.Grad_unemployment_rate < 0.05 -- High graduate employment rate
ORDER BY Salary_Premium DESC;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL AND MANUFACTURING ENGINEERING', Undergrad_Employed=15604, Grad_Employed=66432, Undergrad_Unemployment_Rate=0.04287554323673248, Grad_Unemployment_Rate=0.03862462192773819, Salary_Premium=41000), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='INDUSTRIAL PRODUCTION TECHNOLOGIES', Undergrad_Employed=4428, Grad_Employed=14752, Undergrad_Unemployment_Rate=0.028308097273111343, Grad_Unemployment_Rate=0.03927059471607208, Salary_Premium=38500), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='MEDICAL ASSISTING SERVICES', Undergrad_Employed=9168, Grad_Employed=14499, Undergrad_Unemployment_Rate=0.04250652715563774, Grad_Unemployment_Rate=0.025342833250761032, Salary_Premium=38000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='NURSING', Undergrad_Employed=180903, Grad_Employed=437115, Undergrad_Unemployment_Rate=0.04486272484064102, Grad_Unemployment_Rate=0.02126673422753811, Salary_Premium=36000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='MEDICAL TECHNOLOGIES TECHNICIANS', Undergrad_Employed=13150, Grad_Employed=37639, Undergrad_Unemployment_Rate=0.036982789635658264, Grad_Unemployment_Rate=0.025552736595273018, Salary_Premium=31000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='GENERAL AGRICULTURE', Undergrad_Employed=8884, Grad_Employed=28930, Undergrad_Unemployment_Rate=0.019642462953925133, Grad_Unemployment_Rate=0.02932492271065712, Salary_Premium=28000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000), Row(Major='COURT REPORTING', Undergrad_Employed=930, Grad_Employed=1008, Undergrad_Unemployment_Rate=0.011689691804349422, Grad_Unemployment_Rate=0.0, Salary_Premium=21000)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05
AND gs.Grad_unemployment_rate < 0.05
ORDER BY Salary_Premium DESC
LIMIT 5;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05
AND gs.Grad_unemployment_rate < 0.05
ORDER BY Salary_Premium DESC
LIMIT 5;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05
AND gs.Grad_unemployment_rate < 0.05
ORDER BY Salary_Premium DESC
LIMIT 5;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05
AND gs.Grad_unemployment_rate < 0.05
ORDER BY Salary_Premium DESC
LIMIT 5;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000)]
SELECT
rg.Major,
rg.Employed AS Undergrad_Employed,
gs.Grad_employed AS Grad_Employed,
rg.Unemployment_rate AS Undergrad_Unemployment_Rate,
gs.Grad_unemployment_rate AS Grad_Unemployment_Rate,
(gs.Grad_median - rg.Median) AS Salary_Premium
FROM RecentGradsDB rg
JOIN GradStudentsDB gs ON rg.Major_code = gs.Major_code
WHERE rg.Unemployment_rate < 0.05
AND gs.Grad_unemployment_rate < 0.05
ORDER BY Salary_Premium DESC
LIMIT 5;
[Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000), Row(Major='OPERATIONS LOGISTICS AND E-COMMERCE', Undergrad_Employed=10027, Grad_Employed=12659, Undergrad_Unemployment_Rate=0.04785870388150215, Grad_Unemployment_Rate=0.02284832112491131, Salary_Premium=44000)]