uhura | Server-to-server event emitter with session support | Pub Sub library

I have 4 tables: the first is the client table, which has customer info, and client_id as an auto-increment primary key.

The second and third are identical in structure: they are used to track attendance to 2 different therapy programs. They each have a primary key, and a client_id column to track the client. One of the fields contains units, which I want to sum.

The last table contains the therapists' info.

Basically I want to extract total amount of units for each client from the two attendance tables.

I have tried LEFT JOINS to no avail. I also tried a UNION ALL, but couldn't get it to sum the units.

This is how the tables look:

client:

Suppose, we model couples with 2 vertex labels, female and male, and with a single edge label, dates. The direction of the edge is always from female to male.

The expected query result list are couples, where there is a non-directed path from a start vertex to the vertices of each couple, distinct.

In other words the result should contain the edge list of the connected components of the graph, where the given vertex is present.

Please note, that there can be loops if the original graph is converted to a non-directed graph.

Filter criterion: { name: 'Adam' }

Expected result set:

I have these tables in my SQL Server database:

Users:

On my database I have three tables, like so:

users