IM ON A BUDGETT AND I NEED HELP
CS 2500 SQL Assignment 2
undefined
Write SQL statements for the requirements listed below. Format your Select statements as outlined in previous SQL assignment. Ensure all aggregate column results have names. Test each statement on the SQL server and then paste the SQL statement directly into this Word document and upload this Word document. 7 points each.
undefined
- List the mechanic name, number, and the city where they work for all plants that opened prior to 1940. Sort by mechanic name and number.
- List the average proficiency rating for each skill category name. Ensure the average result is a decimal value. Sort by category name.
- List the skill name and number of mechanics that have that skill. List all skills regardless of there being related mechanics. Sort by skill name.
- List mechanic name, mechanic number, skill name, and proficiency rating for all those skills within Interior and Exterior categories. Sort by skill name, mechanic name, and mechanic number.
- List the city, plant number, and the total mechanic salaries for each plant. List all plants in the system. Sort by city and plant number.
0 comments