Follow the instructions and answer all the questions deliver original work I would like the contents of
Question:
Follow the instructions and answer all the questions deliver original work
I would like the contents of the .sql file along with the python script, as per the instructions
This week, you learned about using database manipulation language (DML) to select records from the database. In this assignment, please use SQL Server Management Studio Express to write SQL statements to manipulate (query) the data that is present in the database.
The following are questions that need to be answered using structured query language:
- What is the total quantity sold for the top 5 products (based on sales)? Show only the product name, total quantity sold, and sales revenue amount in the result.
- What is the total amount of orders for each customer? Show only the customer name and the sales revenue total in the result.
- What is the total amount of orders associated with each product? Show only the product name and the sales revenue total in the result.
- What is the total count of orders per month by year? Show the month, year, and the count in the result.
- What is the total count of customers per state? Show the state (alphabetical) and the count in the result.
Part 1: SQL Script
1. Provide one SQL script that includes each set of SQL statements written to answer the questions above. SELECT, JOINS, and GROUP BY aggregate functions will be required.
2. Be sure to include comments in your code that succinctly describe the logic used and also the question being answered by that section of code.
Part 2: Paper
1. Describe each question being addressed, the tables involved, and the required steps for writing a query using SQL to address the question.
2. Provide annotated screenshots of the results of each query result by embedding each in the paper.
Please include screenshots & source code for high rating!! Thank you!!
Module 8 Assignment Part 1: AVL Rotations
Please solve below questions and I share given coding so give adjusted coding by using given coding at the end. Please correct the place where it says "Writeyour code" and send the coding.
- AVL.java
- AVLNode.java
AVL
In this two-part assignment, you will be coding anAVL, which is a special type of binary search tree. It must follow the same rules as binary search trees: each node has 0-2 children, all data in the node's left subtree is less than the parent node's data, all data in the node's right subtree is greater than the parent node's data, and every node's data is unique.
However, an AVL differs from a BST with its self-balancing rotations, which you will implement in part one of this two-part assignment.
IMPORTANT:
- You will be given unlimited attempts on this assignment, with no cooldown between submissions.
- Please run your code before each submission to ensure that there are no formatting errors! If there are formatting errors in your code, your code will not be graded and a submission attempt will be logged. For more information, please review the Vocareum overview below.
AVLNode
AnAVLNodeclass is provided to you and will be used to represent the nodes of the tree. This file should be treated asread-onlyand should not be modified in any way. This AVLNode class contains getter and setter methods to access and mutate the structure of the nodes. Please make sure that you understand how this class works, as interaction with this class is crucial for this assiggggnment.
Part 1 - Rotations
In the first part of this assignment, you will be implementing the rotation functionality of an AVL. There are four methods that work in conjunction to ensure that the AVL remains balanced at all times; each of which is outlined below. For this assiggggggnment, you will be implementing those four methods. Be sure to read the javadocs for more information!
updateHeightAndBF
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill