20 Must Visit SQL Questions For Interviews
Author(s): Ananya Originally published on Towards AI. Q1. Find the total number of orders placed by a customer (101) in a day. Table: Order_Details cust_id | order_id | order_date Code: select date_trunc(‘day’, order_date) as day, cust_id as customers count(distinct order_id) as orders …