Modular Code with OOP Patterns

Describe how you would implement specific Object-Oriented Programming (OOP) patterns to keep code modular.

For this SQL representation, use the provided pattern, module, and module-pattern tables to identify active modules associated with at least two distinct OOP patterns.

Output

1. Return one row per qualifying active module with module_name, pattern_count, and alphabetically ordered pattern_names.
2. Exclude inactive modules and modules associated with fewer than two patterns.
3. Order by pattern_count descending, then module_name ascending.