Using the BOOKSTORE database, write a query to determine the total number of books each publisher has published that the bookstore stocks. For example, Cavill Press has published one book. Enter the number for the following branches:

Storm Pty Ltd:

Publishing House:

Rooster House:

James Bond:

What does the subquery in this SQL statement do$?$

Group of answer choices

It calculates the total salary of all employees and returns this value to the main query.

It updates the salaries of employees to the average salary of all employees.

It lists the names of all employees whose salaries are above the average salary.

It selects the average salary of all employees and returns this single value to the outer query.