List in alphabetical order of names of customers with more than $10 million in annual revenue Give names and average monthly revenue of customers having annual revenue exceeding $20 million. Name the column Average_Monthly_Revenue with a literal (note the underscores). (Hint: Use division.)
What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 800 pounds? (HInt: Avoid duplcates.)
Give names of all customers whose type is not retailer or wholesaler and who have over $20 million in annual revenue. Use the NOT IN keywords.
To what cities have customers with revenue less than $5 million sent shipments? (Hint: Avoid duplicates.)
For each customer (cust_id and cust_name) with annual revenue under $10 million, and whose shipments average more than 5000 pounds, what is the total weight of shipments they’ve sent? Label the total column as Total_Weight. (Hint: Requires Having.)
What is the total weight of shipments that the Mack trucks have carried? (Truck make is 'Mack'.) Label the answer column as Total_Loads.

Is a string of code written to hurt others by damaging or destroying

Jamie has to enter the names, employee id’s, and income of a group of employees into a worksheet. which option will jamie use to describe the data

Write a program to analyze student’s scores. each student’s id and 4 original test scores are saved in the attached file “student_id_scores.txt”. assume there are exactly 15 students in the class.• the program first opens the file, reads student’s ids and scores from the file and saves them in two arrays: o create a one-dimensional string array “ids” to store the student’s ids.o create a (parallel) two-dimensional int array “scores” to store student’s original test scores. this array has 5 columns, the original 4 test scores should be saved in the first 4 columns, and the last column will be used to save the average score after the calculation in next step.• the program then retrieves test scores from the array “scores”, calculates average score and determines the final letter grade based on the rules in the table below for each student. assume average score is integer value.average score = (score1 + score2 + score3 + score4) / 4average score letter grade90 ~ 100 a80 ~ 89 b70 ~ 79 c60 ~ 70 d0 ~ 60 f• the average score should be saved back in the 5th column of “scores” array.• create a new parallel one-dimensional char array “grades” to save each student’s letter grade.• program also needs to find the number of a, number of b, number of c, number of d and number of f grade. as well as the highest, lowest and average score of the class.• finally, program will display all of the original scores and all results on the computer screen using the format shown as the sample output below.• the program must contain at least the following functions: (1) a function “getscores” to read and store data into “ids” and “scores” arrays.(2) a function “analyzescores” to calculate student’s average score, determine letter grade, get the number of a, b, c, d and f, find the highest, lowest and average score of the class.(3) a function “displayresults” to display all of the results