Write a SQL query to join multiple tables and retrieve specific data.
For this exercise, use the provided activity table and return records representing positive check-in activity. Exclude rows with other activity types, zero or negative counts, or missing counts.
user_name, city, activity_date, and activity_count.activity_date descending, then user_name ascending.| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique activity record identifier |
| user_name | VARCHAR(80) | Name of the user associated with the activity |
| city | VARCHAR(80) | City associated with the activity |
| activity_type | VARCHAR(40) | Type of activity recorded |
| activity_date | DATE | Date on which the activity occurred |
| activity_count | INT | Number of activities recorded |