Good morning evryone. I am programming with NestJS and Angular. Every time I log in, I access my profile and add experiences. The problem is that I am using guards to secure the add function. However, when I try to…
Summary: I tried to upload a csv file to a database table using the MySQL Workbench import feature, but was unsuccessful. The error log shows an issue with the 'createdAt' column. I am working on a Mac. I'm trying to…
I have 2 different date fields, 1 when the case was created and the other when the case completed. I am trying to count total cases and total completions in say 2023. Whenever I run my query and set the…
So I have already created my database and all the tables with the appropriate columns in Mysql and connected it to springBoot. My issue is that when I create my user class which matches all the right columns on the…
Need a MySQL query to fetch product if provided range of price falls between the min and max price. I have product A and product B. Product A has a min price equal to 3400 and max price equal to…
I have two tables, one has course name and course ID. The second table has the ID of the students and the course ID they have taken. I need to find all the class ID’s of the classes a student…
I have following table: CREATE TABLE mytable ( id int, name varchar(255), data json ); id name data 1 John ["a", "b"] 2 Pete ["a", "b", "c"] 3 Mike ["a", "b"] Where column data has JSON type, and I want…
I have a algorithm that is spitting out a list of scores: list_of_scores = [100, 101, 102, 101, 43, 42, 42, 41, 20, 21, 22, 23] in the above list, there is a 'cluster' of scores around 100, another 'cluster'…
Lets say I have this query: select week(sr.transactionDate) AS week_number, sum(sr.digitalEarnings) from sales_report as sr where `sr`.`transactionDate` BETWEEN '2022-05-01' AND '2022-12-31' group by week_number order by week_number; Which returns data like so: I know this is the "week in the…
I have a table with the following example data: ID Name lat long 1 100 123 -123 2 101 234 -234 4 100-L NULL NULL 5 100-R NULL NULL 6 101-L NULL NULL 7 101-R NULL NULL What I need…