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 need some help here, my request is : List the bookID and number of copy of this in Library (Number of copy in library = number of copy – number of copy student borrow but not return yet) and…
I'm trying to get summary data from a table (dd=devicedata) that gets data every 10 minutes. I want to get the data for one day (24 hours), i.e. get the summary of 144 rows into one. devicesData is indexed on…
Joining 2 tables (orders, addresses) Orders contains columns delivery_address_id (contains NULL values) and invoice_address_id (does NOT contain NULL values) Addresses contains id column (does NOT contain NULL values) Primarily, the LEFT JOIN must be performed on orders.delivery_address_id. However, in the…
I am trying to combine two select statements because my original query was taking way to long with LEFT JOIN Original Query: SELECT DISTINCT a.RequestId, a.*, str_to_date(RequestedTestDate, '%d-%b-%Y') AS cRequestedTestDate, str_to_date(ActualTestDate, '%d-%b-%Y') AS cActualTestDate, name as Engineer, Cancelled FROM (…
I have two tables with one referencing the other. CREATE TABLE blogs ( article LONGTEXT, id VARCHAR(255) PRIMARY KEY ); CREATE TABLE blog_eval ( blog_id VARCHAR(255) REFERENCES blogs(id) ON DELETE CASCADE, user_id VARCHAR(255) REFERENCES users(id), is_like BOOLEAN, --true if like…
Here is the issue to solve. I have a table USERS and a table GROUP_USER. I am updating table USERS and the data I update in that table will directly affect the GROUP_USER table. Here are the tables **Users table**…
How is it possible to show all orders which are not completely paid off related to a client? for e.g. SHOW ALL order details of ‘unpaid’ ORDERS for CLIENT ‘50’ table: orders id order_total client_id 1 15.00 50 2 18.50…
Product prod_id prod_name 10 Orange 11 Apple 12 Carrot 13 Lettuce Category cat_id cat_name 20 Fruit 21 Vegetable Item item_id property_type property_value 30 fk_prod_id 10 30 fk_cat_id 20 31 fk_prod_id 11 31 fk_cat_id 20 32 fk_prod_id 12 32 fk_cat_id 21…
I'm trying to show a table with information gathered from 4 different tables. orden_trabajo_pk concepto descripcion importe ing_responsable_id 159460 concept example1 description 18000 1 159461 concept example2 description 8000 1 cotizacion_pk concepto descripcion importe orden_trabajo_id 2010633 concept example1 description 20000…