Is it possible to find out a value that is the most different with pure Sqlite3?

Lets say I have a list of url's and I want to find out the url that is the most unique. I mean which is appearing the fewest. Here is an example of the database:

3598 ('http://ift.tt/1J1S07N')
3599 ('http://ift.tt/1MxtsWD')
3600 ('http://ift.tt/1J1S07R')
3601 ('http://ift.tt/1Mxtq16')
3602 ('http://ift.tt/1J1S1st')
3603 ('http://ift.tt/1Mxtq18')
3604 ('http://ift.tt/1J1S1sv')
3605 ('karriere-beratung.monster.de')
3606 ('karriere-beratung.monster.de')

In this case it should return jobs.monster.de or hilfe.monster.de. I only want one return value. Is that possible with pure Sqlite3?

It should be some kind of counting of the main url before the ".de"

At this moment I do it this way:

con.execute("select url, date from urls_to_visit ORDER BY RANDOM() LIMIT 1")