Question

1. Write a query that returns the titles of all books published by Alfred A. Knopf.

Answer 1

We assume that the table name in the database is books and assume there are these two columns namely title and author in this table. Now the query to return the title of all the books published by Alfred A.Knopf are (assuming you are using one of the well-known databases mentioned below):

SQL query:

SELECT title FROM books WHERE author = "Alfred A.Knopf";

MySQL query:

SELECT title FROM books WHERE author = "Alfred A.Knopf";

MongoDB query:

db.books.find({"author":"Alfred A.Knopf"},{"title" : 1}).pretty();

PostgreSQL query:

SELECT title FROM books WHERE author = "Alfred A.Knopf";

(all above queries select the values from title column in the books table for which the author column has value, Alfred A. Knopf)

assume the table is as given below:

id title author Book_name 1 Alfred A.Knopf 1 Book_name_2 Alfred A.Knopf 2 Book_name_3 Alfred A.Knopf 4 Book_name_4 Alfred A.Knopf Book_name_5 Alfred A.Knopf 5 Book_name 6 6 Alfred A.Knopf

Output (MySQL):

"Alfred A.Knopf"; select title from books where author

title Book_name 1 Book_name_2 Book_name_3 Book_name_4 Book_name_5 Book_name_6