The loyalty team wants to identify highly engaged customers…
The loyalty team wants to identify highly engaged customers — specifically those who have purchased products from 3 or more different product categories. Write a query showing:customer_name, membership_level, categories_purchased Only include customers who have purchased from 3 or more distinct categories.Sorted by categories_purchased descending, then customer_name ascending. Tables: customers, purchases, products
Read DetailsThe HR team wants a complete list of all departments, includ…
The HR team wants a complete list of all departments, including any that currently have no employees assigned — to flag understaffed areas for hiring planning. Write a query displaying all departments and their employee information (if any): department_name, location, annual_budget, first_name, last_name, job_title Include ALL departments, even those with no employees. Sorted by department_name ascending. Tables: employees, department
Read DetailsManagement wants to review products from international suppl…
Management wants to review products from international suppliers (not from USA) that are priced under $100 that are in the ‘Games’ or ‘Accessories’ categories. Write the query to show product and supplier details. Display: product_name, category, unit_price, supplier_name, country (sorted by country ascending, unit_price descending) Tables: products, suppliers
Read DetailsManagement wants a category-level sales summary. Write a que…
Management wants a category-level sales summary. Write a query showing for each product category:category, total_products_sold, total_revenue, avg_purchase_amount, highest_purchase total_products_sold = total quantity sold across all purchases total_revenue = sum of all purchase amounts avg_purchase_amount = average purchase amount highest_purchase = the single largest purchase amount in that category Sorted by total_revenue descending. Table: products, purchases
Read Details