Computer Science Homework Solutions
Problem
#23184

SQL Command

Find the name of each publisher containing the word "and". (Hint: Be sure that your query selects only those publishers that contain the word "and" and not those that contain the letters "and" in the middle of a word.  For example, your querry should select the publisher named "Farrar and Giroux," but should not select the publisher named "Random House.") This process is done by SQL.  
I tried this but keep getting Random House in my query.
SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '%and%'
;

Any ideas will be very helpful.

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$3.99)
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
  • Access 2000 Database - Use the attached WEEK2_ACCESS2000.mdb database I just need the SQL code, which can be cut and pasted into a word document. 1. Perform an inner join between the BOOKS table and the ORDER_LINE ...
  • Discuss whether Google (or other search engines) should be allowed to make everything that is in print available online - Discuss whether Google (or other search engines) should be allowed to make everything that is in print available online, including traditionally for-fee content (like books currently in print and on s ...
  • SQL Replication - This project will challenge you to set up replication on your SQL Server installation. Every step to complete this process is not laid out for you here. Complete the steps and document your choices th ...
  • Windows Applications - Your assignment is to organize a charity event. You can be as creative as you want here. Here are conditions of your assignment: 1. You must use at least two programs, one of which must be a Windows ...
  • Er diagram and business rules - Develop a database in MS Access and a set of reports to support a business like Amazon.com. The following business rules should be addressed. · Customer's may order multiple items · Customer brows ...
Browse