Imagine You Are Working with a MySQL Table Called LIBRARY_MEMBERS

question 5

Essay

Imagine you are working with a MySQL table called LIBRARY_MEMBERS that includes the following columns: MEMBER_ID, MOBILE_NUMBER, MAX_BOOKS (the maximum number of books that member can check out at one time), and BOOKS_CHECKED_OUT (the number of books currently checked out). Write a SQL query that will display a grid including the MEMBER_ID for all rows plus a column called CAN_CHECK_OUT that indicates how many more books that library member must check out to reach his or her maximum.

---

Definitions:

Phenotypic Plasticity

The skill of an organism to adjust its phenotype in accordance with changes in its surroundings.

Genetic Polymorphism

The existence of two or more distinct alleles at a given locus in a population’s genome.

Spans of Control

The number of subordinates or tasks that one manager or leader can effectively oversee or manage.