u/tlefst

Left Hadapsar Gadital at 5pm in the direction of Uruli Kanchan. Took a relatively lesser known right turn, drove through nurseries upon nurseries both side of the road, crossed Tarade village and then Walti gaon until reached the ghat's base near the railway line.

Saw the railway signal green so I thought I'll show you trains today🤣

Well, captured Nizamuddin Vasco Goa Express.

NZM Vasco Goa Exp

Here it comes crawling:

https://reddit.com/link/1thtqfy/video/h039yiv9l42h1/player

Just as Goa Exp was gone, Bangalore Jodhpur Express was visible coming out of the ghat's tunnel far away (here is a zoomed-in clip, not very clear, apologies):

https://reddit.com/link/1thtqfy/video/1l4lgbhnl42h1/player

Here is the train itself:

https://reddit.com/link/1thtqfy/video/lj1cx2wam42h1/player

As one can see, the road on this particular route is not suitable for scooters.

https://preview.redd.it/0txodtulk42h1.jpg?width=4080&format=pjpg&auto=webp&s=bada6d2fc03505dcda86ef2fa0c1342d6596246a

Here is a clip capturing the road:

https://reddit.com/link/1thtqfy/video/yvmq2xnim42h1/player

Here is the route:

https://preview.redd.it/zqzyg3sqo42h1.png?width=989&format=png&auto=webp&s=b24d7035e7adca6fa9196ffa28bb107d7e1239ad

Given an input table tbl_puzzle, write a SQL query to produce the expected output table.

https://preview.redd.it/zcltgrk3q9zg1.png?width=505&format=png&auto=webp&s=6c12467cb807eebdde29a7a749a198e3a889b77a

Note that in the tbl_puzzle, the column rule is of VARCHAR type.

What's to be done: If a rule value is 2+3, add the val for id 2 & 3 to yield 26 in column ans of expected output.

Hey folks!

While practicing MySQL last year, I came across the forward filling problem whereby you've to replace each NULL value in a column by the latest non-NULL value in that column.

For instance, a table ffill is as follows:

Table is 'ffill' with 6 records

The expected output is as below:

https://preview.redd.it/jffulpn2n9zg1.png?width=521&format=png&auto=webp&s=fea54999344b8dfb548de6d8fe5ffe84bec72d3f

As we can see, the NULL values in dept column are forward filled. Here is the MySQL query I wrote back then to yield the output table above:

https://preview.redd.it/1pez6nggn9zg1.png?width=559&format=png&auto=webp&s=1e91a77e519879cbec90d3fe22f0875f893d08d9

My question is, are there caveats of forward filling like this? What might they be? Will this way always work across the DBMSes? What would be the implications of this approach on large data sets?

I used to wonder what the region flanked by Purandar hill and all the way till Jejuri would look like at late night from a higher vantage point near Saswad.

Hence this trip (attached image and video below). The cool night and the tranquility of the remote area was healing!

Left from Viman Nagar at 1745h and passed Hadapsar gadital, Theur phata, Shindwane ghat, Singpur, Vaanpuri, Kumbharvalan chowk, Sangameshwar temple, Changawateshwar temple, Panwadi base, return to main road to go till Purandar Fort base... returned from there and reached home at 2330h.

From right to left: 20km stretch from Saswad till Jejuri Khandoba mandir; Panvadi climb can be seen too when zoomed

The attached image shows a 20km sprawl (from right to left) covering Saswad till Jejuri Khandoba temple. I shot this image (& the video below) from a field near Kumbharvalan chowk.

Zoomed at 00:14 to focus on Panwadi ghat climb and panned all the way to left eventually capturing the moon

I don't know if even watching the above shots in full screen would fully capture the awesomeness of it all, and the super cool, clear night there ...

Attached image below shows my location and the region I captured.

Red dot (spot from where I clicked); red splatter (region captured in click)

A ride there between sunset and 10pm would be safe for all.

Once again, I'd repeat that the view was great.