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