Can someon please assist in creating a query that supports the highlighted areas. The query commnad needs to include at least one JOIN and a WHERE or HAVING clause from the 5 tables. Thanks in advance.

PROMO NAME PICTURE PROMO STATUs Applies to CUSTOMER PROMO PERIOD Has OB_DATE PICTURE BEFORE CUS LNAME FK1 JOB ID FK2 WISH ITEM ID WEIGHT I WEIGHT OUT WEIGHT DIFF ESTIMATE_PRICE Updates dR CUS CNAME CUS EMAIL JOB STATus JOB RETURN BILLING ADDRESS BILLING CITY BILLING ZIP CODE SHIPPING ADDRESS SHIPPING CITY SHIPPING_ZIP_CODE CUS CITY CUS ZIP_coDE CUS ANNIVERSARY DATE REFERENCE MAILING UIST OB STATUS_NAME JOB STATUS_DESC FK2 STATE ID FK3 CUS STATUS_ID FK4 COUNTRY ID JEWELRY TYPE Entered into FK4 JEWELRY TYPE ID FKS COUNTRY ID FKE STATE ID FK7 SIZE ID EWELRY TYPE PK SIZE ID ---H-FK9J0B_STATUS ID INSIDE DIAMETER MM Consists of ORDER COMP_ORDER COST ates FK1 VENDOR ID COMPONENT_ORDER_STATUS PK COS ID I Produces NE CUT Included in COMPONENT TYPE E CLARITY Entered into COMP TYPE E_CLARITY GOLD KARAT FK8 COMP TYPE ID FK1 STONE_CUT ID FK2 STONE CLARITY ID FK3 STONE_CARAT IDR FK4 STONE ID FKS METAL ID Is implemented E CARAT implemented GOLD KARAT NE CARAT METAL PURITY UR FK COLOR ID dR FK9 METAL PURITY ID FK10 GOLD_KARAT ID FK13 COMP ORDER IDR Determines METAL PURITY