Hi guys, I have these tables: Products: id (PK) name deleted_at Orders: id (PK) sale_date (DATE) ProductOrders: order_id (FK) product_id...
Month: June 2022
Hi guys, I have these tables: Products: id (PK) name deleted_at Orders: id (PK) sale_date (DATE) ProductOrders: order_id (FK) product_id...
Hi, I got a date column that is datetime and contains data from 2019 until today Im trying to create...
Hi, I got a date column that is datetime and contains data from 2019 until today Im trying to create...
I'm super new to SQL and am struggling to figure out what is wrong with my constraints. The tables will...
I'm super new to SQL and am struggling to figure out what is wrong with my constraints. The tables will...
From the table below I want to return the productIDs of only the unique rows (unique = Supplier+Name+Price). How could...
From the table below I want to return the productIDs of only the unique rows (unique = Supplier+Name+Price). How could...
I mean i learned sql at university but wince then a lot have passed and now im almost 5 years...
I mean i learned sql at university but wince then a lot have passed and now im almost 5 years...