I'm trying to come up with a query that will pull the total quantity of an item from its first ever order. I understand how to pull out each item and their first order number was, but I'm trying to…
I have a table invitations keeping for each user the email invitations he received. One user can have many emails, on each email can be received many invitations. create table invitation ( user_id INT NOT NULL, email VARCHAR(32) NOT NULL…
I'm using postgresSQL and would like to find the minimum value and the maximum value in one column. I have to have a column titled Order ID, Minimum Order, Maximum Order in the query. See the below code for what…
I have a PostgreSQL table: create table test(type_id, m_id)as values (1, 123) ,(2, 456) ,(3, 123) ,(4, 123) ,(2, 456) ,(1, 789) ; Basically, one m_id could have multiple rows in this table associated with different type_ids. How can I…
I have following 2 tables: Sales and Menu. SALES TABLE customer_id product_id A 1 A 2 A 2 A 3 A 3 A 3 B 1 B 1 B 3 B 3 B 2 B 2 C 3 C 3…
I have a PostgreSQL query that aggregates data from multiple tables and generates a report. Currently it works perfectly fine and it is quite simple. Here is the query I'm using: SELECT a.name AS account_name, c.name AS campaign_name, ad.name AS…
I have a table for recording the mark a student got in a subject on a particular date. The table, perf, has columns id,date,student,subject,mark. Objective: I want to compare the mark obtained by a student against the highest, the lowest…
Imagine you have the following table named city: market product cost A 1 54 A 2 62 A 3 38 B 1 12 B 2 12 B 3 5 I need the most expensive product for each market, i.e.: market…
Have the following messages table: ID OWNER TO MESSAGE DATE 1 y x Hello 1 2 y x World 2 3 z x Postgres 3 And users table: ID USERNAME x x y y z z Need to get data…
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…