Hi I am working in Postgres. I have below code DO $$ DECLARE item integer; begin item:=5; DROP TABLE IF EXISTS temp_data; CREATE temp TABLE temp_data AS select current_timestamp + interval '1 day' as op; END $$; select * from…
We have Employee ID in over 50 different tables with various data types (varchar, int, text). When these tables were populated via conversion, they should have been populated with 6 numbers. Unfortunately, some of the IDs had dropped leading zeros…
I wand to select record from one table and insert into other . Here is my table 1 create table temp ( seq varchar(20), prefix varchar(20) ); insert into temp values ('AAA','A'); // counter should be 1 as combo of…
Write a SELECT statement that answers this question: What is the total quantity purchased for each product within each category? Return these columns: The category_name column from the category table The product_name column from the products table The total quantity…
I have a subscription table with 4 fields: id, customer_id, start_date and end_date. It lists all subscriptions of my customers. No subscription has an empty end_date, and a customer can have several subscriptions at once. For example, a customer id…
I am developing a game like app with an leaderboard and want the leaderboard to have this features: Show Top 100 Show Top 100 Monthly, Weekly, Daily Show Trends next to every User (if the user moved up on the…
so I have two tables as shown TABLE A CrimeType CrimeSubType Neighborhood Year 1 1 Jeff Park 2024 2 2 Cong Park 2023 2 2 Cong Park 2024 2 2 Jeff Park 2024 3 1 Jeff Park 2024 3 2…
I'm trying to create 3 arrays, iterate through each, and insert records depending on the value of those iterations. My code is as follows: do $$ declare days integer[]; times time[]; durations integer[]; begin days := array[1,2, 3, 4, 5,…
In MySQL Regular Expression pattern matching function, there is a 'match_type' - 'n'. Which represents, The . character matches line terminators. The default is for . matching to stop at the end of a line. Could someone explain me how…
I have a request to add new column that will count distinct column named kode_buatan from january to the month in the record (so if the record have date in march 2024 count distinct kode buatan from january 2024 to…