Hi, the expected output should like the following

Hi Phil,

This worked like a dream.

Now, this leads me on to the more complicated question related to this question - that is of Partitioning....

The output lets more know that model,...

Hi Phil,

The actual application is called dbForge.

Yes, it can handle subqueries and temp tables.

Cheers

Hi Phil,

I friend provided the following suggestion (which works)

 ;
 with M as
 (
     select model, 
      ...

Sorry,

I need the output to look like the following:

No wait, I made a mistake in the output image...I need to change it.

Hi Phil

Thanks for your patience. Let me try and explain.

The following query

SELECT

vehicles.engine_size

,COUNT() AS cnt

,CAST(COUNT() 100.0 / SUM(COUNT()) OVER () AS DEC(5, 2)) AS distribution

FROM dbo.vehicles

GROUP BY vehicles.engine_size

ORDER BY distribution DESC

gives me...

Hi Phil,

Thanks for reaching out.

I'm afraid my knowledge of the type of grouping logic needed to achieve the output I showed above is limited.

I was hoping that someone could come...

Hey Jeff,

Thanks for the lesson.

And this is very nice. I missed the option to do

WHERE city in ('Arizona','California','Hawaii')

Also, not entirely sure how this line works

SELECT ByCityFirstNameID = ROW_NUMBER() OVER (PARTITION...

Hi Jeff,

Thanks so much for reaching out. This is beautiful.

The reason I asked if my code could be tweaked to achieve the same resutls as your code, is because I...

Hi Jeffrey,

It wouldn't cause an issue.

The challenge was just to achieve the result without using LEFT JOIN.

Hi Steve,

I'm getting the error here where c.cust_id=o.cust_id with your code

SSC Guru

Thanks for reaching out.

Thats great

Can you let me know why my code won't work

Can I also point out, that I'm trying to achieve the result without using LEFT JOIN