Question: 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:

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Target Corporation prepares its financial statements according to U.S. GAAP. Target's financial statements and disclosure notes for the year ended February 1, 2020, are available here. This material...

In Regards to Question: Janies Pet Minding Janie is a local supplier of pet walking, i have to submit my MS Access file by early next week and can solve it by myself. please help! thank you. Janies...

if someone could please help me with all parts i would appreciate it so much! im freaking out!! thank you!! Nick Nohitter has been playing baseball since he was five years old and has always dreamed...

Application of Time Value of Money Skills Please help! (: Thank you! 1. Application of Time Value of Money Skills starting pitcher for a double-A (AA)-level baseball team, the Ketchum Baldies; last...

Please Please Help Me (Sorry there are a lot, I promise, its one question! Didn't want to leave anything out) Please please help me 1. Application of Time Value of Money Skills Gavin Goldenarm has...

Needing help with this! i know its a long question! please and thank you 16. Application of Time Harry Hurler has been playing baseball since he was five years old and has always dreamed of playing...

The instructions for this problem are under "contract evaluation worksheet" Please help me out. thank you. 16. Application of Time Value of Money Skills Saleem Swingman has been playing baseball...

Harry Hurler has been playing baseball since he was five years old and has always dreamed of playing in the big leagues. Last season, he was a starting pitcher for a double-A (AA)-level baseball...

6. Application of Time Value of Money Skills Dismiss All Please Wait . . . Please Wait... Saleem Swingman has been playing baseball since he was five years old and has always dreamed of playing in...

Please answer all the questions with detail. Thank you. If not willing to answer all questions please do not bother, dont leave it incomplete. Preble Company manufactures one product. Its variable...

Oregon Inc. reported a net income of $105,000. during the current year the company had $5,000 shares of 100 par, 5% stock, and $10,000 0f $5 par common stock outstanding Oregon's earning per share is:

Assume that you are considering replacing your old Nissan with a new Hyundai, as in the previous problem. However, the annual maintenance cost of the old Nissan increases as time goes by. It is...

which of the following are considered a direct or indect cost of potential bankrupcy? 1 . Agency costs 2 . Lost customers 3 . Legal fees 4 . A reduction in interest expenses 5 . Reduction in...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

4. What degree of alignment is there between the company values and the areas assessed?

5. How do you train assessors and what level of on-going training occurs to ensure rater consistency?

2. As Erica Liu, what analyses would you run to assess the financial performance of the RD membership program?