I'm trying to filter products by their attributes that are in the linking table Product => product_has_attribute => Attribute I was only able to do OR, but I need to make a more precise filter. Thanks for any hint! ps:…
I have a table like below. For a given id & a_id there could be different combinations of b_type, e_id, sp_id. br_type can be either B or H. b_type values EA means Excluded Party A, EB means Excluded Party B,…
I get this error: ERROR: 42601: syntax error at or near "ON" LINE 23: ce.image from cars_images ce ON (c.id = ce.car_id)) as images here is my code: SELECT c.id, c.model, c.description, c.environment, c.equipment, c.ps, c.tuv, c.cover, c.brand, c.price, c.engine,…
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…
SELECT obo.id, obo.ready_notified, obo.view_notified, obo.order_name, CONVERT_TZ(obo.submitted_at, 'GMT', 'America/New_York') AS submitted_at, obo.order_counter, obo.is_pos, obo.occasion, obo.dine_in_table_number, obo.cashier_id, obo.terminal_name, obo.terminal_id, obo.payment_type, obo.total, obo.is_paid_by_split, obo.payment_type_raw, obo.is_submitted, obo.is_cancelled, obo.is_split_cancelled,obo.has_refund, obo.has_adjustment, obo.adjusted_total, obo.tip, obo.refund_total, obo.refund_pending, obo.order_hash, GROUP_CONCAT(oth.transaction_id) AS transaction_id FROM order_botorder obo LEFT JOIN order_ordertransactionhistory AS…
Input table has following data: +--------+-----+ | Id | set | +--------+-----+ | ABC123 | 1 | | ABC123 | 0 | | ABC123 | 1 | | XYZ123 | 0 | | XYZ123 | 0 | | XYZ123 |…
I am using mysql workbench 8.0 I am teaching myself SQL and am currently starting on some guided projects with a LOT of googling. Right now I am working with this data: Here's the relevant section I am working with:…
Consider the following table: Table Name: IN_OUT_RECORD Query: select DISTINCT * from IN_OUT_RECORD AD where (AD_USER_ID = 'ST1301220007') AND (AD.AD_DATE BETWEEN '2024-06-01 00:00:00' AND ('2024-06-12 23:59:00')); AD_ID AD_USER_ID AD_STATUS AD_DATE 11277 ST1301220007 IN 2024-06-01 09:10:40 11278 ST1301220007 OUT 2024-06-01 09:10:55…
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 got a simple JavaScript button, and the script working fine. But counter reset everytime i refresh the page. I tried few things but am lost. Can you please help me with sql or something that i could keep likes.…