Consider the following relation: Sales(sales_id, salesman, region, sale_amount, sale_date) Write an SQL query to display the region, average sale…
Consider the following relation:
Sales(sales_id, salesman, region, sale_amount, sale_date)
Write an SQL query to display the region, average sale amount, and total number of sales for each region where: The average sale amount exceeds BDT 50,000 and the total number of sales in that region is at least 5.
From the Combined Bank Senior Officer October 2025 – Written exam, question 44 of 50.
More from this paper
- Previous: Explain the difference between direct, immediate, and register addressing modes in the 8086 microprocessor.
- Next: Explain the concept of ACID properties in a database transaction. Describe how each property-Atomicity, Consistency, Isolation, and…
- All questions in Combined Bank Senior Officer October 2025 – Written