SQL Statement: For each description below, list in which SQL clause you would need to place the criteria.

a. A store tracks the materials they use in their clothing in a database table. They want to know all materials having 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.