How to use HAVING Clause

Copper Contributor

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 

1 Reply
Please post table design as DDL, some sample data as DML statement and the expected result.