Consider the relation account (customer, balance) where customer is a primary key and there are no null values. We would like to rank customers according to decreasing balance. The customer with the largest balance gets rank 1. ties are not broke but ranks are skipped: if exactly two customers have the largest balance they each get rank 1 and rank 2 is not assignedQuery1: select A.customer, count(B.customer) from account A, account B where A.balance

• A. 2 and 5
• B. 1 and 3
• C. 1 and 4
• D. 3 and 5