wabash | WSL session-set open continuously

I need to answer this tricky question in SQL, I tried many ways and finally got this query which retrieves only MAX SUM or MIN SUM without the respective employee.

This code retrieves only the MAX charge SUM values but I need it with MAX SUM value (group by job code) with the employee ID or Name as request in the question.

I am trying to extract the data between two elements "Executives" and "Analysts", example, but i don't know how to proceed. My html is:

I have this website for search data (http://wedge3.hcauditor.org),
This is an image on the start page.

here first input box(House # Range) = 3419
and the second one is (empty)
and third one(Street Name) = Wabash

when we submit this data and we have this link, http://wedge3.hcauditor.org/view/re/0570005018800/2017/summary

we can't create URL for searching data because of only change in this link Parcel ID(0570005018800)

actually, I am new to the python web scrap, but I have good knowledge of urllib, beautifulsoup and requests modules.

I need to know, can we do this with python and if it is which module use for this.

I am using python 3.6

I am trying to use some code to download Google street view images.

Code so far is:

I want to iterate through a Pandas dataframe and get the fuzz.ratio score only for each row pair (not for all combinations). My dataframe looks like this:

Acct_Owner, Address, Address2

0, Name1, NaN, 33 Liberty Street
1, Name2, 330 N Wabash Ave Ste 39300, 330 North Wabash Avenue Suite 39300

There are missing values, so I am using "try:" to skip over missing value rows. Below is the current for loop:

So I'am making a table with a char, varchar and date. I got an error message saying "Conversion failed when converting date and / or time". If anyone can help me fix, this you got sincere thank you. :D

this is my code for creating and inserting data on my table:

I have the following ui.R