SQL Statement. For each description below, list in which SQL clause $($Select$,$ From, Where Groupby, Having, or Orderby$)$ you would use to create a query with these criteria.

a$.$ A store tracks the materials they use in their clothing on a database table. They want to know all materials with an average price of more than $$20/$sq$.$yard.

b$.$ A company has a log of customer transactions that includes the total price of the merchandise bought in that transaction. A manager wants a list of transactions sorted by these totals from highest to lowest.

c$.$ A retail merchandiser has a payroll table that tracks employee hours by store. The manager asks for a number of hours worked, but he wants this information shown by store.

d$.$ An oil company has a list of drill sites the company owns in a database table. They want to look at a list of drill sites located in Oklahoma.

An elementary school tracks their incoming students in a database. Shown below is the first five records of the student table $($there are more records$).$ The school wants to know the average $|$ age of the incoming students who are new to the school by the grade they are entering, sorted from highest to lowest grade $(0=$ Kindergarten$).$ Write the $SQL$ query to find that information.