OneCompiler

Write an sql query in to get the same day entries count

300

//fetch datas on the same day

CREATE TABLE orders (
order_id INT PRIMARY KEY,
customer_id INT,
dates varchar(15)
);

INSERT INTO orders (order_id, customer_id, dates) VALUES
(1, 101, '10/11/2023'),
(2, 102, '11/12/2023'),
(3, 101, '11/05/2023'),
(4, 103, '10/11/2023');

"select count(order_id),substring(dates,1,2) as datesss from orders group by substring(dates,1,2) having count(order_id) > 1";