Write a SELECT statement that answers this question: Which products have a list price that’s greater than the average list price for all products? Write this using a subquery. Return the ProductName and ListPrice columns for each product. Sort the results by the ListPrice column in descending sequence.
Answer:
Following are the query to the given question:
Explanation:
Query:
SELECT ProductName,listprice FROM Products where listprice > (SELECT AVG (p.listprice) FROM productsp) ORDER BY listprice DESC;
Description:
In the above-given query, multiple select statements are used, in the first statement, it selects the column that is "ProductName and listprice" from the products table and uses where clause to check the listprice that is greater than another select statement.
In this, it calculates the average listprice of the table and converts a value into descending order.
On a roulette wheel, the pockets are numbered from 0 to 36. The colors of the pockets are as follows: Pocket 0 is green. For pockets 1 through 10, the odd-numbered pockets are red and the even-numbered pockets are black. For pockets 11 through 18, the odd-numbered pockets are black and the even-numbered pockets are red. For pockets 19 through 28, the odd-numbered pockets are red and the even-numbered pockets are black. For pockets 29 through 36, the odd-numbered pockets are black and the even-numbered pockets are red. Write a program that asks the user to enter a pocket number and displays whether the pocket is green, red, or black. The program should display an error message if the user enters a number that is outside the range of 0 through 36.
Answer:
pkt = int(input("Pocket Number: "))
if pkt == 0:
print("Green")
elif pkt >= 1 and pkt <=10:
if pkt%2 == 0:
print("Black")
else:
print("Red")
elif pkt >= 11 and pkt <=18:
if pkt%2 == 0:
print("Red")
else:
print("Black")
elif pkt >= 19 and pkt <=28:
if pkt%2 == 0:
print("Black")
else:
print("Red")
elif pkt >= 29 and pkt <=36:
if pkt%2 == 0:
print("Red")
else:
print("Black")
else:
print("Error")
Explanation:
The program was written in Python and the line by line explanation is as follows;
This prompts user for pocket number
pkt = int(input("Pocket Number: "))
This prints green if the pocket number is 0
if pkt == 0:
print("Green")
If pocket number is between 1 and 10 (inclusive)
elif pkt >= 1 and pkt <=10:
This prints black if packet number is even
if pkt%2 == 0:
print("Black")
Prints red, if otherwise
else:
print("Red")
If pocket number is between 11 and 18 (inclusive)
elif pkt >= 11 and pkt <=18:
This prints red if packet number is even
if pkt%2 == 0:
print("Red")
Prints black, if otherwise
else:
print("Black")
If pocket number is between 19 and 28 (inclusive)
elif pkt >= 19 and pkt <=28:
This prints black if packet number is even
if pkt%2 == 0:
print("Black")
Prints red, if otherwise
else:
print("Red")
If pocket number is between 29 and 36 (inclusive)
elif pkt >= 29 and pkt <=36:
This prints red if packet number is even
if pkt%2 == 0:
print("Red")
Prints black, if otherwise
else:
print("Black")
Prints error if input is out of range
else:
print("Error")
What kinds of animations are available for slide objects besides animations for entrances and exists?
identify and explain 3 methods of automatically formatting documents
Answer:
Three common automatic formatting for documents are...
Margin justification- where text is aligned to both the left and right margin- producing a neat page
Paragraph justification- where paragraphs are not split as they go over the page- but are moved to the next page in one piece.
Tabular justification- where text is indented or aligned at a 'tab stop'. - to emphasise a paragraph.
The 3 methods used in Microsoft word to auto format are; Margin Justification, Tabular Justification, Paragraph Justification
What is formatting in Microsoft Word?In Microsoft word, there are different ways of formatting a text and they are;
Margin justification; This is a type of formatting where all the selected text are aligned to either the left or right margin as you go to a new page as dictated by the user.Paragraph justification; This a type of auto formatting where paragraphs are not split as they go to a new page but simply continue from where they left off.Tabular justification; This is a type that the text is indented or aligned at a 'tab stop' to possibly show a paragraph.Read more about Formatting in Microsoft Word at: https://brainly.com/question/25813601
Stroke weight - ____ of the line around a shape or size of the point
Explanation: "A stroke is referred to as an outline, or instead, it describes the edges of a shape or a simple line. The stroke height can be modified by changing the settings in an appropriate panel. ... Flash uses the color panel to determine whether that color is for fills or strokes.
How can we make our programs behave differently each time they are run?
Answer:
By given the right speech as much as the answers must be
Explanation:
By given the right speech as much as the answers must be
A Products table and an Orders table have several linked records that are joined by a cross-referencing table named ProductsOrders. What kind of table relationship do these tables demonstrate?
A.one-to-one
B.one-to-many
C.many-to-many
D.many-to-none
Answer:
I believe it could be D. many to many.
Answer:
C. Many-to-Many
Explanation:
:)
Which of the following is a tip for making sure you are messaging safely?
A.Always use your full name.
B.Be careful who you allow on your buddy list.
C.Fill in your online profile in accurate detail.
D.Ignore instances of online harassment.
Answer:
B.
Explanation:
You have to be careful about the people you talk too, because, if you don't, you can be in real danger.
sorry if I am wrong
Answer: B
Explanation:
How can you determine if the story is told in the third person
Answer:
They use pronouns like They, Them, He, She, It.
Use the drop-down menus to match each description to its corresponding term.
millions of tiny dots on a computer screen
number of pixels that span an image’s width multiplied by its height
pixels mapped onto an X-Y coordinate plane
Answer:
Your answer is
Explanation:
A monitor's screen is divided up into millions of tiny dots, called ________. Select your answer, then click Done.
You chose pixels, clicked the Done button.
Abby has a research paper to write and doesn't know which sites provide quality information. Which of the following sites is the best site for a research paper? Click the image(s) to select the answer. When you are finished, click Done.
You selected the College Online Library option, clicked the Done button.
Answer:
millions of tiny dots on a computer screen
✔ pixels
number of pixels that span an image’s width multiplied by its height
✔ image resolution
pixels mapped onto an X-Y coordinate plane
✔ raster graphic
Get it ig
This is for school. The teacher told us to make a song. Here is mine plz be honest and tell me if it is good or not. Plz be honest
So now that we r friends we can all shake hands. I’m glad the bad things r off my mind because I can get back to my grind yeah. So now I feel free can’t you see. Yeah, I’m happy. Yeah, I’m happy yeah. Yeah, I’m happy. Yeah, I’m happy yeah. Now back to the beat while I sit in my seat and get something to eat. Yeah… Uh huh. LET’S GO! So, as I’m walking down the street, I feel free Uh. Don’t play with me yeah. Don’t act like a clown in my hometown. U wana be frowning because I made a touchdown. Maaaaaaaan STOP HATIN. U wana hate go get u a plate. Oh wait... you can’t get a plate. Driving in my car aint going to far. Gona hit the... dance bar! Dance on the floor gona break the door. Alright I’m tired time to go home and play on my phone.
Answer:
it's funny I honestly like it I guess it just depends on if your teacher has a sense of humor
AND ALL THE BEST FOR YOUR SONG....
Assume three jobs arrive at approximately the same time (arrival time are all 0), but Job A arrives slightly before Job B, and Job B arrives slightly before job C (if the jobs must be selected in order, the order should be A->B->C). Job A requires 2 sec of CPU, Job B is 8 secs, and Job C is 7 secs. Assume a time-slice of 1 second. Given a RR scheduler (time slice is 1sec), what is the average response time of the three jobs?
Answer:
Explanation:
Correct:
A group of statisticians at a local college has asked you to create a set of functions that compute the median and mode of a set of numbers. Define these functions, median and mode, in a module named stats.py. Also include a function named mean, which computes the average of a set of numbers. Each function should expect a list of numbers as an argument and return a single number. Each function should return 0 if the list is empty. Include a main function that tests the three statistical functions using the following list defined in main:
List: [3, 1, 7, 1, 4, 10]
Mode: 1
Median: 3.5
Mean: 4.33333333333
#Here is the code I am using:
def median(list):
if len(list) == 0:
return 0
list.sort()
midIndex = len(list) / 2
if len(list) % 2 == 1:
return list[midIndex]
else:
return (list[midIndex] + list[midIndex - 1]) / 2
def mean(list):
if len(list) == 0:
return 0
list.sort()
total = 0
for number in list:
total += number
return total / len(list)
def mode(list):
numberDictionary = {}
for digit in list:
number = numberDictionary.get(digit, None)
if number == None:
numberDictionary[digit] = 1
else:
numberDictionary[digit] = number + 1
maxValue = max(numberDictionary.values())
modeList = []
for key in numberDictionary:
if numberDictionary[key] == maxValue:
modeList.append(key)
return modeList
def main():
print ("Mean of [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]: "), mean(range(1, 11))
print ("Mode of [1, 1, 1, 1, 4, 4]:"), mode([1, 1, 1, 1, 4, 4])
print ("Median of [1, 2, 3, 4]:"), median([1, 2, 3, 4])
main()
The Error that I am getting is on Line 14: AttributeError: 'range'object has no attribute 'sort'.
Also on Line 36:
Line36: 10]: "), mean(range1, 11)).
Answer:
In Python:
def median(mylist):
mylist.sort()
if len(mylist) % 2 == 1:
midIndex = int((len(mylist) +1)/ 2)
print("Median: "+str(mylist[midIndex-1]))
else:
midIndex = int((len(mylist))/ 2)
Mid = (mylist[midIndex] + mylist[midIndex-1] )/2
print("Median: "+str(Mid))
def mean(mylist):
isum = 0
for i in range(len(mylist)):
isum += mylist[i]
ave = isum/len(mylist)
print("Mean: "+str(ave))
def mode(mylist):
print("Mode: "+str(max(set(mylist), key=mylist.count)))
Explanation:
Your program is a bit difficult to read and trace. So, I rewrite the program.
This defines the median function
def median(mylist):
This sorts the list
mylist.sort()
This checks if the list count is odd
if len(mylist) % 2 == 1:
If yes, it calculates the mid index
midIndex = int((len(mylist) +1)/ 2)
And prints the median
print("Median: "+str(mylist[midIndex-1]))
else:
If otherwise, it calculates the mid indices
midIndex = int((len(mylist))/ 2)
Mid = (mylist[midIndex] + mylist[midIndex-1] )/2
And prints the median
print("Median: "+str(Mid))
This defines the mean function
def mean(mylist):
This initializes sum to 0
isum = 0
This iterates through the list
for i in range(len(mylist)):
This calculates the sum of items in the list
isum += mylist[i]
This calculates the mean
ave = isum/len(mylist)
This prints the mean
print("Mean: "+str(ave))
This defines the mode
def mode(mylist):
This calculates and prints the mode using the max function
print("Mode: "+str(max(set(mylist), key=mylist.count)))
technical processor used in translate of instruction programs into single easy form for the computer to execute
Answer: The process of translation instructions expressed in a higher-level language into machine instructions (sometimes translating into Assembly language as an intermediate step) is called compilation, using a tool called a Compiler.
Explanation:
Complete the sentence.
When you enter “weather.com" into the URL, the _____ acquires the IP address.
a. Revolver
b. HTTP
c. Telnet
the http acquires the ip address
Explanation:
this is because it is the default protocol
Answer:
A. Revolver
Explanation:
On Edge, it states that a revolver, "makes a request to a name server, giving a domain name and receiving an IP address."
I hope this helped!
Good luck <3
You have a limited budget and you need to type color documents frequently, which type of printers would you buy?
Answer:
you can use these printer if you have this amount of budget
Explanation:
Identify the suitable synonym for the given words
ignorant
Answer: uneducated
Explanation:
uneducated
how are headers and footers are useful in presentation
Answer:
Explanation:
PowerPoint is a software that allows user to create headers as well as footers which are information usually appears at the top of the slides and the information that appears at the bottom of all slides. Headers and footers are useful when making presentation in these ways:
✓ Both provide quick information about one's document/ data clearly in a predictable format. The information that is provided by the Header and footers typically consist of ;
©name of the presenters,
©the presentation title
©slide number
©date and others.
✓ They help in setting out different parts of the document.
✓Since the Headers and footers can appear on every slide, corporate confidentiality as well as copyright information can be added to footer area to discourages those that can steal ones secrete.
advantage of using computer
Answer:
What are the advantages of using a computer?Although there are disadvantages to using a computer, we believe the advantages greatly outweigh the disadvantages (although we may be biased). Below is a list of the main advantages and benefits you'll get and society gets from using a computer.Increase your productivityComputers increase your productivity and, with a good understanding of the software running on them, you become more productive at everything you do. For example, once you have a basic understanding of using a word processor, you can create, store, edit, share, and print documents and letters. Each of these things was either impossible or slower with all pre-existing technologies.Connects you to the InternetConnecting a computer to the Internet is what unlocks the full potential of a computer. Once connected, your choices and available options are almost limitless. Many of the benefits listed on this page are with a computer connected to the Internet.Can make you money?When connected to the Internet, a computer could help you make money many different ways. For example, it's cheaper to create and run an online store than having a physical store. Also, once online, your store or product has a global audience and you could sell to anyone in the world.Save timeToday, there are many services that help save you time. Several examples are listed below.Using a site like Amazon, you can find many of the same products you would find at a store for the same price or cheaper. You can also have those items shipped to your door without having to leave your home.You could use an online banking site to view your bank balance and pay bills.If your favorite restaurant has a website, you can order take out without having to wait in line.You can view online traffic cameras and maps with traffic information to find the quickest route.Why do we need operating systems?
NO NOSE PORQIE JExplanation:
why is GDS important to travel industry?
Answer:
A Global Distribution System (GDS) is a wonderful tool that properties should use to reach customers easily. This is a central reservation system that allows travel agents to access hotel rates and availability as well as prices for flights, trains and rental car companies in real time.
Which of these is a problem that a computer CANNOT solve
A. Getting the news out to the public quickly
B. Helping architects build models of new buildings
C. Getting rid of racism
D. Making a game for entertainment
My goal is to help Edmentum kids
Select the correct answer.
What type of communication flow occurs in a formal network when employees submit status reports to their superiors?
A.
downward communication
B.
horizontal communication
C.
lateral communication
D.
upward communication
Hopefully people will answer these
Answer:
D upward communication
Answer:
D.
upward communication
Explanation:
Write a C program that gets 4 integer values from the user, namely, x1, x2, y1, and y2, and then calculates and returns the distance according to the above formula. Use whatever format for entering your data you like. Your program should prompt the user for these values, accept input from the keyboard, and then print out the result. You will have to execute the program four times to cover the test cases below (feel free to use a loop if you want to work ahead). Include a screenshot (or four) that shows the results for the following values: 1) (2,3), (4,5) 2) (4,3), (-6,-5) 3) (-1,3), (4,-2) 4) (-9,-12), (-7, -8)
Answer:
#include <stdio.h>
#include <math.h>
int main(){
float x1,x2,y1,y2,distance;
printf("x1: "); scanf("%f", &x1);
printf("y1: "); scanf("%f", &y1);
printf("x2: "); scanf("%f", &x2);
printf("y2: "); scanf("%f", &y2);
distance = sqrt((x1 - x2)*(x1 - x2) + (y1 - y2)*(y1 - y2));
printf("Distance: %f", distance);
return 0;
}
Explanation:
This line declares all required variable (i.e. the coordinates and the distance)
float x1,x2,y1,y2,distance;
The next four line prompt and get input for the coordinates
printf("x1: "); scanf("%f", &x1);
printf("y1: "); scanf("%f", &y1);
printf("x2: "); scanf("%f", &x2);
printf("y2: "); scanf("%f", &y2);
This calculates the distance
distance = sqrt((x1 - x2)*(x1 - x2) + (y1 - y2)*(y1 - y2));
This prints the calculated distance
printf("Distance: %f", distance);
See attachment for sample runs
differentiate between system software and application software
Answer:
system software is the software which control overall operation of the computer . For eg. Ms.dos ,window 2003 ,etc whereas application software is a software which work on the top of operating system to solve number of problems .For eg. Ms.word,Ms.excel,etc
1.) System software is used for operating computer hardware. On other hand Application software is used by user to perform specific task.
2.) Low level languages are used to write the system software. While high level languages are used to write the application software.
3.) System Software a general purpose software. While application software a specific purpose software.
4.) Without system software, system can’t run. While without application software system always runs.
5.) System software runs when system is turned on and stop when system is turned off. While application software runs as per the user’s request.
6.) System Software programming is complex than application software. Application software programming is simpler as comparison to system software.
HOPE IT HELPS
PLEASE MARK ME BRAINLIEST ☺️
Please help if you have the correct answer to the post test manufacturing and safety answer.
——— is a form of semi-renewable energy that you can produce from agricultural feedstock. It can be made from common crops
such as sugarcane, potato, manioc, and corn. It does not completely replace gasoline as a fuel because of efficiency, food, and environmental
concerns.
Answer:
ethanol
Explanation:
got it right on ed
Sentence Deobfuscate Name this file deobfuscate.cpp Hints: Don’t overthink this problem. Prompt the user to enter a collection of sentence words (i.e., words in the sentence), with the spaces removed (i.e., the obfuscated sentence) and with words that are less than ten (10) letters each. Then prompt the user to enter a sequence of numbers that represent the length of each corresponding sentence word (i.e. the deobfuscated details). Output the deobfuscated sentence. Convert char c to int by subtracting 48 (‘0’) from c.
Sample Execution:
Please enter obfuscated sentence: Thisisasentence
Please enter deobfuscation details: 4218
Deobfuscated sentence: This is a sentence
Answer:
In C++:
#include <iostream>
using namespace std;
int main(){
string text,lengt;
cout<<"Please enter obfuscated sentence: "; cin>>text;
cout<<"Please enter deobfuscation details: "; cin>>lengt;
string t1, t2;
int kount = 0;
for(int i = 0;i<lengt.length();i++){
kount+=(int)(lengt[i]-'0');
t1 = text.substr(0, kount);
t2 = text.substr(kount, text.length()-1);
text = t1 +" "+ t2;
kount++; }
cout<<"Deobfuscated sentence: "<<text;
return 0; }
Explanation:
This declares the text and the deobfuscation details as string
string text,lengt;
This prompts for the sentence
cout<<"Please enter obfuscated sentence: "; cin>>text;
This prompts for the details
cout<<"Please enter deobfuscation details: "; cin>>lengt;
t1 and t2 are declared as string. They are used to split the texts into 2 parts
string t1, t2;
This declares and initializes a count variable to 0
int kount = 0;
This iterates through the deobfuscation details
for(int i = 0;i<lengt.length();i++){
This gets each deobfuscation character
kount+=(int)(lengt[i]-'0');
The next two instructions splits the text into 2
This gets from 0 to kount.
t1 = text.substr(0, kount);
This gets from kount to the last index
t2 = text.substr(kount, text.length()-1);
The new string or sentence is calculated here
text = t1 +" "+ t2;
The kount variable is incremented by 1
kount++; } The loop ends here
This prints the new sentence
cout<<"Deobfuscated sentence: "<<text;
See attachment for program file
You have many drugs that you want to store electronically along with their purchase dates and prices, what kind of software would you use? *
Wordprocessing
Database
Presentation
Spreadsheet
Answer:
Database
Explanation:
To store a variety of drugs electronically, along with displaying their purchase dates and prices, the kind of software that would be used is database.
You have a certificate that you want to convert into digital form, what kind of device would you use? *
نقطتان (2)
Printer
Barcode scanner
Scanner
Plotter
Answer:
Scanner.
Explanation:
In this scenario, you have a certificate that you want to convert into digital form, the kind of device you would use is a scanner.
When scanners and digital cameras are used to capture images that are uncompressed or minimally processed image file, it is known as a RAW image file.
Generally, this file type are usually very large in size because of their lossless quality and does not have any alteration and as such have not been processed; thus, cannot be printed
Which of the statements below describe how to print a document?