2 views
23 Jan 2026
Customers(dob). Return customer_id and age_years as integer (approx)....
2 views
23 Jan 2026
Return customer names trimmed and in uppercase....
2 views
23 Jan 2026
From Orders, return order_id and order_year....
2 views
23 Jan 2026
Show product_id and rounded price....
2 views
23 Jan 2026
Show customer_id and phone, but display 'NA' when phone is null....
2 views
23 Jan 2026
List products where name length is more than 20 characters....
5 views
23 Jan 2026
Show Orders with a formatted date string like YYYY-MM-DD....
2 views
23 Jan 2026
Create spend_bucket as LOW (20000) using CASE on total spend....
2 views
23 Jan 2026
Return top 3 orders by total_amount for each customer....
3 views
23 Jan 2026
For daily sales, show today_sales and change_from_yesterday....
2 views
23 Jan 2026
For Orders sorted by order_date, show running sum of total_amount....
3 views
23 Jan 2026
Find employees whose salary is above the 90th percentile in their department....
3 views
23 Jan 2026
Create a query that removes spaces and lowercases product names for matching a user input....
2 views
23 Jan 2026
In LoginLogs(user_id, logged_at), start a new session if gap > 30 minutes. Assign session_number per user....
4 views
23 Jan 2026
Compute the median of Orders.total_amount....
