joop questions

joop answers

• Table analysis in SQL (multiplication)
• Postgres - Are views backed by prepared statements?
• LRU cache with a singly linked list
• Average stock history table
• Why does a slight change in the search term slow down the query so much?
• Count total number of duplicate rows in a table
• pg_dump serial datatype issues
• Why does PostgreSQL throw "FULL JOIN is only supported with merge-joinable or hash-joinable join conditions"
• Interview task: check if array consists of pairs in O(n) time and O(1) of additional memory
• Create empty table in postgresql