memberships | manage memberships for your users | Ecommerce library

I am working with data for club memberships.

Here the aim is, for a period between two dates, to calculate the following, in MySQL:

• the number of new members during the period.
• the number of members who cancelled during the period
• the number of members who re-joined during the period

For example, suppose we have the following membership data:

Table Structure First

users table

sites table

site_memberships table

Assuming higher the created_on number, latest the record

Expected Output

Expected output: I need latest record for each user for each site membership.

Tried the following query, but this does not seem to work.

I have the following code to remove a membership from the GroupMemberships DbSet, which is quite straightforward:

EDIT: I have added the primary key, following the comment by @Strawberry

The aim is to return the number of current members, and also the number of past memberships, on any particular date/time.

For example, suppose we have

I am trying to bind an array of objects to a v-select so that when the user selects an option, I have access to multiple data points associated with that option. However, I only want it to show one value in the dropdown itself, which would be the name. If I use itemText to have it displayed correctly in the dropdown, it binds it to that name only and I do not have access to the rest of the info associated with it.

For example, here is my array of objects:

I am trying to sort an array users that have don't have the InvitesApplication.createdAt -> the user that have lastest createdAt in this team.

Here is my code sand box for an example: https://codesandbox.io/s/jovial-pasteur-seusw?file=/src/App.js

Update add code into question:

I am trying to loop through an array of Invitation from a team and a user can have many Invitation. So right now I want to when I clicked invite button, Invitation will be added into user object.

Here is how my project look like:

When I do console.log(user) to get all data from a user, the data looks like this:

I am trying to filter thru an array that show me list of user that don't have a team yet and the other one is they have a team but not the specific team Id that I passed in.

So example when I console.log(invitees):

I am trying to access to an object in side an array of array. Here is how my console.log showing: