EssayproSolutions

(Solved) : Get Around Problem File Information Need Use Gives Error Even Though Works Latitude Solve Q43955470 . . .

So how do I get around this problem?

The file has all the information that I need to use:

But it gives an error,

Even though it works with Latitude!!

How to solve this?!!

> tail (dbReadTablecdbcon, “zip”),3) zip_code latitude Longitude city state county 4273999928 55.39536 -131.6754 Ward Cove AK Ketchikan Gateway 42740 99929 56.44989 – 132.3644 Wrangell AK Wrangell Petersburg 42741 99950 55.54201 -131.4327 Ketchikan AK Ketchikan Gateway > names (dbReadTable(dbcon, “zip”)) [1] “zip_code” “latitude” “longitude” “city” “state” “county” > sql_gry – “SELECT city, state, zip_code FROM zip WHERE CA =- state” madboadTablardcon in > sql_gry – “SELECT city, state, zip_code FROM zip WHERE state == GU” > head(dbGetQuery(dbcon, sql_qry)) Error: no such column: GU > sql_qry = “SELECT * FROM zip WHERE longitude > 100” > head(dbGetQuery(dbcon, sql_qry)) zip_code latitude Longitude city state county 96910 13.44426 144.7863 Hagatna GU Guam 2 96911 13.44426 144.7863 Tamuning GU Guam 96912 13.44426 144.7863 Dededo GU Guam 96913 13.44426 144.7863 Barrigada GU Guam 5 96914 13.44426 144.7863 Yona Guam 6 96915 13.44426 144.7863 Santa Rita GU Guam GU Show transcribed image text > tail (dbReadTablecdbcon, “zip”),3) zip_code latitude Longitude city state county 4273999928 55.39536 -131.6754 Ward Cove AK Ketchikan Gateway 42740 99929 56.44989 – 132.3644 Wrangell AK Wrangell Petersburg 42741 99950 55.54201 -131.4327 Ketchikan AK Ketchikan Gateway
> names (dbReadTable(dbcon, “zip”)) [1] “zip_code” “latitude” “longitude” “city” “state” “county” > sql_gry – “SELECT city, state, zip_code FROM zip WHERE CA =- state” madboadTablardcon in
> sql_gry – “SELECT city, state, zip_code FROM zip WHERE state == GU” > head(dbGetQuery(dbcon, sql_qry)) Error: no such column: GU
> sql_qry = “SELECT * FROM zip WHERE longitude > 100” > head(dbGetQuery(dbcon, sql_qry)) zip_code latitude Longitude city state county 96910 13.44426 144.7863 Hagatna GU Guam 2 96911 13.44426 144.7863 Tamuning GU Guam 96912 13.44426 144.7863 Dededo GU Guam 96913 13.44426 144.7863 Barrigada GU Guam 5 96914 13.44426 144.7863 Yona Guam 6 96915 13.44426 144.7863 Santa Rita GU Guam GU

Expert Answer

Answer to So how do I get around this problem? The file has all the information that I need to use: But it gives an error, Even th…