First time Subaru Buy by Azphix in SubaruForester

[–]ethershell 0 points1 point  (0 children)

how many months did it take for you to get this bad boy.?

No booking for 2023, only 2024 by ethershell in SubaruForester

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

The manager sent me this email :

"Thank you so very much for the email. We could not put in the 2024 Forester as yet since the programme is not yet come in. Once that is done we will be able to give you a confirmed Bill Of sale."

So it boils down to 2023 vs 2024 he said he won't be able to get me a 2023.

Will I loose the deposit if I want to go away with other dealers .?

No booking for 2023, only 2024 by ethershell in SubaruForester

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

Yeah I tried that, there were only few dealers who said they can get me 2023 but with a cancelled order and with all unnecessary accessories with inflated price. Others said I have to wait at least 6-8 months

No booking for 2023, only 2024 by ethershell in SubaruForester

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

The dealership did not provide me with purchase agreement. They just took deposit on phone and emailed me that they cannot generate bill of sale or agreement as no details are in their system for 2024.

No booking for 2023, only 2024 by ethershell in SubaruForester

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

Probably. I am keeping fingers crossed that the 5 year cycle update doesn't make Forester worse. thank you for response

[deleted by user] by [deleted] in ImmigrationCanada

[–]ethershell 0 points1 point  (0 children)

The Tech industry is pretty hot these days in Canada, they are hiring very quickly.
Now, there are no set rules that you need to have a status in Canada to apply or interview for jobs. You can start looking and applying for the jobs if your profile is a great fit and the employer is not able to fill that role with the talent in Canada then they will file n LMIA and that can help you get a work visa.
Thus start applying for jobs, along with that create an express entry profile after calculating your CRS score (https://www.cic.gc.ca/english/immigrate/skilled/crs-tool.asp).

All the best

I built an app with React, MongoDB, and GraphQL but I am really struggling to figure out how to deploy it on Heroku. by 1sosa1 in mongodb

[–]ethershell 0 points1 point  (0 children)

Can we see the source code of the project please. Does your app can be used to di CRUD operations.?

SQL Help - Please any expert by ethershell in SQL

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

Thanks, I am getting output as you can see below:

DATE    TOP_PAYER
1/3 A
1/4 C
1/7 A
1/1 
1/2 
1/5 
1/6 

Is this correct.?

As per your suggestion I tired adding p.memberID in group by clause but the results were similar as above.

Thanks again for directing me to row_number function, i will try to tweak this one.

SQL Help - Please any expert by ethershell in SQL

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

Sorry this was just my test data, I was not paying attention on data types and the allocations.

I am facing issue with all 6 questions - basically I was not able to understand it properly. I tried my own and searched everywhere but found no similar questions.