coach | Alternative controllers with middleware | Application Framework library

So i created a mobile app that mobile app hooks into this web api hosted on a server but I was just thinking how I did the startup class and in their I have a load of services I am calling in the web api.

Is Using Add Scope bad in this if multiple users will start hitting the system.

I have a long list of roles obtained from a sheet range stored as strings in an array, to give an example the array looks something like this:

Example file: https://docs.google.com/spreadsheets/d/1M-o8Mu3vBrBgs1wC1WL5kqK61m6Vu1K5ylGByKDCZTo/edit?usp=sharing

On the sheet "To be coached" I have a query in cell A2. The query might not be optimal and maybe it's convoluted, but it works, aside from one small detail that I just can't get to work. This is the current query.

I have a model called Athlete that has a OneToOne relation to the User model which is an AbstractUser, I'm trying to create a user whenever I create an Athlete and automatically tie them together but I'm getting an error:

Hello my professionals I have a simple question here that I would like to beg to solve this..

this is an Entity of Member

this is my first question here so, please ask if you need more information. I am working on a personal project. I have a relatively complex relational database structure. I create schema.sql on my spring boot project as well as data.sql with sample data. I try to create a web application for simulated fitness centre web pages. I try to display the location name and number of visits for the user. I create a userLocation bean for keeping the result set as a list of the select query. I can test the statement on H2 database and its work. However, on my code, I cannot get the number of visits from the select statement.

Here is my userlocation bean,

I am a coach and have a google sheet that tracks their fitness with a numeric score, higher being better. Each score has paces assigned to it for easier runs and harder runs. Currently I have a sheet that is a table of the scores with the prescribed paces, and to simplify the matter, I made the score the same as the row number. I then have another sheet with the athlete names and their score.

I would like to populate that athlete sheet with their paces as well. I know how to do this manually (like ='Score/Paces'!B50), but I would like it to automate this process. Let's say an athlete has a score of 50, stored in cell C2. Then:

Instead of this: ='Score/Paces'!B50

it's something like this: ='Score/Paces'!B(C2)

This way, whatever the score is automatically changes the paces for the athlete and I won't have to copy and paste every time.

Here is a link to the example I made. I filled the cells with things I've tried. https://docs.google.com/spreadsheets/d/1FXI_RIevvkuUOkNwBPK4l-oblIZcYm9Fw459KIvq5Jw/edit?usp=sharing

Thanks!

I have a table of Incidents ( See array below) and im trying to sort them by State in the order of Initial > Ongoing > InReview > Resolved. Then within the organised State, I want to sort them by Priority so P1>P2>P3 and then organise the priority by Start_date so that the oldest is on the top.

I cant seem to find any example of such granularity of sorting online. Would anyone know how I would go about this?

Here is my array:

This is the Controller code: