The SQL Query for the average quoted price, maximum quoted price, and minimum quoted price of all orders is given below:
The SQL QueryDisplay itemcode and descr of those items.
Filter Closed and Rejected Quotations.
SELECT * FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
Find maximum price of those quotations.
SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
Fetch the itemcode of the quoation.
SELECT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE= (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed'))
Display the details of the fetched item.
SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN (SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE = (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')))
However, the following query doesn't show a logical error:
SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN
(
SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE =
(
SELECT MAX(QUOTEDPRICE) FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
)
AND QSTATUS IN ('Rejected','Closed')
)
Read more about SQL here:
https://brainly.com/question/27851066
#SPJ1
I have no idea how to do this coding project.
Using the knowledge of the computational language in JAVA it is possible to write a code that repeating task is sent using one of the MessageBuilder's repeatXXX() methods.
Writting the code:MessageBuilder.createMessage()
.toSubject("FunSubject")
.signalling()
.withProvided("time", new ResourceProvider<String>() {
SimpleDateFormat fmt = new SimpleDateFormat("hh:mm:ss");
public String get() {
return fmt.format(new Date(System.currentTimeMillis());
.toSubject("TimeChannel").signalling()
.withProvided(TimeServerParts.TimeString, new ResourceProvider<String>() {
public String get() {
return String.valueOf(System.currentTimeMillis());
}
See more about JAVA at brainly.com/question/18502436
#SPJ1
How do I do this coding project?
import java.util.*;
class prog
{
public useProperGrammar( String text)
{
int i;
char ch;
String p;
for(i=0;i<text.length();i++)
{
ch = text.charAt(i);
if(ch=='2')
{
p = text.replace('2','to');
}
}
System.out.println("Corrected text:" +p);
}
}
Please compile it before putting to use since I haven't done any compiling work.
Using the knowledge of the computational language in JAVA it is possible to write a code that write a functions that countain a string using the function signature.
Writting the code:import java.util.*;
class prog
{
public useProperGrammar( String text)
{
int i;
char ch;
String p;
for(i=0;i<text.length();i++)
{
ch = text.charAt(i);
if(ch=='2')
{
p = text.replace('2','to');
}
}
System.out.println("Corrected text:" +p);
}
}
See more about JAVA at brainly.com/question/18502436
#SPJ1
If $due_date contains a DateTime object for a date that comes 1 month
and 7 days before the date stored in the $current_date variable, what will $overdue_message contain
when this code finishes executing:
a. 0 years, 1 months, and 7 days overdue.
b. -0 years, -1 months, and -7 days overdue.
c. 1 month and 7 days overdue.
d. $overdue_message won’t be set because the if clause won’t be executed
a. 0 years, 1 months, and 7 days overdue.
For this task you have the chance to show what you’ve learned about implementing repetition in code. You are required to create a program that uses the while loop structure.
Write a program that always asks the user to enter a number. When the user enters the negative number -1, the program should stop requesting the user to enter a number. The program must then calculate the average of the numbers entered excluding the -1.
Make use of the while loop repetition structure to implement the program.
Explanation:
#include <stdio.h>
main(){
int x,c=0,sum=0;
float a;
printf("enter a number (don't enter -1)\n");
scanf("%d",&x);
while(x!=-1){
c++;
sum+=x;
printf("enter a number(enter -1 to calculate the average)\n");
scanf("%d",&x);
}
a=float(sum)/c;
printf("the average is %.2f ",a);
}
Which of the following is the outline of all the stages games go through when
being developed?
(1 point)
production cycle
design cycle
scientific method
alpha stages
Product Cycle is all the stages games go through when being developed.
What's product cycle?
The product cycle is the period of time from the morning of processing to the finished product during which stocks( raw accoutrements , accoutrements ,semi-finished corridor, and finished factors) live in the manufacturing process. It takes up some of the manufacturing time and comprises of processing and halting phases.
Product cycle for developing a game :
Stage 1 of the game development process :
Although each step in the game development process is important, the original planning cycle has a direct impact on all posterior cycles. It's critical to begin the process of creating a computer game by gathering details about the willed end product, similar as technological specifications.
Stage 2 The product :
The product stage, which is broken down into multiple internal stages, is the stage that takes the longest and requires the topmost labor.
Stage 3 Quality control :
A game of any complexity needs to be tested to insure that it's error-free and bug-free. This is due to the fact that a single issue can have a negative impact on both the stoner experience and the overall enjoyment of a game. As a result, functional,non-functional, and beta testing are constantly carried out.
Stage 4 Launch :
The final stage of game product is the product debut, which is largely anticipated by all. But the story does not end with launch. Indeed after a game is finished, there are generally still enough bugs and faults, thus the game development platoon keeps adding new features and perfecting the game coincidently with its release. At the same time, testers gather the first stoner feedback to help inventors make significant adaptations.
Stage 5 Post-production :
Fixes and upgrades need to be continually covered after a game is released on the request to insure that it's stable and performing as intended. Studios should immaculately release updates constantly to cleave to the evolving specialized specifications of platforms.
Learn more about production cycle of game developement click here:
https://brainly.com/question/26006886
#SPJ1
You are reorganizing the drive on your computer. You move several files to a new folder located on the same partition. When you move the files to the new folder,
what happens to their permissions?
Businesses frequently use a VPN to provide remote workers with access to internal software and data or to establish a single shared network among numerous office locations.
What is a VPN, and why do businesses use them?An encrypted connection between user devices and one or more servers is established by a virtual private network (VPN), a service that provides Internet security. A VPN can safely link a user to the internal network of a business or to the Internet at large. Businesses frequently use a VPN to provide remote workers with access to internal software and data or to establish a single shared network among numerous office locations. The ultimate objective in both situations is to keep web traffic, especially traffic with proprietary data, off the public Internet.To Learn more about VPN refer to:
https://brainly.com/question/16632709
#SPJ9
Businesses frequently use a VPN to provide remote workers with access to internal software and data or to establish a single shared network among numerous office locations.
What is a VPN, and why do businesses use them?An encrypted connection between user devices and one or more servers is established by a virtual private network (VPN), a service that provides Internet security.A VPN can safely link a user to the internal network of a business or to the Internet at large.Businesses frequently use a VPN to provide remote workers with access to internal software and data or to establish a single shared network among numerous office locations. The ultimate objective in both situations is to keep web traffic, especially traffic with proprietary data, off the public Internet.To Learn more about VPN refer to:
brainly.com/question/16632709
#SPJ9