Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a query to display the title, isbn, and author(s) first name and last name for each book using JOIN...USING clause. Write a query to

Write a query to display the title, isbn, and author(s) first name and last name for each book using JOIN...USING clause. Write a query to show the first and last names, and the book titles for customers who have actually ordered books. Use the WHERE clause to join the tables. Write a query to show the title, retail price and ISBN of each book in the books table. If the book has been ordered, show the order number and order date. Use the OUTER JOIN keywords to join the tables. Sort the titles in descending alphabetical order. Write a query to show the gift a customer will receive if he or she orders Database Implementation. Use either the WHERE clause or a JOIN keyword to join the tables. Write a query to show the profit of each book sold to customers that live in New Jersey. Calculate the profit by subtracting the cost from the paideach column and multiply by quantity in the orderitems table. Use the WHERE clause to the join the tables.

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

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions