Practce Problems

Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
Practice Problems
1. List the book title and retail price for all books with a retail price lower than the average retail price
of all books sold by JustLee Books.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
2. Determine which books cost less than the average cost of other books
in the same category.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
3. Determine which orders were shipped to the same state as order 1014.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
4. Determine which author or authors wrote the books most frequently
purchased by customers of JustLee Books.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
5. List the shipping city and state for the order that had the longest shipping delay.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Manpreet Sandhu
MS AIT 524
M7_1_Practce_Problems
6. Determine which books were published by the publisher of The Wok Way to Cook.
This study source was downloaded by 100000757387545 from CourseHero.com on 03-02-2023 23:42:15 GMT -06:00
https://www.coursehero.com/file/162070593/M7-1-Practice-Problemsdocx/
Powered by TCPDF (www.tcpdf.org)