Table has two columns which concatenate as 'ab'. I'd like a count of the unique values from the concatenated columns 'ab', here is what I have so far; initial_db=> SELECT concat(street_num, street_name) AS ab FROM recs limit 5; ab ------------…
I am fairly new to SQL and wondering how to remove a specific element from the JSONB data below: [ {"id":101,"content":"lorem ipsum", "username":"user_1"}, {"id":102,"content":"lorem ipsum", "username":"user_2"}, {"id":103,"content":"lorem ipsum", "username":"user_3"} ] In this case I want to remove the object with…
I've tried using both Python and Postgres to convert a table of data into JSON that can be used to render a nested dropdown in a web UI. Here is how the data is structured: group_desc category_desc subcategory_desc item_desc Group…
I have this part of a class diagram that I want to translate into SQL: Piece of class diagram: My internship supervisor sent me this SQL code: CREATE TABLE `users` ( `Matricule` varchar(50) NOT NULL, `Password` varchar(50) NOT NULL, `Role`…
I am struggling with a problem and I hope someone could help a brother out. I tried INSERT INTO but got an error message: Error Code: 3819. Check constraint 'inventory_chk_1' is violated. To troubleshoot the issue, i want to examine…
I'm trying to make a monthly report with employee attendance case studies. I have 2 tables which are employee and attendance with the following details: employee teble attendance table after that I created SQL view to display the date column…
Describing the scenario I have this table called event defined in PostgresSQL that, among some not relevant ones, basically has 5 columns: id (integer): primary key of the table date (timestamp): date when the event occurred fk_type (integer): foreign key…
I have a column from which I would like to retreive only those values which are only consecutive identical characters like 'ppp' 'mmmm', 'ddddd'. The length of the string will be greater than or equals to 3 I tried different…
I run into this situation from time to time, where I want to take a list of things and see if any of them exist in another list. If you have a single number, it's simple enough to use a…
I will try my best to explain this. Let's say I have a table like this Name Year Present_category Present_count Mother Mary 2023 sweets 3 Linda Mary 2022 sweets 2 Linda Linda 2022 sweets 4 Linda 2021 sweets 1 Linda…