MySQL: Group timeseries conditionally
I'm trying to bring a time series sum grouped by date, week or month, depending on the total number of dates. For instance, if there is up to 30 days, group the sum by date, if there is between 31…
Mysql – Understanding a weird SQL clause
While learning some SQL, I stumbled upon this seemingly incorrect clause: SELECT item FROM inventory WHERE 20 => price < 500; The query does not result what was intended and should look like this: SELECT item FROM inventory WHERE price…
Javascript – Conditional Site-loading in React
In my React-Web-App I am facing the problem that the conditional loading isn't working like I want it to. I want the Login page to be the first page a user sees. If the user doesn't have an account, there…
how do you create a randomiser using arrays in javascript?
please help me fix this code. For context, I was trying to create a randomiser that responds with 'yes' or 'no' etc to whatever question the user inputs. The main question is how do I return a random item in…
Javascript – react isLoading state not behaving correctly
I am trying to make a skeleton loading effect when isLoading state is true (its set to true on init), like this => {isLoading ? ( <div className="grid grid-cols-4 gap-3"> {voiceData.voices.map((voice) => ( <Skeleton key={voice.voice_id} className="w-[200px] h-[250px] rounded-md" /> ))}…
create one array from two array with same key but diff value in php
I have two array with same key but diff value example : ( "2"=> 6, "5"=> 1 ), ( "2"=> 1, "5"=> 3 ) I want to create new array with the same key but replace highest value like this…
Javascript – How can I add an array of numbers recursively under the condition that the sum will not be more than 20?
For example, there is an array: [3, 8, 9, 2, 7, 5, 6, 5, 3, 11, 9, 17, 6, 5, 8, 4, 2, 7, 9, 12, 5, 16, 4] Algorithm: let arr = [] 3 + 8 + 9 +…
Get content from json with Php conditionally
I am struggling to get some informations/values from a json using php conditionally. To be more detailed, this is my case: I have a json response that looks like this: { "IsSuccess": true, "ResponseCode": 5000, "ResponseMessage": "OK", "Data": { "result":…
Javascript – PostgreSQL query – find value in ANY clause or return true if list of ANY is empty
In my app I have a list that can be filtered by selecting subcategory badge. User is able to select a badge and show only the items from the particular subcategory. But I would like the app to display all…
how to use a condition without using if statement (normal & shortcut) in JavaScript
I had a problem in 'code wars' website and I couldn't solve this Kata because I can't use if statement or shortcut way, the kata said : you have a function that has two argument and they are two numbers…