I have two tables table 1 and table 2 linked with a relationship id say customers and orders. I need to count all records from customers and all records in orders and only records from the orders table having order prices above 100, above 300, and 500. how can I write this query, showing count for 100, 300, and 500 respectively
