I have the following selection: SELECT posm.id AS org_scope_metric_id, cc.code AS control_code, ccp.code AS part_code, pop.id AS program_id FROM public.org_scope_metric posm JOIN public.org_metric pom ON pom.id = posm.metric_id JOIN compliance.metric cm ON cm.id = pom.metric_id JOIN compliance.control_part_metric ccpm ON ccpm.metric_id…
Given the two tables a and b, I want to execute a query on a which gives the rows that have at least one row in b with b.a_id = a.id and flag=1 and at least one row with b.a_id…
I want to group all entries in my table by their user_type property. However the user_type entries exist in a {type of user} {date account was created} format, e.g. id | user_type -------------- 01 | 'admin 2024-03-01' 02 | 'admin…
I have a table like this: CREATE TABLE "users" ( id serial PRIMARY KEY, town text NOT NULL, street text not null, building text ); I want to be able to store unique entries by 3 columns "town", "street" and…
I have two MySQL tables and want to join it correctly by one sql query. Table "users" id email 1 [email protected] 2 [email protected] 3 [email protected] 4 [email protected] 5 [email protected] Table "group_user" user_id group_id 1 1 2 1 2 5 2…
My table has some null and empty strings, these look ugly when I query the table so I want to replace them with other values. I don't own the data so I can't modify the table itself, this needs to…
I have such an example of tables: table1: col 1 col2 col3 col4 1 a x1 asdc 2 b x2 czxa 3 c x3 xfsdaa table2: col2 col3 l x56 q x99 All I want is to receive such a…
I need to find supersets within an association table. You can consider bag to be a collection of item records. The relationship between the two is tracked in bag_item. I need to know which bags are supersets of other bags:…
SELECT DISTINCT info_person.userUsername, infoExamResult.resultPoint, infoExamResult.resultPercentage, infoExamResult.optAnswer FROM info_person INNER JOIN infoExamResult ON infoExamResult.personID = info_person.personID where infoExamResult.datetimeStart BETWEEN "2024-03-18" AND "2024-03-26" and infoExamResult.optAnswer = "COMMIT" ORDER BY info_person.userUsername Outcome which resultPoint are Score and resultPercentage are Percent of max score…
I need to filter row that contain a column with a, b, c against a query with a, b, c, d. I mean if all the element of the column are content in the query then it's OK. What is…