Write a quuery using the adventureworks database

Assignment Help Computer Engineering

Reference no: EM132212306

Question :

Write a quuery using the AdventureWorks Database. As part of an internal competition, you are asked by the CEO to provide the name of the employee who made the highest total single sale in 2014.

This data needs to include the filter Tax & Freight using OrderDate for the year.

The CEO has also requested that you provide the winner's e-mail (along with other specific information) so that the CEO can send the notification of congratulations.

Reference no: EM132212306

Questions Cloud

Write a recursive function that takes an integer n and print : Write a recursive function called printVertically that takes an integer n and prints the base 10 digits of n to standard output.

List the total number of transactions made by members : List the total number of transactions made by members in each state. Show your results in descending order on state abbreviations.

Write 100 integers created randomly into the file : Write 100 integers created randomly into the file using text I/O. Integers are separated by spaces in the file.

Write a program that will work as a point of sale system : Write a python program that will Work as a point of sale system at a rodeo snack bar.

Write a quuery using the adventureworks database : Provide the winner's e-mail along with other specific information so that the CEO can send the notification of congratulations.

Write a python program the gets a string containing a name : Write a python program the gets a string containing a person's first, middle, and last names, and then display their first, middle, and last initials.

Test the program for the graph : List of nodes or false to compute a list of nodes, starting with the origination node and ending with the destination node in a graph.

Create two empty lists named ids and scores ids : Ask the user for an id number. As long as this is not 0, append the id to ids, then get a score (0.0 - 100.0) and append it to scores.

Write an rcpp function that returns the sum of all positive : Write an Rcpp function that returns the sum of all positive even integers less than or equal to n, which must be non-negative.

User Account

All Pages