I have a query (PostgreSQL 15.4) like this: Select p."prodId", p."prodDesc", p."areaName", x."location1" as "Location" From ops."Products" p Inner Join ops."Locations" x on p."prodId" = x."prodId" and p."areaName" = x."areaName1" Here's the caveat: in the table Locations, there are three…
I am using pyspark to join two tables with 100k rows for each (so not skewed join). It takes longer than 30mins even an hour which I think something is wrong here. The code is just regular join a =…
I have 3 tables. country, team, player table Country id name 1 x 2 x 3 x table Team id name country_id 1 x 1 2 x 1 3 x 1 table Player id name country_id team_id 1 x 1…
Cost per box is in the table named products whereas no of boxes is in sales table. PID is common in both tables both are in same schema and database. I want total cost of boxes per PID shown against…
I want to join two tables to get the output as shown in Table4. Below are the details: Table1: SalesData Date PlatformId UnitsSold Revenue ChannelId 2024-07-01 ABCD1 12 1200 1 2024-07-02 ABCD1 11 1000 1 2024-07-01 ABCD2 4 1200 2…
I have two tables I want to compare data from. The query of the first table is below and it gives me 12 rows. ***** 1st Query ************ SELECT distinct a.pnr AS PNR, a.station_code as Station,a.date as Date, sum(a.allamount) as…
I'm studying Employees Sample Database which has the following table. create table dept_emp ( emp_no int not null, dept_no char(4) not null, from_date date not null, to_date date not null, primary key (emp_no, dept_no), constraint dept_emp_ibfk_1 foreign key (emp_no) references…
I have three tables: conversations, user_messages and system_messages. Their basic structure (irrelevant columns removed for brevity) is: create table conversations(id int generated by default as identity primary key); create table user_messages( id int generated by default as identity primary key…
I need to adjust the following select statement to effectively filter out 523 records where 'first_date_purchased' is less than 'first_date_watched'. The following select statement returns 20778 records, of which 20255 should remain. SELECT se.student_id, si.date_registered, MIN(se.date_watched) AS first_date_watched, MIN(sp.date_purchased) AS…
to be more specific, I have a table with a list of symptoms and a table with a list of diseases. I have also created a table to link a specific symptom to a specific disease. What I'm looking to…