Question: SQL exercises for a library database: a. Write a SELECT statement that returns the titles, and ISBN numbers of all the books with titles longer

SQL exercises for a library database:

a. Write a SELECT statement that returns the titles, and ISBN numbers of all the books with titles longer than 40 characters. List the books in the order of the lengths of their titles.

b. Repeat exercise a., this time selecting books with titles shorter than 20 characters OR longer than 40 characters.

c. Repeat exercise a., this time selecting books whose titles are longer than 20 characters but shorter than 40 characters.

d. Write a SELECT statement that returns the titles of all books containing the string PRO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I included a screen shot of the list of tables in this database. CODE IS to be scripted in SQL in SQL 1. SELECT a character string composed of the last two digits of the year of a title's pubdate,...

**Database management question* Do the following SQL questions. The resulting columns must all have descriptive names. You must show the result of the query. For example, if the query is: Show the...

Using a library database as an example, you will demonstrate how to retrieve data, insert data, and join tables using SQL. Assignment Instructions Assignment 2 contains 5 sections. You are required...

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

INFOAP2 Database Design Study Block Project The University Boole Library Database Modelling Project The University Boole Library has approximately 19,000, members, 200,000 book titles, and 500,000...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

What is the difference between static and kinetic friction? Compare the values of the coefficient of static and kinetic friction: is s > k ?

Use the information given for Pro Consultants, Inc., to calculate the following: a. Cash paid for utilities b. Cash paid for interest c. Cash paid for inventory items d. Cash collected from customers...

cvp analysis project Step \ # 5 4 ) Calculate the weighted average contribution margin ( WACM ) per unit. Check figure: WACM / unit = \ $ 1 3 . 9 6 5 ) Use the WACM / unit to calculate the TOTAL...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Foreign investors. These often bring fixed ideas about HRM in terms of organizational culture, management philosophy and practice.

3 How would the situation be different if Volkswagen were to establish a joint venture with a Russian company? What people management principles and practices should be put in place?

Strained labourmanagement relations that are deep-rooted. Long-term benefits, they believe, can be obtained through appropriate employee training on company survival, and both managers and employees...