Just like using "iptables" table to find the open ports and firewall rules for linux, is there a way to find out firewall rules and open ports for windows using osquery?

Not easily at the moment. You’d have to parse the registry keys

Can you give some screenshots of how to do that ?

Docs are here for pulling info from the Windows registry: https://osquery.io/schema/4.3.0#registry

Thanks