PART$1$: Airline DB $(10$ points$)$ Consider the following Airline DB that keeps track of mechanics, their skills, and their airport locations. Snapshot of Airline DB Note: $$ Mechanic Number $($MECHNUM$),$ airport name $($AIRNAME$),$ and skill number are all unique fields. $$ SIZE is an airport$$s size in acres. $$ SKILLCAT is a skill$$s category $($e$.$g$.,$ engine skill, wing skill, tire skill, etc.$)$ YEARQUAL is the year when a mechanic was first qualified in a skill $$ PRORATE is the mechanic$$s proficiency rating in a skill $1.$ Create a query that lists the names of the mechanics who work in the state of Texas. $2.$ Create a query that shows the names of all mechanics with skills $($SKILLNAME$)$ and airports where they work. The result should be sorted by airport name in an ascending order. $3.$ Create a query that displays average proficiency ratings of all mechanics per each skill $($e$.$g$.,$ engine replacement with $6\mathrm{.}7,$ tire change with $7\mathrm{.}2,$ etc. $$ these numbers are fabricated$).$ This must have skills and average proficiency ratings of mechanic. Average must be rounded to $2$ decimal places with the highest coming on top with appropriate alias. $4.$ Create a query that finds the largest airport in California. You must use $$sub$-$query$$ instead of using AIRNAME $=$XXX$.5.$ Create a procedure that displays a mechanic$$s profile with name, age, salary, skills, and proficiency rating $($the parameter should be mechanic$$s number$).$