Hands-on task
Book catalog: INSERT and SELECT
The library database has an empty table books(id, title, pages). Add three books to it: (1,'Dune',412), (2,'Solaris',204), (3,'Neuromancer',271). Then select the titles of books shorter than 300 pages in alphabetical order and write them to /root/short_books.txt — one title per line, no headers or borders.
- postgresql
- insert
- select
- where
- order by