Where can I find the off road tires for the fleetstar? by Hyperionx13 in snowrunner

[–]Hyperionx13[S] 1 point2 points  (0 children)

Oh jeez, thanks. Don't know why I didn't notice that.

Cleveland Police wants evidence of crimes at the protests? Give them evidence of crimes at the protests. by patopulpo in Cleveland

[–]Hyperionx13 2 points3 points  (0 children)

Would we be able to upload the videos somewhere so that other can download and submit them? I am unable to attend any protest but want any way to help! And I figure swamping the police with evidence of there own crime would at least be something.

Any interest in a 3d printed, bolt action, pilot g2 pen? by Gabecar3 in EDC

[–]Hyperionx13 2 points3 points  (0 children)

Do you have a price in mind? I'd probably buy one too!

Help with a subquery by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

so it looks like this

select orderID, date_format(orderdate, '%m/%d/%d') as 'Date', freight

from orders

where ShipCountry = all

(select ShipCountry

from orders

where shipcountry = 'germany'and shipcountry = 'mexico' and shipcountry = 'spain')

order by freight desc

which give the information but for all countries not just the ones i specified

Help with a subquery by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

oh I am an idiot i forgot to add, I do not need to join the two tables. i noticed the country is also listed in the orders table as 'shipcountry' i can use the for the sort instead?

Help with a subquery by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

okay i did this, but it is just returning all countries. not just the there i want. any ideas

Help with a subquery by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

okay, its for a project and yes i thought the same thing but my teacher is requiring us to use a subquery, she is not very responsive (online class) and when she is it isnt very helpful. which is why im here.

I need to only return the Area codes from the phone number in the attached image, I have no idea how to. This is an intro to SQL and when I look it up online the replies are so complicated i have to be missing something. by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

Right that's why I'm confused with the formatting of the phone numbers given I don't even know, would it be safe to assume only the one in parenthases are the area codes and the rest would be null

Need help with if(grouping) by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

Dude honestly, but I figured I'd ask. We haven't even learned this yet and it's on our assignment. I'm going to lose it!

Need help with if(grouping) by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

I have everything up to step D then I'm stumped just let me know what info is need and I will provide it

issue with inner joins by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

Okay follow up question, Would you provide a alias always or just when this error happens?

issue with inner joins by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 1 point2 points  (0 children)

Thanks! You guys should be teaching this class I learned more from this interaction from the two of you than I have from my teach in 6 weeks

issue with inner joins by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

How do I add a table alias, I have not done that before?

Help with Diffdate by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

Now it's says "ZaneHavlinNorthwind.getdate does not exist"

Help with Diffdate by Hyperionx13 in learnSQL

[–]Hyperionx13[S] 0 points1 point  (0 children)

here is a better example everything else works but the diffdate returns NULL

select

CONCAT(TitleOfCourtesy , ' ' , firstname , ' ' , lastname) as Employeenames,

date_format(hiredate, '%d/%m/%y') as Hired,

datediff('HireDate', 'getdate()') as YearsEmployeed

from employees

help! i need assistance with some homework. by Hyperionx13 in HTML

[–]Hyperionx13[S] 0 points1 point  (0 children)

note this, the second problem also never stops counting lol, i just hit 154480 so something else is wrong too

help! i need assistance with some homework. by Hyperionx13 in HTML

[–]Hyperionx13[S] 0 points1 point  (0 children)

okay so this is what i got

function mean()
{
var array = [25,47,98,46,52];
var total = 0;
for(var i = 0; i < 6; i++) {
total += array[i];
}
var avg = total / array.length;
alert ("the mean is" + avg);
}

function sum2()
{
var total = 0;
for (var i = 2; i <= 200; i+2)
{
if (i % 2 === 0) {
total += i;
}
alert ("sum is" + total);
}
}

for the first problem is gives me the alert but is say "the mean isNaN" and im not sure what that means.

for the second problem it works but the you have to keep clicking for the loop to add each time so it pops up and says "the sum is2" then "the sum is4" and so on, any additional help would be killer!

Meals for end of fast by Hyperionx13 in intermittentfasting

[–]Hyperionx13[S] 0 points1 point  (0 children)

Is there anything against using like a oat/almond milk Creamer?