@jeff Moden. Thank You very much for helping me to learn how to write queries. I still have to learn a lot and this gives me a little...

@

Jeff Moden. this is not the actual table that was given to me. i was given the question in this form and was asked to write queries looking at this...

HI

@hugo Kornelis. thank you for your kind suggestions and advise. i have just started to explore the sql server world. obviously i did not crack the interview....

@

Lynn Pettis. the dates are in mm/dd/yy format

hi @

Jeff Moden. this is not a homework question. This questions were asked to me in an interview. i have created the table definition from the question itself. so far...

hi

@igor Micev. thank you for replying but all of these queries do not give any result

I was not able to understand how the Case statement is working,particularly the THEN part (THEN 1,THEN 2,THEN 2)

CASE WHEN alert_msg ='Meter' THEN 1

WHEN...

Thank You very much @SScrazy for providing the solution. i am very new to the sql server programming and have started learning recently. could you please help me understand the...