Question

Given a books table with columns named book_title and year_released, the following SQL statement will select the number of books released each year. SELECT book_title, year_released FROM books GROUP BY year_released;

Answer 1

Question Continuation

True or False?

Answer:

False

Explanation:

Given

Columns: book_title and year_released

SQL statement: SELECT book_title, year_released FROM books GROUP BY year_released

Expected Result: To select the number of books released each year

Although the GROUP BY used in the SQL statement is meant to group rows with same values into summary rows but it's not user properly because the GROUP BY clause, as used here needs the COUNT aggregate functions to group the result-set by one or more columns.