47SQL.2 - HoloCure Collabs tool, using Postgres and SQL

Опубликовано: 06 Октябрь 2023
на канале: WesleySon
11
0

Part 2 of using SQL to work with Holocure collabs


00:00 Adding rows, with inner query-method
01:51 I don't have to write "public."
03:29 Can't add duplicates
03:59 Add rows, using a temporary table
07:05 Delete ALL rows
08:01 Delete ONE row
09:16 Count of unlocks
09:52 Count remaining collabs
11:17 Get info for remaining collabs
14:19 Group weapons with remaining collabs
15:32 Must specify all column names in the a-table
15:54 "Count"-column is not found within the b-table