Computer Science Homework Solutions
Problem
#135244

Author and tittles

Using the week 2 lecture/homework database, show the author and titles of books that have never sold.

Here is the SQL for my question, but what are the author and titles of the books that did not sell?

select books.title ,books.author_name  from books where books.isbn not in ( select isbn from order_lines where shipped='Y' );

Attached file(s):
Attachments
WEEK2_ACCESS2000.mdb  View File
Solution
What is this?
By OTA - Overall OTA Rating
Ramesh Palipi, MSc (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Database Coding - 1. Using the order_lines table from the database from lecture 2, write the SQL that will give the Min and Max values of the column "cost_each" 2. Using the week 2 homework database, show each cus ...
  • Query in Access 2000 - You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering: OK, I'm writing a query in Access 2000: ...
  • Query Results - RIGHT Outer Join - Using the week 2 lecture database, if you wanted to see all the isbns from the books table and any matching isbns from the order_lines table, you'd want to do an outer join as such (because not every ...
  • Query - Using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;
  • Why wont this query run? - OK, why wont this query run (using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here)? SELECT author_name FROM author WHERE author_name like "Twain, Mark";
Browse