contestada

1. List the book title and retail price for all books with a retail price lower than the average retail price of all books sold by JustLee Books. 2. Determine which books cost less than the average

Respuesta :

fichoh

The SQL syntax which retrieves the book title and retail price for books lesser than the average price of all books by just Lee. The SQL command is written thus ;

SELECT title, retail

FROM books

WHERE retail <

(SELECT AVG(retail)

FROM books);

  • The first line lists the columns to be used to form the new table.
  • books is the name of the table to be looked into (line 2)
  • Line 3 is the condition, which is rows where retail price lesser than the average retail price.
  • Line 4 uses the AVG command to obtain the average of the retail cost of all books.

Hence, the SQL command will display all columns where retail price is below the average price of books with only the book title and retail price column included.

Learn more :https://brainly.com/question/25655426

Otras preguntas