I am trying to find a way to calculate the running balance of an account. Below is my schema and the query I tried. CREATE TABLE transactions( id INTEGER NOT NULL PRIMARY KEY ,date DATE NOT NULL ,dr INTEGER NOT…
I have PostgreSQL SQL that should look for a backslash in a column called source_username and if it finds the backslash, it should replace the current value of the source_username column with the same value without the characters before the…
I have a table for blogs in a production site I am developing. The users can post these blogs and filter viewership to targeted audiences based on locations, roles, and groupings of users premade by them. All of these columns…
I have a table representing a card deck with 4 cards that each have a unique ID. Now i want to look for a specific card id in the table and find out which card in the deck it is.…
I have a table with created_at and deleted_at timestamps. I need to know, for each week, how many records existed at any point that week: week records 2022-01 4 2022-02 5 ... ... Essentially, records that were created before the…
I have a pretty big SQL query to get data from multiple database tables. I use the ON condition to check if the guild_ids are always the same and in some cases, he check's for an user_id too. That is…
I need to split one column in two based on some condition. Here is an example of table: id | title ---------- 1 | one 2 | two 3 | three 4 | four So, I'd like to have a…
I have a postgresql table contains a list of email addresses. The table has three columns, Email, EmailServer (e.g., gmail.com, outlook.com, msn.com, and yahoo.com.ca etc.), and Valid (boolean). Now, I want to group those emails by EmailServer and then update…
This is team table : +----+-------+--------+-------+ | id | alias | pwd | score | +----+-------+--------+-------+ | 1 | login | mdp | 5 | | 2 | azert | qsdfgh | 50 | | 3 | test | test…
I want to count certain values in all tables of a schema that contain a column that can contain those values. Was hoping to use a LATERAL join to loop over all tables, but I'm running into issues: select fully_qualified_table_name,…