How to find Common Nodes

Hi All
I am new to graph dbs so pardon my ignorance if I put some silly queries. I am learning graph dbs from scratch.
So far I have learned how to configure and run orientdb , create db, create nodes and edges in schema and then add data to them.
I am struggling for queries to retrieve the desired results and so thought to seek help from this forum.
For example from below graph

My query is

  1. how I can list all those nodes who have direct connections with more than one nodes and count of those nodes.
    2.How I can find all nodes in the graph who are part of the cyclic connections like A->B->D->F->A and so on.