I have students associated to schools, and want to find all schools that have five or fewer (including zero) students that have has_mohawk = false. Here's an Activerecord query: School.joins(:students) .group(:id) .having("count(students.id) < 5") .where(students: {has_mohawk: true}) This works for…
I made two statements - SUM of revenue and expenses in different tables using group by id (each id has more than one revenue and expenses records): select id_person, SUM (revenue_d) as sum_revenue from sales group by id_person; select id_person,…
I've got the following tables: person (id), person_agency (person_id, agency_id) and agency(id, type) this is my query: select p.id, a.id from person p left join person_agency pa on p.id = pa.person_id left join agency a on pa.agency_id = a.id where…
I want to check if tables table_a and table_b are identical. I thought I could full outer join both tables on all columns and count the number of rows and missing values. However, both tables have many columns and I…
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 am trying to retrieve the 'Roles' sets of a given users.id on a query with INNER JOIN combined with a WHERE condition. But things go wrong. My database has four tables: t_users : id, username, userpass, status, ... t_action:…
With a MongoDB collection name department with the following structure: { "_id":99, "name":"Erick Kalewe", "faculty":"Zazio", "lecturers":[ { "lecturerID":31, "name":"Granny Kinton", "email":"[email protected]", "imparts":[ { "groupID":70, "codCourse":99 } ] }, { "lecturerID":36, "name":"Michale Dahmel", "email":"[email protected]", "imparts":[ { "groupID":100, "codCourse":60 } ] }…
Editing this to reflect addition work: Situation I have 2 pandas dataframes of Twitter search tweets API data in which I have a common data key, author_id. I'm using the join method. Code is: dfTW08 = dfTW07.join(dfTW04uf, on='author_id', how='left', lsuffix='',…
I'm trying to do a lookup from collection1 to collection2 using attachments.collection2_keys (an array), and at the same time filter collection1 where collection2.type is typeA, for any key in attachments.collection2_keys. I believe this query should work, but it returns no…
hello i'm new in stack overflow, codeigniter 4 and dont have enough experience on mysql. I have a problem when i inserted data for the first time the data show on the table like it should be, but when i…