67 257
Assignments Done
99,3%
Successfully Done
In November 2018

Answer to Question #63851 in Databases | SQL | Oracle | MS Access for Mahendra Pandey

Question #63851
Instructions:

For each question, create a SQL query that answers the question and export the query results as a CSV.

Include all of your queries on a separate worksheet in the Excel file, paste each query into its own column and use the first row of the column to ID the query.


Don’t wait until Thursday if you have problems, contact me!

Questions — 50 points total:

1. How many votes had 0 “no” votes? 13 points

2. How many votes had a margin of less than 3 votes? 13 points

3. How many times did each result occur? 13 points

4. How many motions to table got more than 10 Republican “no” votes AND more than 10 Democratic “no” votes? 7 points

5. What was the result of all cloture votes, and how many times did each result occur? 4 points

Bonus: For question 4, for any rejected votes, what was is/are the title of the related bill or bills? 5 points.
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions