I have the table structure shown below. The purpose is to assign "standard" sources submitted on a form that are imported into the ORG table. The ORG::source_non_std is unstructured text. Examples might be: Web site, Google, Internet, web search. All of these are assigned a "standard" source name contained in the GLOSSARY table connected via the join.
This works but I also want to know how many from each source also Ordered the product as indicated by ORG::c_flag_ordered.
So, for each std_source in the GLOSSARY, I want a count of the ORGs that actually placed an order.
Which table should the calculation go into and is another relationship required?