Question

Bowling League Database 1. Give me a list of the tournaments held during September 2017.

What is the SQL statement needed given the fields?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SELECT * FROM TOURNAMENTS WHERE TOURNEYDATE >= ' 2017-09-01' AND TOURNEYDATE <= ' 2017-09-30'

so to get all the tournaments in sep we need to find all tournaments which held from 2017-09-01 to 2017-09-30 so that it will give all the details so same things i have used in the query

Add a comment
Know the answer?
Add Answer to:
What is the SQL statement needed given the fields? Bowling League Database 1. "Give me a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT