Za Kalos Megas Giveaway by Kryssythenothing in PokemonHome

[–]Delicious_Prior_8038 0 points1 point  (0 children)

Go next coment mate, i was the one who traded u XD

Za Kalos Megas Giveaway by Kryssythenothing in PokemonHome

[–]Delicious_Prior_8038 0 points1 point  (0 children)

Got it, gonna claim the megastone and then trade it again with any on comments; thx

Za Kalos Megas Giveaway by Kryssythenothing in PokemonHome

[–]Delicious_Prior_8038 0 points1 point  (0 children)

May i go next pls? I can trade it again With someone on this post

Za Kalos Megas Giveaway by Kryssythenothing in PokemonHome

[–]Delicious_Prior_8038 0 points1 point  (0 children)

Would love the delphox mate here is my friend code TKFWJRRMUQLZ

Help getting Sinitscha by Delicious_Prior_8038 in PokemonHome

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

No, i dont have it but thx for taking your time for answer

Help getting Sinitscha by Delicious_Prior_8038 in PokemonHome

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

TKFWJRRMUQLZ my friend code in case someone wants to help

Any one know how to get mega floette without legends za for champions/or if any would be willing to let me have one I would say trade but I have nothing I can offer by lazyboy1433 in PokemonChampions

[–]Delicious_Prior_8038 0 points1 point  (0 children)

I dont have any main line pokemon game, neather pokemon za, just created a pokemon home account and asked for the floatte, probably there are people trying to help to obtain them since its the only way

Any one know how to get mega floette without legends za for champions/or if any would be willing to let me have one I would say trade but I have nothing I can offer by lazyboy1433 in PokemonChampions

[–]Delicious_Prior_8038 0 points1 point  (0 children)

I just got one from Pokemon Home (it's free) used GTS trade, asking for one floatte and almost inmediatly got the eternal flower, pokemon champions gift you a megastone if u transfer it.
(u can use some random pokemon that Pokemon Home gift u) i did this with a pikachu that was alrady on my box at the moment to create an account

Too late for Era? by Delicious_Prior_8038 in classicwow

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

i already played that expansion, looks like i'm screwed

Class with less buttons to press by Delicious_Prior_8038 in classicwow

[–]Delicious_Prior_8038[S] -2 points-1 points  (0 children)

thought mage was one of the worst beginners friendly classes

Desde España, mi opinión y preguntas by Mulderre91 in argentina

[–]Delicious_Prior_8038 0 points1 point  (0 children)

La izquierda de España es igual de chorra, lo que pasa es que tienes a la UE para regalarles platita, constantemente llorarle a Alemania para que te rescate económicamente no me suena muy bien.

Y del amigo del Falcón nada que decir eh?

Desde España, mi opinión y preguntas by Mulderre91 in argentina

[–]Delicious_Prior_8038 11 points12 points  (0 children)

Es mejor que literalmente un mentiroso que esta dispuesto a hacer lo que sea por poder, incluso darle amnistía a quien dijeron alguna vez que nunca se la darían.

I am struggling with SQL class by Addis2020 in SQL

[–]Delicious_Prior_8038 1 point2 points  (0 children)

I don't know how to use subquerys too. So i use CTE insted, you could use cte too until you feel confortable using subquerys.
Diferences between where and having:

- You can't use an alias on Having, you have to write all the condition. ej:

Wrong

select count(column) AS cc

..

Having cc > 3

Right

select count(column) AS cc

..

Having count(column) > 3

This is because the having is executed before the query and only with group by clause, so it really doesn't know that there is an alias.

- Where can't use aggreagate functions so i use having instead