SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table sku (`sku` int, `date` date, `quantity` int); insert into sku values (111, '2021-11-18', 0), (123, '2021-11-18', 0), (146, '2021-11-18', 0), (111, '2021-11-19', 5), (123, '2021-11-19', 4), (146, '2021-11-19', 0), (111, '2021-11-20', 3), (123, '2021-11-20', 4), (146, '2021-11-20', 0), (111, '2021-11-21', 3), (123, '2021-11-21', 0), (146, '2021-11-21', 0), (111, '2021-11-22', 2), (123, '2021-11-22', 0), (146, '2021-11-22', 0), (111, '2021-11-23', 0), (123, '2021-11-23', 0), (146, '2021-11-23', 2); select sku, DATEDIFF(CURRENT_DATE, max(if(quantity > 0, `date`, ''))) days_without_stock from sku group by sku having days_without_stock > 0
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear