CREATE DATABASE occupations; USE occupations; DROP TABLE IF EXISTS Occupations; TODO: create table Occupations -- TODO: populate table Occupations TODO: a) the total number of occupations (expect 1016). TODO: b) a list of all job families in alphabetical order (expect 23). TODO: c) the total number of job families (expect 23) TODO: d) the total number of occupations per job family in alphabetical order of job family. TODO: e) the number of occupations in the "Computer and Mathematical" job family expect 38) -- TODO: f) an alphabetical list of occupations in the "Computer and Mathematical" job family. TODO: g) an alphabetical list of occupations in the "Computer and Mathematical" job family that begins with the word "Database" D E F 1 2 3 4 5 6 7 8 9 A B Code Occupation 13-2011.00 Accountants and Auditors 27-2011.00 Actors 15-2011.00 Actuaries 29-1291.00 Acupuncturists 29-1141.01 Acute Care Nurses 25-2059.01 Adapted Physical Education Specialists 51-9191.00 Adhesive Bonding Machine Operators and Tenders 23-1021.00 Administrative Law Judges, Adjudicators, and Hearing Officers 11-3012.00 Administrative Services Managers 25-3011.00 Adult Basic Education, Adult Secondary Education, and English as a Second Language Instructors Job Family Business and Financial Operations Arts, Design, Entertainment, Sports, and Media Computer and Mathematical Healthcare Practitioners and Technical Healthcare Practitioners and Technical Educational Instruction and Library Production Legal Management Educational Instruction and Library 10 11