Is there a way to join 2 tables with one query to DB in a way when records from one table are put as an array value in a 'new' column in another table? (It's clear how to do it…
I have a MySQL query which should count the amount of replies to your comments with relations to other columns. I try to "relate" two columns together but can't figure out how to create a correct query. The table somewhat…
I have three tables that describe data where there are some main things. Each thing can have several categories below it, and each category can have multiple segments. main main_id main_name 1 bla 2 blub categories cat_id main_id category_name 4…
I have 3 tables dogs, breeds and entries. I need to get AVG(score) from entries, Name from dogs and name from breeds. I have managed to connect 2 tables together and I'm struggle to get the last thing (breeds.name) attached…
How can I display those records / customers details who stayed more then 2 days in hotel? Table Rooms contains arrival and check out dates Table Customer contains customer details. Both are connected via a primary key that is the…
I am having below tables and want to populate the PAYID from the PAY table by looking in to CATEGORY_ID for below use case if PAYID is mapped with CATEGORY_ID then return the PAYID if PAYID is not mapped to…
I have a table in postgresql table which contains IN / OUT timestamp of several employees. I want to derive a table with IN and OUT timestamp of the day for each employee in same rows with null value if…
I have table2 contains around 26 columns & 2mln rows. a b c d e f g h i j k l m n o p q r s t u v w x y z 18 2 2 22…
I'm working on for presence control. The check-in and check-out are 2 difference records in a table It is possible that somebody does not check-out for several days, but should count as present for the particular day person ID -…
im trying to display all the items sold and not sold within a period of time im unable to display on the join tables all the items that have previously arrived if there were none sold. select arrivals.description, COALESCE(sum(orders.quantity ),…