Heh... I haven't been watching but, now that you brought it up and in honor of your great code, here's # 1 million. 😀

It'll take the site software about 20...

Would you mind sharing what you found to be the answer, please?

Please assist? I would like to model this data(https://docs.google.com/spreadsheets/d/1-9x4ean4QleYODvu8GsAsgm8OKVjABeM/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true) for Bigquery as much as possible in a denormalized data model. Bigquery favours denormalized data models. I am busing creating...

In a CTE you could select the date difference between the CreatedDate and the LEAD(CreatedDated, 1, default) where the default is the current month (+1 to deal with boundary...

A large part of the reason why I've worked as an FTE for the same company for more than a decade is because I knew the person in charge of...

p.s. Nice content on the ZIP file.  The Actual Execution plan shows the result of the NON-SARGable query perfectly... a HASH MATCH to join a 5 million row table with...

Heh... lordy.  Here's the rowcount you posted for the query in question...

(10343197 row(s) affected)

And here's the WHERE clause from the code you posted...

  WHERE C_MT_B_COMM_TO_PTY.PARTY_TYP_CD +...

BWAAA-HAAAA-HAAA!!!  You chose the "handle" of "sqlguru"... shouldn't you be telling us how to do this? 😉

That's what I was thinking, as well.

I also hate such "company tests".  They're either written by people at the company that may not know...

Not to worry... we see a whole lot of new "users" of the site that...

I am newish to SQl. Is there a difference in using an alias using the AS keyword as opposed to what you have done here for the Prev_end and ...

I want to try a relational db for a small project, but I'm looking for something free. That can be a free cloud service or a free hosting service....

Microsoft Excel,...

While the book is (judging from the comments on the Amazon link) about 6 years old, there are some things about SQL that don't change much over time and the...