Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

you can make and send one by one to me! YEAR + + + + + + + + + + CARNUM MODEL 27391 Justice

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
you can make and send one by one to me!
YEAR + + + + + + + + + + CARNUM MODEL 27391 Justice 48273 Beta 49291 Justice 123948 Beta 184737 Gold 283249 Prince 288299 Colorado 328151 Prince 372819 Alpha 383921 Gold 384422 Colorado 422810 Eagle 429212 Summer 429333 Venus 492190 Venus 573532 Alpha 584829 Summer 589020 Summer 602848 Star 612999 Lion 622991 Star 682919 Lion 682925 Star 728100 Mars 842747 Eagle CLASS MANUFNAN - 2001 Compact Milan Motors 1999 Convertible Capital Motors 2002 Compact Milan Motors 2001 Convertible Capital Motors 2000 Minivan Milan Motors 1999 Compact Rome Motors 2002 Sedan Superior Moto 2000 Compact Rome Motors 2002 Sedan Capital Motors 2000 Minivan Milan Motors 2002 Sedan Superior Moto 2000 SUV Digital Motors 2001 SUV Superior Moto 1999 Sedan Naples Motors 2000 Sedan Naples Motors 2002 Sedan Capital Motors 2000 SUV Superior Moto 2000 SUV Superior Moto 2000 Compact Superior Moto 2001 Minivan Naples Motors 1999 Compact Superior Moto 2001 Minivan Naples Motors 2000 Compact Superior Moto 2000 Sedan Milan Motors 2000 SUV Digital Motors + + + + Y + + + + + + CUSTNUM CUSTNAME - CUSTADDR CUSTPHONE 89287 Zhang Washington, D 202 555 1248 133819 Martin Memphis, TN 901 555 3290 182194 Chen Los Angeles, C 213 555 2142 246754 Adams Memphis, TN 901 555 3819 285028 Perez Los Angeles, C 213 555 2934 294827 Baker Chicago, IL 312 555 2288 381074 Bunker Miami, FL 305 555 2982 429292 Reddy Washington, D 202 555 2292 482910 Baker New York, NY 212 555 2819 539118 Jackson Dallas, TX 214 555 4912 592937 Johnson Chicago, IL 312 555 2342 730282 Jefferson Miami, FL 305 555 9124 876586 George Troy, NY 518 555 2299 925820 Stewart Columbus, OH 614 555 2821 956732 Carter Memphis, TN 901 555 2211 + + + + + + + + AINTENANCE CARNUM Date PROCEDURE MILEAGE REPAIRTIME 60 55 60 60 15 15 20 15 65 CUSTOMER REPAIRNUM 456 27381 27472 27556 27622 38201 38294 38299 38305 38312 38314 38329 38333 38347 38348 38357 38362 38377 38378 38381 38385 46332 46543 47345 47425 47572 47600 47632 123948 372819 184737 584829 728100 288299 602848 384422 584829 288299 584829 602848 589020 288299 589020 429212 584829 602848 384422 602848 589020 288299 429212 184737 429333 728100 573532 602848 05.08.2008 Tune-Up 07.08.2008 Tune-Up 11.08.2008 Tune-Up 15.08.2008 Tune-Up 01.03.2009 Oil Change 01.03.2009 Oil Change 01.03.2009 Oil Change 02.03.2009 Oil Change 04.03.2009 Tune-Up 06.03.2009 Tune-Up 07.03.2009 Oil Change 12.03.2009 Oil Change 12.03.2009 Tire Rotation 15.03.2010 Tune-Up 16.03.2010 Oil Change 18.03.2010 Tire Rotation 21.03.2010 Tire Rotation 24.03.2010 Tune-Up 25.03.2010 Radiator Flush 02.04.2011 Tire Rotation 05.01.2011 Oil Change 12.01.2011 Oil Change 10.01.2011 Oil Change 22.01.2011 Oil Change 30.01.2011 Oil Change 25.01.2011 Oil Change 12.02.2011 Oil Change 32817 27161 35900 19427 34456 26635 19355 25431 34490 25903 26900 21563 34593 21904 32417 26854 27463 24321 28015 24231 32643 35621 35786 35825 36821 26317 35900 60 20 20 30 55 15 35 30 60 90 40 15 15 20 15 15 20 20 CAR CUSTOMER MAINTENANCE MANUFACTURER MANUFNAN COUNTRY SALESREPNA , SALESREPPE , Capital Motors Japan Smith 901 555 1234 Cooperative N USA Barton 607 555 2323 Digital Motors Japan Jones 212 555 4837 Milan Motors Italy Simpson 513 555 9900 Naples Motors Italy Jackson 809 555 7575 Rome Motors Italy Johnson 404 555 1122 Superior Moto USA Caldwell 207 555 2888 Tokyo Motors Japan Williams 201 555 3811 * MANUFACTURER CARNUM , CUSTNUM - RENTALDAT RETURNDAT - 49291 592937 20.10.2010 25.10.2010 184737 429292 23.05.2010 25.05.2010 283249 592937 12.12.2008 16.12.2008 328151 89287 10.12.2010 17.12.2010 328151 133819 21.04.2011 23.04.2011 328151 133819 21.06.2011 25.06.2011 384422 381074 23.05.2010 25.05.2010 429212 89287 16.11.2008 21.11.2008 429212 592937 31.01.2011 02.02.2011 429212 876586 26.03.2009 29.03.2009 492190 285028 24.02.2011 26.02.2011 492190 285028 16.03.2011 21.03.2011 492190 285028 01.05.2011 03.05.2011 573532 89287 30.05.2010 05.06.2010 612999 246754 21.07.2011 23.07.2011 612999 925820 08.07.2010 09.07.2010 682925 956732 14.09.2009 15.09.2009 842747 246754 12.07.2010 19.07.2010 842747 429292 28.02.2011 04.03.2011 COST $366,00 $143,44 $245,98 $265,00 $100,00 $150,00 $157,00 $264,00 $261,00 $204,89 $145,00 $324,56 $90,00 $275,95 $220,00 $158,00 $75,00 $433,99 $326,00 * 5. List the cars of any manufacturer that had an oil change in January, 2011, and had at least as many miles as the highest-mileage car manufactured by Superior Motors that had an oil change that same month. 6. How much money was earned from each car manufacturer rental every year? How much money is earned from car rental each year? 7. Combine all car events (maintenances and rentals) in one list including car numbers, event date and event type (sort by event date ascending)? 8. How many maintenances and rentals happened with manufacturer's cars? If manufacturer maintenances are more than rentals then manufacturer is bad, in other case - good. 9. All information about rental with longest rental period. Rental period in days must appear. 10. How much money earned from rental by car manufacturer's country every year. 11. Show 20% of our best customers by total income. 12. Show customers who used our rental 2 or more times and customer's average money spending less then average rental price; 13. Show customer count by each state (for state show 2 letters abbreviation). Results sort by customer count descending order then by state abbreviation ascending; 14. Select car manufacturers which cars were not maintained in 2008. YEAR + + + + + + + + + + CARNUM MODEL 27391 Justice 48273 Beta 49291 Justice 123948 Beta 184737 Gold 283249 Prince 288299 Colorado 328151 Prince 372819 Alpha 383921 Gold 384422 Colorado 422810 Eagle 429212 Summer 429333 Venus 492190 Venus 573532 Alpha 584829 Summer 589020 Summer 602848 Star 612999 Lion 622991 Star 682919 Lion 682925 Star 728100 Mars 842747 Eagle CLASS MANUFNAN - 2001 Compact Milan Motors 1999 Convertible Capital Motors 2002 Compact Milan Motors 2001 Convertible Capital Motors 2000 Minivan Milan Motors 1999 Compact Rome Motors 2002 Sedan Superior Moto 2000 Compact Rome Motors 2002 Sedan Capital Motors 2000 Minivan Milan Motors 2002 Sedan Superior Moto 2000 SUV Digital Motors 2001 SUV Superior Moto 1999 Sedan Naples Motors 2000 Sedan Naples Motors 2002 Sedan Capital Motors 2000 SUV Superior Moto 2000 SUV Superior Moto 2000 Compact Superior Moto 2001 Minivan Naples Motors 1999 Compact Superior Moto 2001 Minivan Naples Motors 2000 Compact Superior Moto 2000 Sedan Milan Motors 2000 SUV Digital Motors + + + + Y + + + + + + CUSTNUM CUSTNAME - CUSTADDR CUSTPHONE 89287 Zhang Washington, D 202 555 1248 133819 Martin Memphis, TN 901 555 3290 182194 Chen Los Angeles, C 213 555 2142 246754 Adams Memphis, TN 901 555 3819 285028 Perez Los Angeles, C 213 555 2934 294827 Baker Chicago, IL 312 555 2288 381074 Bunker Miami, FL 305 555 2982 429292 Reddy Washington, D 202 555 2292 482910 Baker New York, NY 212 555 2819 539118 Jackson Dallas, TX 214 555 4912 592937 Johnson Chicago, IL 312 555 2342 730282 Jefferson Miami, FL 305 555 9124 876586 George Troy, NY 518 555 2299 925820 Stewart Columbus, OH 614 555 2821 956732 Carter Memphis, TN 901 555 2211 + + + + + + + + AINTENANCE CARNUM Date PROCEDURE MILEAGE REPAIRTIME 60 55 60 60 15 15 20 15 65 CUSTOMER REPAIRNUM 456 27381 27472 27556 27622 38201 38294 38299 38305 38312 38314 38329 38333 38347 38348 38357 38362 38377 38378 38381 38385 46332 46543 47345 47425 47572 47600 47632 123948 372819 184737 584829 728100 288299 602848 384422 584829 288299 584829 602848 589020 288299 589020 429212 584829 602848 384422 602848 589020 288299 429212 184737 429333 728100 573532 602848 05.08.2008 Tune-Up 07.08.2008 Tune-Up 11.08.2008 Tune-Up 15.08.2008 Tune-Up 01.03.2009 Oil Change 01.03.2009 Oil Change 01.03.2009 Oil Change 02.03.2009 Oil Change 04.03.2009 Tune-Up 06.03.2009 Tune-Up 07.03.2009 Oil Change 12.03.2009 Oil Change 12.03.2009 Tire Rotation 15.03.2010 Tune-Up 16.03.2010 Oil Change 18.03.2010 Tire Rotation 21.03.2010 Tire Rotation 24.03.2010 Tune-Up 25.03.2010 Radiator Flush 02.04.2011 Tire Rotation 05.01.2011 Oil Change 12.01.2011 Oil Change 10.01.2011 Oil Change 22.01.2011 Oil Change 30.01.2011 Oil Change 25.01.2011 Oil Change 12.02.2011 Oil Change 32817 27161 35900 19427 34456 26635 19355 25431 34490 25903 26900 21563 34593 21904 32417 26854 27463 24321 28015 24231 32643 35621 35786 35825 36821 26317 35900 60 20 20 30 55 15 35 30 60 90 40 15 15 20 15 15 20 20 CAR CUSTOMER MAINTENANCE MANUFACTURER MANUFNAN COUNTRY SALESREPNA , SALESREPPE , Capital Motors Japan Smith 901 555 1234 Cooperative N USA Barton 607 555 2323 Digital Motors Japan Jones 212 555 4837 Milan Motors Italy Simpson 513 555 9900 Naples Motors Italy Jackson 809 555 7575 Rome Motors Italy Johnson 404 555 1122 Superior Moto USA Caldwell 207 555 2888 Tokyo Motors Japan Williams 201 555 3811 * MANUFACTURER CARNUM , CUSTNUM - RENTALDAT RETURNDAT - 49291 592937 20.10.2010 25.10.2010 184737 429292 23.05.2010 25.05.2010 283249 592937 12.12.2008 16.12.2008 328151 89287 10.12.2010 17.12.2010 328151 133819 21.04.2011 23.04.2011 328151 133819 21.06.2011 25.06.2011 384422 381074 23.05.2010 25.05.2010 429212 89287 16.11.2008 21.11.2008 429212 592937 31.01.2011 02.02.2011 429212 876586 26.03.2009 29.03.2009 492190 285028 24.02.2011 26.02.2011 492190 285028 16.03.2011 21.03.2011 492190 285028 01.05.2011 03.05.2011 573532 89287 30.05.2010 05.06.2010 612999 246754 21.07.2011 23.07.2011 612999 925820 08.07.2010 09.07.2010 682925 956732 14.09.2009 15.09.2009 842747 246754 12.07.2010 19.07.2010 842747 429292 28.02.2011 04.03.2011 COST $366,00 $143,44 $245,98 $265,00 $100,00 $150,00 $157,00 $264,00 $261,00 $204,89 $145,00 $324,56 $90,00 $275,95 $220,00 $158,00 $75,00 $433,99 $326,00 * 5. List the cars of any manufacturer that had an oil change in January, 2011, and had at least as many miles as the highest-mileage car manufactured by Superior Motors that had an oil change that same month. 6. How much money was earned from each car manufacturer rental every year? How much money is earned from car rental each year? 7. Combine all car events (maintenances and rentals) in one list including car numbers, event date and event type (sort by event date ascending)? 8. How many maintenances and rentals happened with manufacturer's cars? If manufacturer maintenances are more than rentals then manufacturer is bad, in other case - good. 9. All information about rental with longest rental period. Rental period in days must appear. 10. How much money earned from rental by car manufacturer's country every year. 11. Show 20% of our best customers by total income. 12. Show customers who used our rental 2 or more times and customer's average money spending less then average rental price; 13. Show customer count by each state (for state show 2 letters abbreviation). Results sort by customer count descending order then by state abbreviation ascending; 14. Select car manufacturers which cars were not maintained in 2008

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Art And Science Of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Ingrid B. Splettstoesser-Hogeterp

11th Edition

0132088061, 978-0132088060

More Books

Students also viewed these Accounting questions

Question

What is nonverbal communication?

Answered: 1 week ago