Cannot reach outside network or IP after upgrading to Ubuntu 12.04

Question

I'm stuck on a SQL query.

Consider the following table:

Table DG_GAME_ROUNDS    
RoundId int
GameId  int
RoundNumber int
Value   varchar(20)
Guess   varchar(20)
Answer  varchar(20)
Correct bit
Minutes int
Seconds int
Milliseconds    int

This table holds the results of game rounds. Now sometimes you can fat finger an answer to the game and wind up with a guess time of 35 or even 0 milliseconds. These answers skew the results of my game and I want to remove them.

I want to figure out the average guess time where the guess is at least 200 milliseconds long. So if a game had five rounds with guesses of 455, 400, 340, 30, 300. I want to ignore the 30 and average out the remaining four values and get an average guess time of 374. Without dropping the 30 the average guess time would be 305.

My problem is that I'm trying to join two subqueries and I'm getting an error message that there is a problem around the "on" statement. I think joining subqueries is allowed.

 select vt.gameid, vt.totalms, vt.numofguesses, vt.correctguesses
from
(select    gr.gameid 
       ,  sum((gr.seconds*1000) + gr.milliseconds) as totalms
       ,  count(gr.roundid) as numofguesses
       ,  sum(cast(gr.correct as int)) as correctguesses
          from work_tables.dbo.dg_game_rounds gr (nolock)            
          group by gr.gameid 
  ) vt 
inner join  (
              select vtIII.gameid, vtIII.avgtime
              from 
                  (
                     select vtII.gameid, sum(vtII.avgms)/count(vtII.avgms) as avgtime
                     from (
                              select gr.gameid, gr.seconds * 1000 + gr.milliseconds as avgms
                              from dg_game_rounds gr (nolock)
                              where gr.seconds * 1000 + gr.milliseconds > 200
                          ) vtII
                     group by vtII.gameid
                   ) vtIII 
 on vtIII.gameid = vt.gameid

Solution

First try to ping your gateway 77.68.108.1. If you are able to do so, then

I think /etc/resolv.conf is not properly configured.

Just open /etc/resolv.conf file . At the top of that file, add a line like this:

nameserver 8.8.8.8

This is the resolver to which all DNS resolution requests will be directed to. 8.8.8.8 and 8.8.4.4 are the two open-resolvers which anyone can use.

After this, you should be able to ping google.com.

Comments

[Aaron Bertrand]

Have you considered creating views to make your T-SQL code a little easier to read/write/maintain? If this query is called a lot, an indexed view might even make sense for the subquery you've called vt.

[JNK]

Voting to close since questions like this are pretty much guaranteed not to ever help anyone else in the future. This is way too localized to be of future use.

[Jamie Hutber]

blow me down, it worked :) Another problem then, I am trying to install plesk for a client. But the server won't hit: gb.archive.ubuntu.com/ubuntu but when using a browser the page opens perfectly. If i ping above it returns host unknown. Any ideas? Been trying for 2 days.

[goldilocks]

4.2.2.2 is another big public DNS server.

[Jamie Hutber]

Ye sorry, I am using ping gb.archive.ubuntu.com not with the trailing ubuntu. So i am trying to install ubuntu using the autoinstaller. The problem I get is 500 http://gb.archive.ubuntu.com/ubuntu/ hardy/main i386 Packages release v=8.04,o=Ubuntu,a=hardy,n=hardy,l=Ubuntu,c=main origin gb.archive.ubuntu.com I follow all of the steps, it adds autointall.plesk.com into my apt-get package. Then as you see gives me a 500 error when trying to download. Been working on it for 2 days now :(

[Jamie Hutber]

One more odd thing, i can ping google.com and bbc.com but I can't ping www.ccn.com. Any idea why?

[Jamie Hutber]

I'll start a new question relating to the pinging google.com if you don't have any ideas

[pradeepchhetri]

@JamieHutber ping is not the correct utility to check reachability because ICMP packets may be blocked in many cases. Instead use tcptraceroute www.cnn.com 80. This will check the connectivity to 80 port of cnn.com

[Kemin Zhou]

My os is ubuntu16. Top of the line says: do not edit, will be overwritten. Is there anyway to modify the DNS?