I have tables like this: Table_0 CustomerID Trans_date C001 01-sep-22 C001 04-sep-22 C001 14-sep-22 C002 03-sep-22 C002 01-sep-22 Table_1 CustomerID Trans_date C002 18-sep-22 C002 20-sep-22 C003 02-sep-22 C003 28-sep-22 Table_2 CustomerID Trans_date C004 08-sep-22 C004 18-sep-22 C004 20-sep-22 C005 18-sep-22…
I have this SQL query: SELECT users.id, users.name, users.avatar, MAX(messages.created_at) max_created_at, MAX(messages.body) FILTER (WHERE messages.created_at = MAX(messages.created_at)) last_message, CASE WHEN(COUNT(messages.is_read) FILTER (WHERE is_read = false AND messages.from_id != 14) = 0) THEN true ELSE false END is_read, COUNT(messages.is_read) FILTER (WHERE…
I need to create a single table with same column metrics aggregated for different time periods in Redshift SQL. Instead of repeating the code so many times with varying "WHERE" clause, is there a way I can reuse the code…
I have 3 tables: companies (id, name) union_products (id, name) products (id, company_id, union_product_id, price_per_one_product) I need to get all companies which have products with union_product_id in (1,2) and total price of products (per company) is less than 100. What…
I have a table called Sets for LEGO: set_number (Primary Key) set_name other_fields 123 Firetruck abc 234 Star Wars abc I have another table called Parts for LEGO: part_number (Primary Key) name set_number (references set_number from Sets) 1 Truck Roof…
Let's assume I have four fields A,B,C,D I need SQL query to show results only when two or more fields are not null
I am able to import other packages like java.io to eclipse but, I am unable to import java.sql to my project in eclipse. What could be the reason? I don't know how to proceed. I have tried a couple of…
Let's say I have the following tables: create table user ( id int ); create table transaction ( user_id int, date timestamp, amount int ); I have an array of 100 users (result from another query). I'd like to get…
I need to select from a table (user_id, i_id) only those values that match both user_ids. Table structure: user_id i_id 713870562 2 713870562 3 713870562 4 713870562 5 713870562 6 713870562 7 713870562 8 713870562 9 22131245 6 22131245 7…
Currently I'm studying and I received task to write query (join 4 tables: people, goods, orders and order details). So main table Order_details has two columns: Order_id and Good_id, in order to make possible to have many goods in one…