please answer all the queations in detail please and thank you

4) Answer the following queries based on the following database for a car dealer: a) What is the personid of Sheila O'Hara? b) List sales personnel sorted by last name and within last name, first name. c) List details of the sales made by Bruce Bush. d) List details of all sales showing the gross profit (selling price minus cost price). e) Report the number of cars sold of each type. f) What is the average selling price of cars sold by Sue Lim? g) Report details of all sales where the gross profit is less than the average. h) What was the maximum selling price of any car