I have a field in my table as shown below. I want to create a bar chart for all choices by counting the ratings of each activity. I.e a very useful count for a newsletter, weekly tips, and other activities…
i a have postgresql query that gets results like this: id | arrayElements 0 | [0, 2, 1] 1 | [0, 3] 2 | [1] In the above example the values inside arrayElements means something. I want to split this…
I have this existing query: SELECT to_json(table1) FROM table1 To return all of table in a nice json format. I need to add a join to this query, so my new query looks something like this: SELECT (field1, field2, table2field1)…
I have two models User and Subscription as follows class User < ApplicationRecord has_many :subscriptions end class Subscription < ApplicationRecord belongs_to :user # attributes # name string # premium boolean # ... end Users will be having many subscription. How…
I am lost in trying to filter data from a table containing BOOLEAN columns, where the filtering conditions apply some further consideration on one of the BOOLEAN columns. I explain my question with example below, reproduced in this db-fiddle. CREATE…
I have a planning table like this: ID EmployeeID ExternalID JobID abc 1 null a def 1 null b ghi null 2 a jkl null 2 f mno 5 null d I want to filter the rows by using an…
I have a postgres table 'games' containing different scores for a game. I want to query all the games and have the average score of all the scores for that specific game. I tried a lot of different queries but…
I have the following table in my database: firstName lastName Kalinda Hemms Karolyn Greenwood Aaron Walework Michel Jurka Now I want to create a query with multiple strings that should return only the records with that string. For example, searching…
I was trying to replace my video link in my wordpress site to another subdomain, I have got a small issue with attached video files. Under meta_value: old link: https://example.com/wp-content/uplaods/2022/09/file.mp4 new link: https://newlink.com/my_files/myvids/2022/09/file.mp4 When I run this code: UPDATE wp_postmeta…
Given the table below, I wonder if it's possible to create a single query (for performance reasons) that provides the result I am looking for. Here is an example of such table: id score cond timestamp item-1 37.5 true ...…