Jul 29 2021 06:25 AM - edited Jul 29 2021 06:27 AM
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
Jul 29 2021 10:29 PM