Pasted

 
SELECT MAX(BOOK_PRICE) FROM BOOK_INFO;
SELECT MIN(BOOK_PRICE) FROM BOOK_INFO;
SELECT AVG(BOOK_PRICE) FROM BOOK_INFO;
SELECT SUM(BOOK_PRICE) FROM BOOK_INFO;
 
SELECT BOOK_INFO.TITLE, PUBLISHER_INFO.PUBLISHER_NAME FROM BOOK_INFO INNER JOIN PUBLISHER_INFO ON BOOK_INFO.PUBLISHER_ID = PUBLISHER_INFO.PUBLISHER_ID ORDER BY TITLE ASC;
 
SELECT * FROM BOOKS_INFO LEFT OUTER JOIN PUBLISHER_INFO ON BOOK_INFO.PUBLISHER_ID = PUBLISHER_INFO.PUBLISHER_ID ORDER BY TITLE ASC;
 
SELECT LAST_NAME FROM AUTHOR_INFO UNION SELECT TITLE FROM BOOK_INFO;
 
SELECT FIRST_NAME, LAST_NAME FROM AUTHOR_INFO UNION ALL SELECT TITLE, CATEGORY FROM BOOK_INFO;
 
DESCRIBE BOOK_INFO;
 
DESCRIBE AUTHOR_INFO;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '_H%' AND BOOK_PRICE>10.00;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '_H%' AND BOOK_PRICE<10.00;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '%D' AND BOOK_PRICE<9.00;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '_H%' OR BOOK_PRICE<10.00;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '_H%' OR BOOK_PRICE>6.00;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE 'T%';
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '%D';
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE 'W%Y';
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO WHERE TITLE LIKE '_A%';
 
SELECT * FROM BOOK_INFO;
 
SELECT * FROM AUTHOR_INFO;
 
SELECT * FROM PUBLISHER_INFO;
 
SELECT MAX(BOOK_PRICE) FROM BOOK_INFO;
 
SELECT MIN(BOOK_PRICE) FROM BOOK_INFO;
 
SELECT COUNT(BOOK_PRICE) FROM BOOK_INFO;
 
SHOW TABLES;
 
SHOW DATABASES;
 
SELECT * FROM PUBLISHER_INFO;
 
SELECT TITLE, DESCRIPTION FROM BOOK_INFO WHERE CATEGORY = 'SCIENCE';
 
SELECT LAST_NAME FROM AUTHOR_INFO WHERE COUNTRY = 'BRAZIL';
 
SELECT FIRST_NAME FROM AUTHOR_INFO WHERE COUNTRY = 'USA';
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO ORDER BY BOOK-PRICE DESC;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO ORDER BY BOOK_PRICE ASC;
 
SELECT TITLE, BOOK_PRICE FROM BOOK_INFO ORDER BY TITLE ASC;