Static IP addresses are not really installed. You pay a fee to your ISP and they assign the static address to you. They will route the traffic to the demarc of your network which is either a modem or a router/modem combo device. From there it's up to you manage any connectivity.
If it's a connected to a router you would need to setup port forwarding rules since routers use NAT to seperate betweeen a routable address space (The Internet) and a non-routable address space such as 10.X.X.X, 172.18-32.X.X or 192.168.X.X
I would also highly highly recommend NOT exposing anything like SQL, SMB, RDP directly to the internet as the internet is constantly scanned for systems and can be fairly trivial to exploit and have your network...