Answer:
SELECT product_name, SUM(DISTINCT quantity) AS total_quantity
RANK() OVER (PARTITION BY total_quantity ORDER BY product_name) AS rank,
DENSE_RANK () OVER (ORDER BY quantity DESC) AS dense_rank
FROM Order_items
JOIN products ON Order_items.product_id = products.product_id
GROUP BY product_id
Explanation:
The SQL query returns four columns namely, product name, total quantity, rank and dense rank. The query uses the rank and the dense rank function to return the rows according to numeric ranks.
if opening capital is ks 70000 and closing capital is ks 90000 what is the amount of profit or loss
Explanation:
if opening capital is ks 70000 and closing capital is ks 90000 what is the amount of profit or loss
You already know how to use lists. What is the index of 5 in the following list? [2, 3, 5, 1, 6]
Answer:
it's 2
Explanation:
it goes 0, 1, 2.
The index of 5 in the following list [2, 3, 5, 1, 6] is 2. The correct option is b.
What is a list in computer language?A list is a collection of items that can be ordered or unordered. Adding, removing, and storing items are just a few of the many uses for lists. However, the software needs adequate memory to keep up with changes made to the list in order for the programmer to do the various duties for the list.
An ordered group of values is a list. The components of a list are referred to as its elements or items. An ordered list of numbers (or other items like geometric objects) is referred to as a sequence, and it frequently follows a certain pattern or function.
A list is a series of different variables that are all gathered under one common name. Rather than creating a program with numerous variables,
Therefore, the correct option is b, 2.
To learn more about the list, refer to the link:
https://brainly.com/question/14297987
#SPJ2
The question is incomplete. Your most probably complete question is given below:
O 4
02
O 1
03
Course Aggregation Many times, departments are only interested with how students have done in courses relative to a specific major when considering applicants for admission purposes.
For this problem you are given a dictionary where the keys are strings representing student ids and the values are dictionaries where the keys represent a course code and the value represents a grade. Your task is to write a function that given a dictionary of the described format and a prefix for course codes, return a dictionary where each key is a student id and the corresponding value is the average grade of the student only in courses that start with the given prefix.
def course_grader (student_to_grades, course_prefix): ({str, {str, float}}) -> {str, float} I: a dictionary containing the grades of students (as described above) and a course code prefix P: compute and store the average grade of all students only for courses that start with the given course prefix 0: a dictionary of student ids to average grades as described in the Processing step pass
Answer:
def course_grader(student_to_grades, course_prefix):
student_grades = dict()
for key, value in student_to_grades.items():
grade_score = 0
for course,grade in value.items():
if course_prefix == course:
grade_score += grade
student_grades[key] = grade_score / len(value.keys())
return student_grades
Explanation:
The course_grader function is a python program that accepts two arguments, the student dictionary and the course prefix. The function returns a dictionary of the student id as the key and the average grade of the student as the value.
cutting of trees is bad or not bad
Answer:
bad
Explanation:
it gives out air and oxygen
Amber is working as an intern at a local law firm to learn all she can about the field of law. She is having a difficult time completing her work on time because she doesn't understand everything. What can Amber do?
Ask her manager for help.
Look for another internship.
Look up information online.
Stay late to finish the work.
Answer:
i think c
Explanation:
not sure
Answer:
A . ask her manager for help.
Explanation:
Suppose a switch is built using a computer work station and that it can forward packets at a rate of 500,000 packets per second, regardless (within limits) of size. Assume the workstation uses direct memory access (DMA) to move data in and out of its main memory, which has a bandwidth of 2 Gbps, and that the I/O bus has a bandwidth of 1 Gbps. At what packet size would the bus bandwidth become the limiting factor
Answer:
When the transmission exceeds 667 packets
Explanation:
In computer networking, a packet is a chunk of data transmitted across the network. The packet size of an Ethernet network is 1.5kilobytes, while the packet size of an IP packet payload is 64 kilobytes.
A switch is a physical network device that connects nodes or workstations while communicating the packets (or frames). The I/O bus size bandwidth is 1Gbps which allows approximately 667 packets. Once this packet size is crossed, the bus becomes a limiting factor or bottle neck.
You need to update your router settings, so you log into the administration panel, Whose Internet protocol (IP) address is 192.168.0.1. which IP version is this?
A-IPv4
B-IPv2
C-IPv6
D-IPv1
Answer:
D
Explanation:
The material inspection and recieving report the multi-purpose document that serves as evidence of inspection and acceptance, shipping document, receiving document, and contractor invoice is designated as the:________.
Answer:
DD Form 250
Explanation:
DD Form 250 which is an acronym for Department of Defense Form 250.
It is the Material Inspection and Receiving Report that is used for contracts supplies and services including acquiring noncommercial commodities such as:
1. Acknowledgment of equipment by the Government
2. Contractor's invoice for expense.
3. loading record for hauling and acquiring.
4. Proof of Government Quality assessment.
Hence, in this case, the correct answer is DD Form 250.
Below is an ERD showing the 1:M relationship between Department and Employee entity types. This relationship is modeled as a Department JSON object as:Department: deptID,deptName,deptRoom,{deptPhone},{employee: empID, empName,empPhone,{empEmail}}Where {} indicates multi-valued.Part 1: Open the mydb database we created earlier and create a new department table with two fields:documentid (as an integer field) Jsondocument (as a JSON field)And add around 3 departments and each with 2 or 3 employees.Part 2: Use SQL to answer the following questions:Q1: Select all the records in the table.Q2: List the department names with their phones.Q3: A query to show the deptName and number of employees of the department.Q4: A query to show all the employees of a department of your choice using deptName as criteria.USE MYSQL
Answer:
hi
Explanation:
In python, Write a function (name: identi Substring) that, given a string S, returns an integer that represents the numbers of ways in which we can select a non-empty substring of S where all of the characters of the substring are identical. Two substrings with the same letters but different in locations are still considered different. For example, the string "zzzyz" contains 8 such substrings. Four instances of "z", two of "zz", one of "zzz" and one instance of "y". String "k" contains only one such substring:"k". The length of S will be between 1 and 100, inclusive. Each character in S will be a lowercase letter (a-z).
Answer:
def identiSubstring(S):
n = len(S)
inst = ""
count= 0
for Len in range(1,n+1):
for i in range(n-Len+1):
for k in range(i,i + Len):
inst =inst+S[k]
if(len(set(inst)) == 1):
count = count + 1
inst = ""
return count
S = input("Enter a string: ")
if(len(S)>=1 and len(S)<=100):
print("There are "+str(identiSubstring(S.lower()))+" possible occurrences")
else:
print("Length is invalid")
Explanation:
This line defines the required function
def identiSubstring(S):
This calculates the length of string S
n = len(S)
This initializes an instance of the required string to an empty string
inst = ""
This initializes count to 0
count= 0
This following iterations iterate through the length of the string
for Len in range(1,n+1):
for i in range(n-Len+1):
for k in range(i,i + Len):
This gets an instance of string S
inst =inst+S[k]
This checks if the characters of the instance are identical
if(len(set(inst)) == 1):
If yes, the counter is incremented by 1
count = count + 1
This instance is reset back to an empty string
inst = ""
This returns the number of instances of the substring
return count
The main begins here
This prompt user for a string
S = input("Enter a string: ")
This checks for valid length
if(len(S)>=1 and len(S)<=100):
If length is between 1 and 100 (inclusive), this calls the identiSubstring function
print("There are "+str(identiSubstring(S.lower()))+" possible occurrences")
If otherwise
else:
This prints invalid length
print("Length is invalid")
See attachment
Question 24 Multiple Choice Worth 5 points)
(01.04 MC)
Zavier needs to compress several files. Which file type will allow him to do this?
ODOC
GIF
OJPG
O ZIP
Answer:
ZIP
Explanation:
ZIP is a type of compression file as Jpg is a picture file, Gif is a picture file, and ODOC stands for Oklahoma Department of Corrections
TBH:
it may be O ZIP but i've never heard of it.
Answer:
Zip (D)
Explanation:
Took The Test
Before we can use the PS Session to remotely manage a target system, there are certain tasks we must perform, such as create exception in Firewall and enable WinRM. PowerShell has a cmdlet that can perform all of these tasks at once.
A. Start-PSRemoting.B. Enable-PSRemoting.C. Enable-PSSession.D. Get-PSRemoting.
Answer:
B. Enable-PSRemoting.
Explanation:
Powershell is a command-line interface software used in windows operating system to manage the operations of the system. It is similar to the bash terminal scripting language in Linux and has some of the command prompt features.
The PS session is used to manage remote systems connected wirelessly to the administrative system. The command used to enable this process is "Enable-PSRemoting".
It is said that Wifi repeater is not good as a rumor
what type of computer is an ATM attached to ?
Adam is so good at playing arcade games that he will win at every game he plays. One fine day as he was walking on the street, he discovers an arcade store that pays real cash for every game that the player wins - however, the store will only pay out once per game. The store has some games for which they will pay winners, and each game has its own completion time and payout rate. Thrilled at the prospect of earning money for his talent, Adam walked into the store only to realize that the store closes in 2 hours (exactly 120 minutes). Knowing that he cannot play all the games in that time, he decides to pick the games that maximize his earnings
Sample game board at the arcade GAME COMPLETION TIME (in minutes) PAYOUT RATE Pac-man 90 400 Mortal Kombat 10 30 Super Tetris 25 100 Pump it Up 10 40 Street Fighter II 90 450 Speed Racer 10 40
An acceptable solution is the one where it still picks the best earnings even when the list of games or completion times or payout rates change.
Question:
Write code in Java/Scala/Python to help Adam pick the sequence(s) of games that earn him the most money?.
Then, assume you have a variable list of games and their payout rates. What is the best way to pick the games that earn you the most?
Input Explanation
The first line of input is always an integer denoting many lines to read after the first line. In our sample test case, we have 6 in the first line and 6 lines after the first line, each having a game, completion_time and payout_rate.
In each data line, the game, completion_time and payout_rate are separated by a ','(comma).
The games board may change but the store still closes in 120 minutes.
Input
6
Pac-man,80,400
Mortal Kombat,10,30
Super Tetris,25,100
Pump it Up,10,40
Street Fighter II,90,450
Speed Racer,10,40
Output Explanation
Print the game names that earn him the most into the standard output in alphabetical order
Output
Mortal Kombat
Pump it Up
Speed Racer
Street Fighter II
Answer:
ask it to ur teacher boiiiiii
If I want to control the aperture and I want the camera to control the shutter speed which setting on the mode dial is most appropriate?
a)AV
b) TV
c) M
d) P
since this is my last question im giving 100 points and brainliest
Answer:
answer is a
hopes this helps
Krista needs to configure the default paste options in PowerPoint 2016. Which area of the Options dialog box will she need to use to configure these options?
Proofing
General
Save
Advanced
Answer:
[tex]\red{\underline{\underline{\sf{Answer :-}}}} [/tex]
★ Advanced
Answer: General
Explanation:
Write an algorithm and draw a flowchart to enter the length and width of any room then check if length and width are equal find area and circumference of the square room. Otherwise, find the area and circumference of the rectangle room.
Answer: i have no clue
Explanation:
If there is a need to write code in order to help the player move through the game, which team member would create this code?
Answer:
the main programmer
Explanation:
or the person who studies the algorithm and writes the code
hence, the programmer or main programmer
A software engineer is somebody who develops, creates, maintains, tests, and evaluates software using principles of software development. The term "programmer" is sometimes used as a synonym, although it may also imply a lack of engineering degrees or abilities.
Software developers, sometimes known as software architects, collaborate closely with clients to plan and develop software. Most software engineers do not start coding, they do establish a strong foundation in programming skills in order to communicate successfully with programmers.It must cover the full software development, commencing with only an analysis of the needs and ending with the design, test, and development of the technology to suit these goals.Therefore, the answer is "Software Engineer".
Learn more:
brainly.com/question/23661471
April is worried that she is not a "good speller" so she plans to let the spelling checker correct all her mistakes. What would be the most helpful advice for April?
Answer:
Likely, the best option would be to use the "auto-correct" function found on Microsoft Word or Google Docs. There are other forms of spell-checking such as Grammarly or by using a dictionary.
Explanation:
They have tools meant for checking for grammatical errors and can be used to better enhance your overall writing.
which port is used for RDP
Answer:
RDP servers are built into Windows operating systems; an RDP server for Unix and OS X also exists. By default, the server listens on TCP port 3389 and UDP port 3389. Microsoft currently refers to their official RDP client software as Remote Desktop Connection, formerly "Terminal Services Client".
Explanation:
Usually using TCP port 3389, the Remote Desktop Technology (RDP) is a Microsoft-exclusive protocol that permits remote connections to other computers.
What is RDP?RDP stands for remote desktop protocol. It is defined as a proprietary protocol created by Microsoft that offers a graphical user interface for connecting to another machine over a network connection Using the Remote Desktop Protocol, remote users can access and utilize Windows on a device in a different location (RDP).
The server often listens on both UDP port 3389 and TCP port 3389. It makes use of port 443, which employs an SSL tunnel to send data. In order to increase network security, port 3389, which is used for Remote Desktop connections, is restricted.
Thus, usually using TCP port 3389, the Remote Desktop Technology (RDP) is a Microsoft-exclusive protocol that permits remote connections to other computers.
To learn more about RDP, refer to the link below:
https://brainly.com/question/3895875
#SPJ2
if resistors were 10 times larger what would happen to output voltage
Answer:
is there a picture to go w the question?
write a function named list_total that accepts a list as an argument (assume the list contains integers) and returns the cumulative total of the values in the list
Answer:
def listSum(mylist):
sum =0
for item in range(0,len(mylist)):
sum=sum+mylist[item]
print(sum)
Explanation:
Using the Python programming language, I defined a function as listSum that accepts a list as a parameter and returns the sum of the elements in the list.
The most important logic here is defining the range of elements in the list not to exceed the length of the list using the len function. Then using a for statement, we loop through each element and add them up to a sum variable initially assigned the value of 0.
how to earn money fast in adopt me?
Answer: If you want money in adopt me quickly, you could become a baby and buy a pet and take care of it and yourself. Also, you could purchase adopt me bucks with robux.
Explanation:
Given all of the limitations of MBR, is it still relevant in current day use?
Explanation:
MBR does have its limitations. For starters, MBR only works with disks up to 2 TB in size. MBR also only supports up to four primary partitions—if you want more, you have to make one of your primary partitions an “extended partition” and create logical partitions inside it.
For an interview, the most used microphone types are
A. Boom mics, long range mics
B. Strap, studio recording mics
C. Lapel or handheld
D.No mics are needed
For all programs, you should write a small amount of code and _______
it before moving on to add more code?
Answer:
test
Explanation:
One newly popular development paradigm is "test-driven development"; which borrows agile engineering principles in architecting project components.
A hacker successfully modified the sale price of items purchased through your company's web site. During the investigation that followed, the security analyst has verified the web server, and the Oracle database was not compromised directly. The analyst also found no attacks that could have caused this during their log verification of the Intrusion Detection System (IDS). What is the most likely method that the attacker used to change the sale price of the items purchased
Answer:
By modifying the hidden form values that is in a local copy of the company web page
Explanation:
In a situation were the hacker successful change the price of the items he/she purchased through the web site of the company's in which the company web server as well as the company Oracle database were not compromised directly which means that the most likely method in which the attacker used to modified the sale price of the items he/she purchased was by modifying the HIDDEN FORM VALUE that was in the local copy of the company web page making it easy for the HIDDEN FORM VALUE to be vulnerable to the hacker because the hidden form value did not store the company server side information or data but only store the company software state information which is why HIDDEN FORM VALUE should not be trusted.
Exodia
Principle of Computer Operation
Answer:
????
Explanation:
What is the best approach to testing a website? visit all pages to verify that they load visit every page and verify all links visit the pages with hyperlinks visit all pages that appear on the navigation menu
Answer:
B. visit every page and verify all links
Explanation:
I just took the test, and only one year late.
Answer:
THe answer s b
Explanation: