Question

1,List the first and last name of the donators that donated in December 2009.

2. List the ID's of the volunteers that have not worked.

3. List the ID, first name, and last name of any employees who works in the Finance department.

4. List all the different prices suppliers have for 'Tasty Meat' product.

5. Select the store ID and store phone number for all stores in 'St.Paul'.

6. List the member first and last name, address, city, zip code, and state of those members who have a 'Student Membership' type. Order by last name.

7. Display all different types of maintenance which are done by employees. Make sure there are no duplicates.

8. How many employees are there in each zoo? Use an alias name "TOTAL_EMP".

9. List each private event type and the total event price of each. Use an alias name "TOTAL_PRICE".

10. List the food supplier company name and the average food price for each supplier.

11. List the minimum amount paid with check.

12. Find the minimum, maximum, and average salaries of employees for each zoo. Also list the zoo's name.

13. List the receipt ID and total amount for each receipt by only using the RECEIPT_LINE table. Only display results that have a sum of over $50. Order results by the receipt ID.

14. From the inventory table, list the product ID and the sum of the following columns: inventory amount, inventory max stock and inventory reorder point. Only display the results that have more than 900 total items in inventory.

15. List all the animal IDs of animals that are of the Bald Eagle breed.

16. Return the animal ID and animal name of all Alligators.

17. List the names of the sponsor companies that donated in July of 2008. Also list the amount donated, but limit your results with those sponsors who donated more than 2000.

18. Return the animal names and illness description of each animal that has contracted 'Anthrax'.

19. List the medication type, prescription dosage, animal name, and the breed name where the animal is a Bald Eagle or a Nine-banded Armadillo. Order the results by animal name.

20. What's the illness that animals which had 'Tasty Meat with Antioxidants' in their dietary requirements had? Order by illness description.

21. Return the fist and last names of each donator that donated between March and July in 2004.Use a subquery.

22. List the ID, first name, last name, phone number and social security number of the employee(s) hired most recently. Use a subquery.

23. Which of the payment type, check or credit card, has the maximum total payment amount? Find using nested subqueries.

24. List the first and last names of the employees that are certified keeper's by using a subquery.

25. List prescription dosages for animals weighing more than 375 pounds. Use a subquery.

26. Give the first and last name of the employee whose receipt amount equals 14 dollars using a subquery.

27. Select the employee ID, first name and last name for all employees who work in the Administration office building. Use subqueries.

28. List the breed name of every breed of animal that is a type of bear.

OFFICE PK OENCED OFFICE PHONE NUMBER OFFICE BUILDING ANIMAL BREED PRANIM BREED IR ANIM BREED NAME ANIM BREED HABITAT ANIM BREED_COUNTRIE_OF_ORIGIN ANIM BREED_PHOTO_FILENAME ANIM BREED OTHER DETAILS VOLUNTEER VOL ID PK VOL_FIRST_NAME VOL LAST NAME VOL PHONE NUMBER VOL AVAILABILITY PO VOLUNTEER DEPT HISTORY PKFKI I VOL ID PYLFK2 DEPTID ANIMAL DIETARY REQUIREMENTS PK FRII ANNLEREED ID PRK FOOO ITEM ANIM_DIETARY REQUIREMENT FK3 AND FOOD CATEGORY PK FOOD CATEGORY ID FOOD_CATEGORY_DESCRIPTION EMPLOYEE PK EMPID EVP FIRIT NANE EMP_LAST_MANE EMP PHONE NUMBER EMP_SALARY DEPT ID EMP_SOCIAL SECURITY_NUMBER EMP_HIRE DATE EMP DEPARTURE DATE EMP TYPE EVP ADDRESS EMP_CITY EVPP_CODE EMP_STATE FK2 OFFICE ID DEPARTMENT PK PEPTID VOL START DATE VOL END DATE VOL DAYS WORKED VOL DEPT CHANGE DATE ABBIGNED FOOD SUPPLIER PKEODDLUPID FK1ZOO_ID DEPT_NAME FOOD_BUP_COMPANY_NAME ANIMAL CHECKUP ANIM CHECKUP DATE FOOD ITEM SUPPLIER PK 200 CORPORATE SPONSOR PK SPONLD SPON_COMPANY_NAME ZDO ID SPON_DATE_DONATED SPONLUTART DATE SPON END DATE FOOD ITEM FOOD ITEM DESCRIPTION FOOD CATEGORY ID FOOD QOH ANIM_CHECKUP_HEIGHT ANIM_CHECHUP WEIGHT ANIM_CHECHUP LENGTH ANIM_CHECKUP GENERAL HEALTH ANIM CHECKUP OTHER DETAILS FOOD PRICE INVENTORY PKFK1 PROOUCT D PKF 2 WAREHOUSED O EP TYPE ZOO_NAME ZOO PHONE NUMBER ZOO_HOURS ZOO ADMIS BION_RATE 200_ADDRES: ZOO_CITY 200 ZIP CODE 200_STATE INVEN AMOUNT INVEN DATE REETOCKED INVENMAX_STOCK INVEN REORDER POINT WAREHOUSE PK WAREHOUSE ID ILLNESS ANIMAL ANIMLD PY,FK1 PK,FK2 ILL_START DATE ILL END DATE WAREHOUSE PHONE NUMBER WAREHOUSE ADDRESS WAREHOUSE CITY WAREHOUSE ZIP CODE WAREHOUSE STATE "MA MAINTENENCE PKFKI EMPIR MAINT_TITLE "RE RESEARCHER FK,FK1 EMPIR RES BONUS "GS CUSTOMER SERVICES PK,FK1 EMP_ID CUL_SER_COMMISSION CORPORATE SPONSOR PAYMENT PK.FK1SPONLID PK,FK2 PAY ID ILLNESS TYPE PK.FK1EMPD KEEP_CERTIFIED PKILL TYPE IR : SPON_PAY_PAYMENT_DATE ANIM NANE ANIM GENDER ANIM BIRTH DATE ANIMLACQUIRED FROM ANIMLARRIVAL DATE ANIM DEPARTURE DATE ANIM_HEIGHT ON ARRIVAL ANIM WEIGHT_ON_ARRIVAL ANIM OTHER DETAILS ANIML LIVING ENVIRONMENT_ID ANIM BREED ID ILL DESCRIPTION PRODUCT PK PSARUCT ANIMAL. LIVING ENVIRONMENT ANIM LIVING ENVIRONMENT_ID PK TBAND PRODUCT NAME PRODUCT SUGGESTED PRICE PRODUCT BAR_CODE NUMBER PRODUCT TYPE ANIML_LIVING ENVIRONMENT TYPE DONATOR MEMBERSHIP OWNER PK MENE OWNERID PK DOND MEMBERSHIP TYPE PK I NEM TYPE JD PY,FK1 VET ID ABBOC ID STORED TRANB_DATE FK2 | EMPI TRANETOTAL AMT PY FK3 PKFK1 DON_FIRST_NAME DON LAST NAME DON PHONE NUMBER DON_DATEL DONATED ZOO ID MEME_TYPE_TITLE MEMB_TYPE PRICE MEME TYPE DESCRIPTION PRODUCT_TYPE PK PAY_ID MEME_FIRST_NAME MEME LAST NAME MENE PHONE NUMBER MENE DATE OF BIRTH NENE_TYPE_ID ZOO_ID MENE ADORES E MEME_CITY MEME ZIP CODE MENE_STATE PRIVATE EVENT PK PRIV_EVENLD PRIV_EVEN DATE PRIV EVEN TYPE PRIV EVEN PRICE FK1 200 PREB DO BABE PRE DATE TAKEN O VET FIRIT NAME VET LA ET NANE VET HOSPITAL VET PHONE NUMER STERL PAY_TYPE PAY CREDIT CARD NUMBER PAY EXPIRATION DATE PAY CREDIT CARD TYPE PAY AMOUNT PAY QLOX NUMBER MED UNIT OF MEA BURE NED DIRECTIONS PK STORE IN RECEIPT UNE RECEPT LINED 1 MANUFACTURED PRODUCT PKFK1 PRODUCT ID PURCHASED PRODUC PROFK1 PRODUCT_ID PK STORE PHONE NUMBER PRIVATE EVENT PAYMENT PRODUCT START DATE PRODUCT FINIBH DATE PRODUCT PURCHAS PRODUCT PURCHAS DONATOR PAYMENT PKFK1DONLID PKF 2 PAYLID DON PAY_PAYMENT_DATE PRIVEVENUD ASSOCIATION PKAN SOC_ID TEAM IN ARRIN STORE CITY STORE ZIP CODE SELLING PRICE QUANTITY FK PRODUCT_ID FICE TRANLD OG PRAKT PRIV EVEN_PAY_PAYMENT DATE A880C_NAME TEAM_NAME

Answer 1

1)

SELECT DON_FIRST_NAME, DON_LAST_NAME FROM DONATOR WHERE DON_DATE_DONATED BETWEEN >= '2019-12-01' AND '2019-12-30';

2)

SELECT VOL_ID FROM VOLUNTEER WHERE VOL_ID NOT IN (SELECT VOL_ID FROM VOL_DEPT_HISTORY);

NOTE: As per Chegg policy I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.