return total value on the day

Database
Enthusiast

return total value on the day

On what day was the total value (in $) of returned goods the greatest? On what day was the
total number of individual returned items the greatest?Capture.JPG

6 REPLIES
Junior Contributor

Re: return total value on the day

Did you try solving any of those task on your own?

Enthusiast

Re: return total value on the day

No as I don't know the syntex to use for calculation of total value and total number of individuals on day.

Junior Contributor

Re: return total value on the day

Then you should start learning the basics first.

Enthusiast

Re: return total value on the day

May I ask for advice of reliable source please.

Thank you in advance.

Junior Contributor

Re: return total value on the day

There are lots of beginners books & online resources, usually not for Teradata, but any based on Standard SQL should be quite close.

 

I can't recommend as I didn't read any of those for years :)

Enthusiast

Re: return total value on the day

Ok. Thank you for your help.