We have a column in a PostgreSQL table with the following data: 1A 1ABCD 1B ABCD1 2 ABCD2 3 ABCD3 ABCD4 ABCD5 ABCD10 ABCD11 ABCD1111 A B Expected result after sorting: 1 2 3 1A 1ABCD 1B A B ABCD1…
I have two queries that returns the total number of issuances and redemptions from two different tables. This one returns issuances, around 18k select count(*) from issuances_extended WHERE status = 'completed' This one returns redemptions, around 7k select count(*) from…
I want to UPDATE table row in member_network table using WHERE clause by team_id = 91 and using JOIN. Main table member_network structure look like: | id | network_profile_name | |----------------------------| | 1 | John Doe | I have two…
I have a simple table with a Jsonb array of phone numbers: CREATE TEMP TABLE IF NOT EXISTS user_info ( id serial, phone_numbers jsonb ); INSERT INTO user_info values (1, '["123456"]'),(2, '["564789"]'), (3, '["564747", "545884"]'); SQLFiddle: SQLFiddle Link now, I…
I have a table which looks like this: date user_id active_dt last_active_day 2020-01-01 1 null null 2020-01-02 1 null null 2020-01-03 1 null null 2020-01-04 1 2020-01-05 null 2020-01-05 1 2020-01-08 2020-01-05 (as of 2020-01-05, the last actve date was…
I work on an hotel app, and I am trying to query my sql db for the available rooms between 2 dates. The table rate looks like this: room_id date unavailable price 1 16/08/2022 false 10 1 17/08/2022 null 20…
I am trying to sum a timestamp with a time that I have to cast from varchar to time. This is my attempt: select my_timestamp + cast(my_str_time as time) as my_end_time from my_db.my_table; my_timestamp format (already a timestamp): 2022-07-16 02:51:11…
I want to return defined results from member_network table using WHERE clause by team_id = 91 using JOIN. Main table member_network structure look like: | id | network_profile_name | |----------------------------| | 1 | John Doe | I have two fields…
I have the next Tree Structure : This structure is represented in the database with the next Table: --------------------------------Employees------------------------------------------- ------------------------------------------------------------------------------------- | Employee_name | Global_Team | Team | ------------------------------------------------------------------------------------- |name_of_head_of_engineering | - | Engineering | ------------------------------------------------------------------------------------- |name_1_T1 | Engineering | Team_1…
I have table with jsonb column "Details": {"Type": "VIP", "Quantity": 1} I want update column, using query that copies value from "Type" field to new one "Subscription" and change value "VIP"->2. Exp below: {"Type": 2, "Quantity": 1, "Subscription": "VIP"} I…