company sql set
Microsoft
Microsoft
SQL Set
Licenses, products, Teams, Azure, support, activity logs, growth, and storage analytics.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
License Utilization Rate
Calculate active license utilization.
Q02
Product Adoption Trend
Find monthly active users by product.
Q03
Teams Collaboration Activity
Find teams with high message volume.
Q04
Support Ticket Resolution Time
Average resolution time by category.
Q05
Cloud Resource Usage
Rank users by compute hours.
Q06
License Expiry Alert
Find soon-expiring licenses.
Q07
Multi-Product Users
Find users across multiple products.
Q08
Daily Active Users
Count daily active users.
Q09
Team Member Growth
Find fast-growing teams.
Q10
Storage Usage by Subscription
Sum storage by plan type.