I have a scenario, where a trigger function is activated before an update of some sort. And in order for the condition to be met one of the columns must be excluded from the "OLD" and "NEW" objects. CREATE FUNCTION…
I have a table as such date, id, value 01/01/2022, 5, 10 05/01/2022, 5, 4 06/01/2022, 5, 10 04/01/2022, 10, 1 09/01/2022, 10, 7 Each id doesn't necessarily have consecutive days of rows starting 01/01/2022. I want to transform my…
I use this method using js on the frontend to get the utc offset in minutes. It gives me a result like -300 for UTC+500 const d = new Date(); let diff = d.getTimezoneOffset(); Now how do I make the…
I have this query that finds the name of the teacher with the 4-th highest salary. I don't understand this part SELECT COUNT (DISTINCT T2.salary) FROM teacher as T2 WHERE T2.salary > T1.salary ) = 3 from SELECT name FROM…
I have a table that stores an id from another table, an index for a specific id and some different value user_id index_value some_value 1 0 01 1 1 02 1 2 03 2 0 04 3 0 05 3…
Column utc time created is a datetime field of when entry was made in a table that's updated hourly. Contains 24 entries for each day. I want to query for same time of day across a set of days (might…
Please do tell me how to get rid of this error Here is my code: %%sql DROP TABLE IF EXISTS ages; CREATE TABLE ages AS SELECT CODEDESC, SUM(age) AS age FROM (SELECT CODEDESC, (CASE WHEN (JULIANDAY(MAX(inspdate))-JULIANDAY(MIN(inspdate)))< 30 THEN 30 ELSE…
I have a table called services with multiple columns and one column named staff_assigned with this content: [{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}] How can I find all services where user_id is 15548 with Laravel eloquent? Note that Service::where('staff_assign->user_id', "15548")->get(); doesn't work because column contains…
I have data with a frequency of one minute for 3 years and I would need to put it in one table to make it comparable. Table1-2019 date_time v_2020 01.01.2019 01:00:00 50 01.01.2019 01:01:00 49 01.01.2019 01:02:00 56 Table2-2020 date_time…
How do I calculate the negative difference between each row and return as a total sum? For example (col "fictional difference" is only for better understanding): id value fictional difference 0 63 0 -> ignrore 1 61 -2 2 55…