GOOGLE SQL Interview Question | SQL Intermediate Question 16

Write a query to calculate the sum of odd-numbered and even-numbered measurements separately for a particular day and display the results in two different columns. Refer to the Example Output below for the desired format.
Definition:
Within a day, measurements taken at 1st, 3rd, and 5th times are considered odd-numbered measurements, and measurements taken at 2nd, 4th, and 6th times are considered even-numbered measurements.
LINK FOR THE QUESTION - datalemur.com/questions/odd-e...
#amazon #google #facebook #dataanalytics #sqldeveloper #placement #college #ai