Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a query to display the maximum, minimum, and average cost in the book table. Please help new to SQL. here is the imported .csv
Write a query to display the maximum, minimum, and average cost in the book table. Please help new to SQL.
here is the imported .csv for MySQL bench
Here is what is inside the .csv file
fact Tables author book > Columns BOOK_NUM BOOK_TITLE BOOK_YEAR BOOK_COST BOOK_SUBJECT PAT_ID BOOK_NUM BOOK_TITLE BOOK_YEAR BOOK_COST BOOK_SUBJECT PAT_ID 5235 Beginner's Guide to JAVA 2014 59.95 Programming 5236 Database in the Cloud 2014 79.95 Cloud 5237 Mastering the database environment 2015 89.95 Database 5238 Conceptual Programming 2015 59.95 Programming 1229 5239 J++ in Mobile Apps 2015 49.95 Programming 5240 iOS Programming 2015 79.95 Programming 1212 5241 JAVA First Steps 2015 49.95 Programming 5242 C# in Middleware Deployment 2015 59.95 Middleware 1228 5243 DATABASES in Theory 2015 129.95 Database 5244 Cloud-based Mobile Applications 2015 69.95 Cloud 5245 The Golden Road to Platform independence 2016 119.95 Middleware 5246 Capture the Cloud 2016 69.95 Cloud 1172 5247 Shining Through the Cloud: Sun Programming 2016 109.95 Programming 5248 What You Always wanted to Know About Database, But Were Afraid to Ask 2016 49.95 Database 5249 Starlight Applications 2016 69.95 Cloud 1207 5250 Reengineering the Middle Tier 2016 89.95 Middleware 5251 Thoughts on Revitalizing Ruby 2016 59.95 Programming 5252 Beyond the Database Veil 2016 69.95 Database 1229 5253 Virtual Programming for Virtual Environments 2016 79.95 Programming 5254 Coding Style for Maintenance 2017 49.95 ProgrammingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started