sql practice

Write an SQL query to display the title and author of all books.

• SELECT books FROM title, author;

• SELECT title, author FROM books;

• SELECT author, catno FROM books;

• SELECT author, title FROM fiction;

Write an SQL query to display the title of all fiction books;

• SELECT books FROM title WHERE fiction = True;

• SELECT title FROM fiction;

• SELECT title FROM books WHERE fiction = True;

• SELECT fiction FROM books WHERE title = True;

Write a query to select titles of all paperback non-fiction books.

• SELECT title FROM books WHERE fiction = True and paperback = True;

• SELECT title FROM books WHERE fiction = False and paperback = True;

• SELECT title FROM books WHERE fiction = False;

• SELECT title FROM books WHERE paperback = False AND fiction = True;

Write an SQL query to display the title of all books that are under the price of 20.00.

• WHERE price = 20.00 SELECT title FROM books;

• SELECT title FROM books WHERE price = 20.00;

• SELECT title FROM books WHERE price > 20.00;

• SELECT title FROM books WHERE price < 20.00;

How many rows will the following query display? SELECT title FROM books WHERE fiction = False;

• 5

• 3

• 8

• 4

What will be the first row displayed for the following query? SELECT title FROM books WHERE paperback = True ORDER BY stocklevel ASCENDING;

• Computer Science

• The Princes' Story

• The Princess' Story

• The Ancient World

What number will the following query display? SELECT SUM(stocklevel) FROM books WHERE fiction = False;

• 33

• 858

• 25

• 13

Is the 'title' field useable as a primary key?

• No

• Yes