4 views
23 Jan 2026
List employee pairs in the same department who have exactly the same salary (show both emp names)....
5 views
23 Jan 2026
List employee name with department name....
2 views
23 Jan 2026
List all customers and their latest order_id if any. Customers without orders should still show....
2 views
23 Jan 2026
Show order_id, customer name, and total_amount....
2 views
23 Jan 2026
Employees(emp_id, name, manager_id). Show employee name and manager name....
2 views
23 Jan 2026
Create all combinations of Sizes(s) and Colors(c) to generate SKU options....
3 views
23 Jan 2026
Find products that never appear in OrderItems....
2 views
23 Jan 2026
For each customer, show total paid amount in the last 30 days. Join Orders with Payments and group by customer....
3 views
23 Jan 2026
You have table A_ids(id) and B_ids(id). Show ids that are missing on either side....
2 views
23 Jan 2026
Students and Courses are many-to-many via Enrollment. Show student_name and course_name....
2 views
23 Jan 2026
For each customer, show details of their latest order (not just id)....
2 views
23 Jan 2026
Orders, OrderItems, Products. Show category-wise revenue for shipped orders only....
7 views
23 Jan 2026
Customers who have at least one purchase in each product category....
3 views
23 Jan 2026
Shifts(emp_id, start_time, end_time). Find employees whose shifts overlap on same day....
3 views
23 Jan 2026
Customers(city), Orders, OrderItems. For each city, find top 2 products by quantity sold....
