Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedhere is the imported .csv for MySQL bench

Here is what is inside the .csv file

image text in transcribed

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 Programming

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

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

List causes that could lead to a fixed overhead spending variance?

Answered: 1 week ago

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago