I'm working on an exercise from "Murach's MySQL 3rd Edition" which gives the following prompt: "11. Write a SELECT statement that uses an aggregate window function to calculate a moving average of the sum of invoice totals. Return these columns:…
I've a simple query that is taking way to much time to process, the query is very simple and the WHERE clause has just simple comparators but the query takes between 15 to 20 secs to process in a 256gb…
I'm trying to use a case function with a window function, but the data I'm getting doesn't add up. Everything seems to work, but I'm only receiving "Above Average" for that entire CASE function, so I know something isn't quite…
I'm using an ORM to access my SQL database from my Node JS application, and was wondering what the industry standard best practices are to perform SQL operations (some of which might be too advanced for the ORM.) Scenario 1…
I have a user table as follow: CREATE TABLE `user` ( `Id` bigint NOT NULL AUTO_INCREMENT, `FirstName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL -- more column ); Now when I run the following procedure: CREATE PROCEDURE myProc ()…
PostgreSQL version: PostgreSQL 14.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit I'm trying to create a stored procedure which accepts two arguments (a and b is for the sake of simplicity, their actual names are _service_id and…
Can anyone please help me with an SQL query which will allow me to populate the real_name column in table 1 with values from both first_name and second_name columns in table 2 by referencing the usernames. TABLE 1 audit_username real_name…
I have no idea why I am having such trouble with this but I can't get this to work properly. I am trying to create a stored procedure that updates a booking datetime for a bookingid of my choice. I…
I am trying to create a pivot table in Postgres from the following table named product_info: CREATE TABLE product_info ( ID varchar(10), date VARCHAR(20) NOT NULL, product VARCHAR(20) NOT NULL, product_cost integer ); INSERT INTO product_info(ID, date, product, product_cost) VALUES…
I'm learning SQL, and I've just learned about inner joins. The thing is, I'd been taught some other way to join tables before, and I don't understand the difference For example, the way I already knew: SELECT E.SALARY FROM EMPLOYEES…