With the following Schema from our project database fill out

With the following Schema from our project database, fill out the blanks. Write the SQL code that will show all the information of FAMILY table. SELECT ______ FROM _____ Count the number of people for each role of staff. Descending order by name of role. SELECT ROLE, ___(PERSON-ID) FROM _____ BY ROLE ORDER BY ROLE (_____) Write the SQL code that, will find the names and addresses for a

Solution

a.

SELECT *

FROM FAMILY;

b.

SELECT ROLE, COUNT(PERSON-ID)

FROM STAFF

GROUP BY ROLE

ORDER BY ROLE DESC;

c.

SELECT PERSON.F-NAME,PERSON.L-NAME,FAMILY.ADDRESS

FROM PERSON,FAMILY,STAFF

WHERE STAFF.ROLE = \"Senior-staff\"

AND PERSON.PERSON-ID=STAFF.PERSON-ID

AND PERSON.FAMILY-ID=FAMILY.FAMILY-ID;