SQL Commands

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;