SELECT AUTHOR_FIRST_NAME, AUTHOR_LAST_NAME, TITLE  FROM BOOKS WHERE RATING > 4 AND (TITLE LIKE '%STORIES%' OR TITLE LIKE '%TALES%')
2

 7
SELECT b.BOOK_ID, b.TITLE, b.AUTHOR_LAST_NAME, t.TRANSACTION_DATE FROM BOOKS b INNER JOIN TRANSACTIONS t on t.BOOK_ID = b.BOOK_ID

SELECT 'Knygos"' || TITLE || '" autorius yra' || AUTHOR_FIRST_NAME || ' ' || AUTHOR_LAST_NAME as 'Informacija' FROM BOOKS
5


SELECT TRANSACTION_ID, TRANSACTION_DATE, CASE WHEN  TRANSACTION_TYPE=1 THEN 'Knyga paimta' ELSE WHEN TRANSACTION_TYPE=2 THEN 'Knyga grazinta' ELSE 'Knyga nurasyta' FROM TRANSACTIONS
4

SELECT * FROM TRANSACTIONS WHERE TRANSACTION_DATE LIKE '%18' AND TRANSACTION_TYPE = 1
3

SELECT * FROM BOOKS ORDER BY TITLE
1