Answer:
See explanation below
Explanation:
SELECT list_price,
FORMAT(list_price, 1) AS formatted_list_price,
CONVERT(INT, list_price) AS converted_list_price,
CAST (list_price AS INT) AS casted_list_price
FROM products_table;
In SQL, the SELECT statement is used to initiate a query. It lists the variables that will be contained in the output, just like choosing items on a list, with each item being separated by a comma.
The FORMAT, CONVERT, CAST are all functions that are used to change the format of a value. Their formats are;
FORMAT - Format (value, decimal places)CONVERT - Convert (datatype, value)CAST - Cast ( value AS datatypeIn SQL, aliases are used to rename variables (usually those that contain functions) to ones taste. The AS is used after the function and the new name follows right after.
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
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.
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)))
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
What are some positive and nevative aspects of technology?
Answer:
Explanation:
Positive:
Enhances Learning.
Fosters Problem-Solving Skills.
Develops Future Technological Leaders
Negative:
Diminishes Relationships and Social Skills
Stimulates Health Issues
Reduces Sleep Quality
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....
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
The Merge & Center option is available in the_____________ group of the Home tab.
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.
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:
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 ☺️
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
How can you determine if the story is told in the third person
Answer:
They use pronouns like They, Them, He, She, It.
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:
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:
C++ "Simon Says" is a memory game where "Simon" outputs a sequence of 10 characters (R, G, B, Y) and the user must repeat the sequence. Create a for loop that compares the two strings starting from index 0. For each match, add one point to userScore. Upon a mismatch, exit the loop using a break statement. Assume simonPattern and userPattern are always the same length.
Ex: The following patterns yield a userScore of 4:
Ex: The following patterns yield a userScore of 9:
simonPattern: RRGBRYYBGY
userPattern: RRGBBRYBGY
Result: Can't get test 2 to occur when userScore is 9
Testing: RRGBRYYBGY/RRGBBRYBGY
Your value: 4
Testing: RRRRRRRRRR/RRRRRRRRRY
Expected value: 9
Your value: 4
Tests aborted.
Answer:
In C++:
#include <iostream>
using namespace std;
int main(){
int userScore = 0;
string simonPattern, userPattern;
cout<<"Simon Pattern: "; cin>>simonPattern;
cout<<"User Pattern: "; cin>>userPattern;
for (int i =0; i < simonPattern.length();i++){
if(simonPattern[i]== userPattern[i]){
userScore++; }
else{ break; }
}
cout<<"Your value: "<<userScore;
return 0;
}
Explanation:
This initializes user score to 0
int userScore = 0;
This declares simonPattern and userPattern as string
string simonPattern, userPattern;
This gets input for simonPattern
cout<<"Simon Pattern: "; cin>>simonPattern;
This gets input for userPattern
cout<<"User Pattern: "; cin>>userPattern;
This iterates through each string
for (int i =0; i < simonPattern.length();i++){
This checks for matching characters
if(simonPattern[i]== userPattern[i]){
userScore++; }
This breaks the loop, if the characters mismatch
else{ break; }
}
This prints the number of consecutive matches
cout<<"Your value: "<<userScore;
What is the second step in opening the case of working computer
Answer: 1. The steps of opening the case of a working computer as follows:
2. power off the device.
3. unplug its power cable.
4. detach all the external attachments and cables from the case.
5. Remove the retaining screws of the side panel.
6. Remove the case's side panel.
Explanation:
Please Help I'm Very Stressed, my school is holding a competition of making the best video game and the winner gets 1000$ and I really want 1000$, the problem is that I can't make any good games or don't have any ideas for anything the game has to have lore and a plot and characters and it's really stressing so please help me get a idea or something easy enough to make
Answer:
make a game like fun run
Explanation:
Answer:
u should make an competive game where people battle each other sorry if i cant spell good its cause im rushing
Explanation:
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
What kinds of animations are available for slide objects besides animations for entrances and exists?
Identify the suitable synonym for the given words
ignorant
Answer: uneducated
Explanation:
uneducated
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.
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.Explain, step by step the process required to carry out drive error correction (disk check) on Windows 10
Explanation:
Disk Error Checking in Windows 10
In Windows 8, Microsoft has redesigned chkdsk utility – the tool for detecting and fixing disk corruption. In Windows 8, Microsoft introduced a file system called ReFS, which does not require an offline chkdsk to repair corruptions – as it follows a different model for resiliency and hence does not need to run the traditional chkdsk utility.
The disk is periodically checked for file system errors, bad sectors, lost clusters, etc., during Automatic Maintenance and you now no longer need to really go and run it. In fact, Windows 8 now even exposes the state of the file-system and disk via the Action Center or under the Drive properties in File Explorer. If potential errors are found, you will be informed about it. You can continue to use the computer, while the scan is carried out in the background. If errors are found, you may be prompted via a notification to restart your computer.
Read: How to cancel ChkDsk in Windows.
Windows found errors on this drive that need to be repaired
At times you may see a message – Windows found errors on this drive that need to be repaired. If you see it, you may want to manually run a scan. Earlier you had to schedule Disk Error Checking for the system drive and for drives which had files or processes or folders opened. In Windows 10/8, error checking starts right away, even on the system drive – and it longer needs to be scheduled at start-up. Only if some errors are found, will you have to restart to let Windows 10/8 fix the errors.
How to run CHKDSK in Windows 10
To begin the scan, right-click on the Drive which you wish to check and select Properties. Next, click on Tools tab and under Error-checking, click on the Check button. This option will check the drive for file system errors.
If the system detects that there are errors, you will be asked to check the disk. If no errors are found, you will see a message – You don’t need to scan this drive. You can, nevertheless, choose to check the drive. Click on Scan drive to do so.
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:
Which of the statements below describe how to print a document?
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:
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
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.
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.