Sql Week 4

Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.

STEP 2:

Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of “Publisher ID” for the pubid field.

STEP 3:

Using the BOOKS table, write a query that will list the book title, retail price, and the amount of markup for each book. The amount of markup is the…

Leave a Reply

Your email address will not be published. Required fields are marked *