Question

A blood bank maintains two tables - DONOR, with information about people who are willing to donate blood and ACCEPTOR, with information about the people who are in need of blood. The bank wants to know the number of males and the number of females with a particular blood group.

Answer 1

Explanation:

There is a blood bank which maintains two tables

Donor: the people who are willing to donate blood

Acceptor: the people who are in need of blood.

The blood bank wants to place an order for some pints of blood with some other bank

To place such an order the bank needs to query their database and get the blood groups whose total amount that donors can give is less than the total amount of blood the acceptors need.

Both blood groups and their unfulfilled quantities are to be queried.

MARK AS BRAINLIST