From the reader list

Where major = "Computer" and library number (choose the library number from where max).

Select avg (number of books borrowed)

Borrow from the table

The library card number is in (select the library card number from the reader list, where gender =' female' and reader type ='02').