solve this question in SQL? I already uploaded the relation between the tables. The question is how
Question:
solve this question in SQL?
I already uploaded the relation between the tables.
The question is how I can know :
1- how many titles did each publisher publish?
2- select the titles and royalty rate for books with a royalty greater than 0.05. Order by the royalty rate in descending order?
3- Show the full name for all the authors (first and last name as a single value) and the titles for the books they wrote?
4- show me the publishers and the titles for all history books ?
5- show me the publisher name and the type of book for the title 1977
6-show me the sales and employee title for Lord Cooper
7- show me the name, sales and title for employees with sales greater than 500 - order by sales in ascending order?
8-select the titles, and publishers for books with an advance of $1,000,000.
9- show the title, the author's full name (first and last as a single value) for books with an advance larger than $1,000.
10-show the titles, publishers and the author full names (first and last as a single value) for all books.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi