So I'm asked to do this query for a college project: SELECT l.city AS name, AVG((pr.ap_price::double precision * 7 - pr.weekly::doub
Suppose I have column with strings with digits and non-digits. For example 1a2b~#3c. How can I find sum of the digits in these strings. I can't use CTE and my q
Preface: this isn't homework - I am learning SQL. I was given the problem to make a multiplication chart. Here's my solution: create table x (x int) create tabl
as you can see in my picture i have got an eer-model with 6 tables. Now I want from the table "catalog" the "ItemID", from "Users" the "UserID" and from "Roles
Select firstname as name, time as asof, salary as bal into temp employee from people.person p where p.id =1; Need to create a temporary table employee by inser
Recently, while working in SQL Server, I got an interesting thing that removing DISTINCT keyword actually decreased my query performance and increased my search
I do have two table. I want to find customers who never order product p1 and p2 together(there are million rows in this table) customer_id 2,4,1,4,2,1,3,2,1
I have a column called “Month Year Raw” that has multiple nvarchar type data like this: 202201 and I want to convert that to a column called “
There are two columns in a MySQL table: SUBJECT and YEAR. I want to generate an alphanumeric unique number which holds the concatenated data from SUBJECT and
I have a table with one row and clob as column (whose size is 5239). This column contains a table script extracted with the help of dbms_metadata.get_ddl. Along
I have to allow my users to make an update with 24 hours of delay from their previous update, so because date operations in this case are going to be on the bac
Needing to know if this is possible. I'm trying to get a hierarchical output looking like this: TITLE|CHART|FUND|ORGN|PROGRAM S |S |null|null| S |S
I have this table which is loaded with data from the database and what the user has to do is select the one they want and fill in the data from both the select
I have eight columns in a table(birth_Record) of a hospital record. The record is considered duplicate if the below three columns are the same DATE_AND_TIME
I wish to extract a few Calender Weeks from an yearly data. Once that's done, I want to pivot it, so that there is one row for each ID. We have a table DB.MY_CW
So I have a SQL column that stores data like this. "[1338,0,8523]" I was wondering if I can then garb each one individually and because the value is minutes, i
We have setup database postgresql 11 on a system. There are about 8 tables. From few days, we are facing this problem ERROR: invalid page in block 9698 of rela
In my table I have data from employee contracts like this: And I want to get job position in time periods, something like this login ValidFrom ValidTo JobPosi
I have tables in Azure Databricks that I am using SQL to interact with via a notebook. I need to select all columns from a table with 200 columns, I need to sel
So i want to make a delete button, so the user could delete those data according to the data they choose to see. Each time the data on the sqflite were added th