Create your own
teaching resources

Sign up for a free account to try! It takes less than 20 seconds

Teacherbot 09 Jan, 21:16:29
  1. Write a query to find the count of distinct cities in a table of customers.

  2. Find customers whose first names start with A and come from a particular city.

  3. Create a query to find the most common city for customers.

  4. Write a query to list the customers from a particular country that have not yet placed any orders.

  5. Create a query to find the customers with the most orders in a specified month.

  6. Calculate the total cost for all orders placed by a particular customer.

  7. Create a query to find the average number of orders placed by customers in a particular city.

  8. Write a query to list the customers whose payments have been rejected in the past month.

  9. Create a query to find the total number of orders placed by customers in a particular region.

  10. Write a query to find the average order value from customers who have placed more than three orders.