Install Microsoft SQL Server on Pop!_OS

I am trying to install Microsoft SQL Server on the latest Pop!_OS 22.04 LTS (jammy) but receiving following errors:

sudo apt-get install mssql-server
Reading package lists… Done
Building dependency tree… Done
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:
mssql-server : Depends: libldap-2.4-2 but it is not installable
E: Unable to correct problems, you have held broken packages.
I was also not able to add the repository using the information given at microsoft sql server link for Ubuntu :

wget -qO- packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
OK
Can someone guide me on how to resolve these dependencies and install MS Sql Server on Pop!_OS?

I also installed Synaptic and then tried installing mssql-server but got the following error as shown in image: