SQL QUERIES

For each month of 2010 compare the total payment amount with those of each month of the previous year as a ratio.
The Rental Table
rentalID
clientID
startDate
amount
Maria KaramaliDeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
Sounds like some type of homework / assignment.  You'll need to make a reasonable try at it yourself first.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Hi Maria,
Being an homework, I would prefer to point you how to solve this, instead of giving you the solution.
Give a look on the MONTH and YEAR functions.
To get the total of a field, use the SUM function but you'll need to GROUP BY other fields to obtain the desired values.

Give it a try and return if you have doubts.
Good luck.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MishaProgrammerCommented:
If I understand question, author would like one list of sub directories and another list of all files from base (selected directory).
Sorry, if I click to report, it is my miss click(
0
MishaProgrammerCommented:
There is no activity from author
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.