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.
reverse engineering, also called backwards engineering or back engineering, is the process by which an artificial object is deconstructed to reveal its designs, architecture, code, or to extract knowledge from the object