SQL Frequency Table with Joins and Sorting

Craft a SQL query to generate a frequency distribution of a specific attribute, incorporating two join operations. Consider how you would implement a GROUP BY or ORDER BY clause for the attribute. What modifications are required to handle NULL values effectively?