What type of functions can you use with GROUP BY and HAVING clauses ?

What is sql join ? How is it useful ?

Table BOOK_INFORMATION

Which SQL statement allows you to find the highest price from the table BOOK_INFORMATION?

1. SELECT BOOK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION;
2. SELECT MAX(PRICE) FROM BOOK_INFORMATION;
3. SELECT MAXIMUM(PRICE) FROM BOOK_INFORMATION;
4. SELECT PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;

Table SALES

Which SQL statement lets you find the sales amount for each store?

1. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES;
2. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ORDER BY STORE_ID;
3. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;
4. SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID;