Question
Using the HenryBooks Database Concepts of Database Management Do this in SQL Server Management 1. (Joins and Calculations) Henry Books wants to increase the price
Using the HenryBooks Database
Concepts of Database Management
Do this in SQL Server Management
1. (Joins and Calculations) Henry Books wants to increase the price of all Fiction Books. Write a query that returns the Book Code, Title, original Price, and NewPrice (calculated at 10% above the Original Price)
2. (Joins, SubQuery and Aggregation) The Book store wants to increase the overall quality of it's offerings. It wants to remove all less than good quality copies for the books that have Excellent copies available. Write a query that finds all the Bookcodes for copies that have excellent quality and then return the information about the Book to include the Book Title and the number of copies held of the Book.
3. (Joins, aggregations, and sorting) Find the Author First and Last Name, the number of books they have copies of from each publisher by Branch. You must include the Author First and Last Name, the BranchName, the PublisherName, and the count of all copies in your results.
In sql
Step 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