SELECT title FROM books;

SELECT title, author FROM books;

SELECT * FROM books;

SELECT DISTINCT author FROM books;

SELECT DISTINCT author, genre FROM books;

SELECT DISTINCT author AS unique_author FROM books;

CREATE VIEW library_authors AS SELECT DISTINCT author AS unique_author FROM public.books;

SELECT * FROM library_authors;

SELECT genre FROM public.books LIMIT 10;