If you're querying off of Technologies, the query would look like this:
[Select Id, Name, Count__c From Technology__c];
If you're querying off of a junction object, you would need to query the relationship using a subquery. You can check the Technology or AccountTechnologies object definition (App Setup > Create > Objects) and click the Master-Detail field to find the Child Relationship Name. Add an __r to that relationship name to find what object to subquery from.
Looking for a comprehensive Salesforce course? Enroll now!