def METHOD_NAME(mssql_connector):
    """It should connect to the default database and retrieve the response to the query"""
    datasource = MSSQLDataSource(
        name='mycon',
        domain='mydomain',
        query='SELECT Name, CountryCode, Population ' 'FROM City WHERE ID BETWEEN 1 AND 3',
        database='master',
    )
    expected = pd.DataFrame(
        {'Name': ['Kabul', 'Qandahar', 'Herat'], 'Population': [1780000, 237500, 186800]}
    )
    expected['CountryCode'] = 'AFG'
    expected = expected[['Name', 'CountryCode', 'Population']]
    # LIMIT 2 is not possible for MSSQL
    res = mssql_connector.get_df(datasource)
    res['Name'] = res['Name'].str.rstrip()
    assert res.equals(expected)