I have data that looks as follows. timestamp productid measure 2022-01-01 00:00:00 1 4 2022-01-01 00:01:00 1 5 2022-01-01 00:02:00 1 6 2022-01-01 00:01:00 2 5 2022-01-01 00:00:00 2 7 2022-01-01 00:01:00 3 9 The table records the telemetry of…
I'm trying to calculate regular an overtime hours for an employee that works 2 jobs at the same company. The reason it needs to be done this way, is the hours get billed to separate departments. Overtime begins after the…
I want to create a table for student with the attributes enroll_id and std_name. The enroll_id is Primary Key of the table and the format of enroll_id is year+brach code (CS,EC,MC,CV)+college code (001 to 300)+ entry type(D for lateral entry…
I want to filter out the record with the highest salary for each department. If there are multiple records that meet this condition in a department, keep all of them.Then I write SQL following: SELECT id, name, salary, departmentId FROM…
Table a b aa one aa one bb two bb two cc three select distinct a b aa one bb two cc three What query to write that there are only "three"?
I want to query the jsonb column in the below table, sum all fields named time, and then query for any object '"type": "Unknown" and also have a time that is greater than 10% of the previously calculated sum. CREATE…
The following is valid SQL for PostgreSQL. INSERT INTO schema.table (id, letter) VALUES (1, 'a'), (2, 'b'), ... I would like to execute a similar, parameterized statement using SQLAlchemy. I am using SQLAlchemy 1.4* Connection.execute(), but I do not have…
After defining a table-valued function in mssql select * from funcA() is possible. But mysql seems impossible, is that correct? How can I do it in MYSQL? If this is not possible with a function, is there a similar way?…
I am learning to use groupBy. In my exercise, I must count the number of tickets that were sold and add the total money collected. $tickets = Ingresostaquilla::groupBy('tipo') ->selectRaw('count(*) as quantity, tipo') ->get(); I did the count by type of…
It is hard to explain this in word, so sorry if the title is mismatch. So I have a file text like this: Header A Header B Header C Header D Apple Red A 100 B 200 B 300 Green…